Networking, Programming and Graphics Tutorials

How to allow remote connection to MySQL [1/3]

Type: Code Networking, Programming and Graphics Tutorials
How to allow remote connection to MySQL
Level: Intermediate Networking, Programming and Graphics Tutorials Networking, Programming and Graphics Tutorials 
How to allow remote connection to MySQL
Date: 2007-Mar-04
How to allow remote connection to MySQL
Visited: 3606 times
How to allow remote connection to MySQL
Rating: How to allow remote connection to MySQL
How to allow remote connection to MySQL
Author: Stephen Think

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.

%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:

mysql>
Networking, Programming and Graphics Tutorials - How to allow remote connection to MySQL [1/3] - Networking, Programming and Graphics Tutorials

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: mysql+allow remote connection+mysql administrator+windows  allow mysql for remote connection  mysql allow remote connection  mysql "allow remote connection"  "allow remote connection" mysql  How to allow remote connection to MySQL  mysql allow remote connection  mysql "how to allow remote connection"  mysql remote connection example  how to allow remote connection in mysql  mysql remote connection  mysql ssh allow remote connection  php mysql remote connection   remote connection for mysql  c++ remote mysql connection  mysql +"allow remote connection"  remote connection to mysql  mysql remote connection allow  remote connection mysql  allow mysql remote connection