ABHIONLINUX
Site useful for linux administration and web hosting

2009/08/15

How can I setup a remote connection to MySQL?

To remotely connect to your MySQL databases, you must have an I.P.-based account. Login to your control panel and click on the side menu "ValueApps" then the "Database" tab. If you have not installed MySQL, click on "MySQL Database" under Available ValueApps. If you have already installed MySQL, click on "MySQLs" under Installed ValueApps. Check the box "TCP/IP Connection". Now login to your account via SSH.

STEPS:
You have to login to MySQL first.
mysql -u root -p
(will prompt for password)

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

*.* -- All Database or DatabaseName.*
USERNAME - Username
IP -- IP that needs to be allowed to connect to this server remotely.

No comments:

Post a Comment