HostingRails.com

Please verify the following link to download and install cocoamysql.
------
http://sourceforge.net/projects/cocoamysql/

http://www.hoboes.com/NetLife/MySQL/Installation.html
------

We can do this for you, if you can enable software support package for your VPS account via account center.

Hi Rahul,

Actually I already have cocoamysql. The problem is that it won't connect to the mysql server on my virtual server. I can't connect with the command line either. I tried:

mysql -h 'my ip address' -u myusername -pmypassword


but it just hangs.


same thing when i try to connect with cocoamysql.  It just hangs.

I thought maybe i need to open a port on the firewall but I dont know how.

Hello,

Ok, I have understood the issue. Are you facing this issue for the database named "piecemaker". Also I believe the other database named "test" is working fine (I.E) You can connect to the DataBase remotely from your local end. Please confirm the status from your end. We will fix this for you.

Sorry, but I can't connect at all. I tried this at the terminal

mysql -h [ip address] -u myusername -p

it just hangs. I don't even get an access denied message.

Ok.. The issue was because the port 3306 was not opened in the server firewall. I have opened it now. Also I have added grant-privileges to the mysql user (details was available in the database.yml file).

Now you will be able to connect to your database remotely. Please check and confirm status from your end now.

Thanks Rahul It works.

Hello-

I am trying to do the same this - access my MySQL db from my laptop.

i see above, the unix command is:

mysql -h [ip address] -u myusername -p

but what is the IP address?  how do I find mine?

Thanks!

Hi Jetson,

mysql -h [ip address] -u myusername -p

ip address --- IP assigned to your account or the IP address to which your domain is pointing.

You can confirm it from your account center >>  Account Details.

I've got port 3306 open and all the permissions seem to be right yet still can't get a remote connection.

Any more suggestions?

Hi Lbau - Since you are using webmin as your control panel, for remote access of Mysql Databases :

Webmin >> Servers >> MySQL Database Server >> Edit Hosts Permissions >>

Create the username you want to use to connect to your database with, set the HOSTS to ANY and then grant the permissions you want.

Already done, my friend.  Still no dice.

Hi - Could you please post a ticket to the support with your database details so that we can check this at our end. Thank you