Adapt this process as necessary. Note: This process is almost exactly the same for mariadb.

The IP addresses shown are examples only. Some of this content has been replicated from here.

1. Logon to your Fedora box and open a terminal (use a ssh client, like Putty, if you are doing this from the Windows 7 machine). Switch to root (you will be prompted for your fedora-username password):

   sudo -i
   

2. Edit /etc/my.cnf using an editor like nano (recommended over vi if you are a Linux newbie):

   nano /etc/my.cnf
   

3. Locate and edit the bind-address, must be your Fedora machine external IP address, not localhost. Comment out the skip-networking by prefixing it with an asterisk (#). For example:

   [mysqld]
   user            = mysql
   pid-file        = /var/run/mysqld/mysqld.pid
   socket          = /var/run/mysqld/mysqld.sock
   port            = 3306
   basedir         = /usr
   datadir         = /var/lib/mysql
   tmpdir          = /tmp
   language        = /usr/share/mysql/English
   bind-address    = 192.168.0.10                # example address shown
   # skip-networking
   ...
   

   Save your changes. Note: If you need to determine the IP address of your Fedora machine, use the appropriate address from the output of:

   ip addr show | grep inet
   

4. Update the mysql server service using systemctl:

   systemctl enable mysql    # ensures the services starts at boot time
   systemctl restart mysql   # assumes mysql server is already running
   

   Note: use man systemctl to find more commands, but the common commands are 'reload', 'start', 'stop', 'status' and 'disable'.
5. Login to mysql server and grant access to the remote (Windows) IP address:

   mysql -u root -p mysql
   

   To create a user, admin, able to login from anywhere and administer all databases, including granting rights to other users (superuser), enter:

   mysql> CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
   mysql> GRANT ALL PRIVILEGES ON *.* TO 'bar'@'%' WITH GRANT OPTION;
   

   To grant access to a new database, foo, for user bar, and from a specific remote IP 192.168.0.20, enter:

   mysql> CREATE DATABASE foo;
   mysql> GRANT ALL PRIVILEGES ON 'foo'.* TO 'bar'@'192.168.0.20';
   

   To grant access to an existing database, webdb, user webadmin, and remote IPs 192.168.0.0/24, enter:

   mysql> GRANT ALL PRIVILEGES ON 'webdb'.* TO 'webadmin'@'192.168.0.%';
   

   Logout of mysql server:

   mysql> exit
   

   Note: Use 'localhost' for users that will only ever connect from the local machine.
6. Enable access through the firewall:

   firewall-cmd --permanent --add-service=mysql
   firewall-cmd --reload
   

   The above updates the default 'zone' with the predefined mysql server port settings (firewalld ships with a large selection of common services predefined, including mysql.) Use --zone=NAME to update a different firewall zone. As an aside; the same service name can be used for mariadb.
7. Test or begin using the mysql server from Windows.

Change as necessary for additional remote connection clients.

First you'll need to enable access from remote IPs in your MySQL configuration. After that you will probably need to open up port 3306 which is default port for MySQL. You can do that by following this guide: link