On Linux, we can easily enable remote access to MySQL server, here is an article talking about that. On Windows, the approach is different.
Here’s the steps:
1. Open a DOS command prompt on the server.
2. Run the following command from the mysql\bin directory:
mysql -u root –password=
3. A mysql prompt should be displayed.
4. To create a remote user account with root privileges, run the following commands:
GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@'IP’ IDENTIFIED BY ‘PASSWORD’;
‘USERNAME’ is the username to be created.
‘IP’ is the public IP address of the remote connection.
‘PASSWORD’ is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)
mysql> FLUSH PRIVILEGES;