This tutorial will show you how to allow remote login to MySQL server for specific user. By default MSQL servers allow connections only from localhost.
You have to login to ssh (Secure Shell) and have root privileges.
You have to do the following in after you login ssh.
How to allow remote connection to MySQL
|
%mysl_bin%\mysql -u aUSERNAME -p
USERNAME is the MySQL administrator user. You will have to provide the password fro that user.
Your shell prompt should now look like this:
Your shell prompt should now look like this:
mysql>
Run this command:
grant all privileges on *.* to USER@IP identified by "PASSWORD";
USER is the username that you would like to give permissions for remote login.
IP is the public IP address of your remote connection.
PASSWORD is the password you would like to use for this username.
You now must flush MySQL\'s privileges. Run this command:
IP is the public IP address of your remote connection.
PASSWORD is the password you would like to use for this username.
You now must flush MySQL\'s privileges. Run this command:
FLUSH PRIVILEGES;
Run this command to exit MySQL:
exit;
Need a specific tutorial? Do not hesitate and submit a request!
posted on 2009-Jun-03 | 02:19:22 AM