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;