Enable Remote Access to MySQL Server on Windows

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:

  • Open a DOS command prompt on the server.
  • Run the following command from the mysql\bin directory:
$ mysql -u root --password=
  • A mysql prompt should be displayed.
  • 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;
mysql> exit;
Enable Remote Access to MySQL Server on Windows
2 votes, 5.00 avg. rating (98% score)