Category >> Uncategorized  

How to 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:

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;
mysql> exit;

Category >> Uncategorized  
  • Birol Aygün

    For some reason this did not work for me. Is there a way in MySQL setup to permit remote access. I could only see “permit TCP/IP networking”, which didn’t help.