Remote MySQL

[EchoHost]

I want to make it so i can access MySQL from a program on my computer. I'm just not sure how to do that.

Any help is appriciated!

Thanks

 

[webignition]

I can't help you with using a program on your computer to access MySQL on a Cpanel server - this depends on the program.

However assuming that you know how to configure the program correctly, you will also need to specify which remote hosts are allowed to access a given database.

In Cpanel enter the main MySQL menu and at the bottom you will see "Access hosts". Just add the IP of the remote machine (remote with respect to your Cpanel server) to which you want to grant access to the database.

 

[eth00]

Do not forget to allow port 3360 tcp open to the person that wants to access mysql remotely.

 

[nottheusual1]

I want to make it so i can access MySQL from a program on my computer. I'm just not sure how to do that.

Any help is appriciated!

Thanks

If you are on a WIN box you will need to set up an ODBC data connection using a MYSQL driver. You can start here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

to get the driver. The WIN help system can get you through creating the ODBC connection - you'll need a data host (your domain or IP address), a MySQL database name, login, and password.

If you've also done as the others suggested, you'll be able to hook-up using any program that can utilize the ODBC connection.

 

[Blue|Fusion]

If the program you want to use with MySQL on your PC can change the host with the other user/password/database options, you don't even need to mess with ODBC. Simply change the host from 'localhost' to your server's IP or hostname. You'' have to open port 3306 (not 3360) in your server's firewall and make sure skip-networking is NOT in /etc/my.cnf.

 

[djalpha]

If the program you want to use with MySQL on your PC can change the host with the other user/password/database options, you don't even need to mess with ODBC. Simply change the host from 'localhost' to your server's IP or hostname. You'' have to open port 3306 (not 3360) in your server's firewall and make sure skip-networking is NOT in /etc/my.cnf.

great solution for me.
most mysql tweak comes with skip-networking we must remove this line if whisesd remote access.