How to allow remote connection to MySQL

[Gomeler]

I have problem with my MySQL server. I would like to know the procedure to connect Mysql from my machine. Is there any tool or command which allow user to access Mysql remotely. I know MySQL database server remote access disabled by default and i need to know how to enable it?

[Zecho]

To remotely connect to your MySQL databases,You'll also need to open the MySQL port (3306) on the other server if it's closed you must have an I.P.-based account. Login to your control panel and click on the side menu "ValueApps" then the "Database" tab. Your hosting accounts come with free applications (called Value Apps) that you can install. You need to run this command from

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

[Walby]

You need to enable remote connection because they are disabled as default. PHPMaker is tool that can generate a PHP from MySQL database. You have to set the privilegs for a user to access the database and last but not least you have to mak sure that the mysql porrt (usually 3306) can be used by your client.Using PHPMaker, you can instantly create Web sites that allow users to view, edit, search, add and delete records on the Web.

[Aberto]

All you need to do is specify remote mysql host with –h option. For example to connect remote mysql server called server1.test1.com you need to type command as follows

$ mysql –u ruchi –h server1.test1.com -p

OR if you with to use MySQL server ip address (175.20.1.101)

$ mysql –u vivek –h 175.20.1.101 -p

[MindSpace]

This are the useful command for mysql remote connection :

%mysl_bin%\mysql -u aUSERNAME  -p

mysql>

grant all privileges on *.* to USER@IP identified by "PASSWORD";

FLUSH PRIVILEGES;

exit;

[Katty]

mysql -u root
mysql> SET PASSWORD FOR 'ROOT'@'LOCALHOST"
> = PASSWORD('new_password');
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit