How to connect to the db via mysql.domain.com?


#1

I have setup a db and can access via dreamhost’s phpmyadmin and I would like to use my mysql client to connect.

But when I tried to connect to mysql.domain.com it says I am not allowed to connect with xxx.xxx.xxx.xxx ip, which is my remote ip.

How can I connect to the db remotely?


#2

[quote]How can I connect to the db remotely?
[/quote]
From the Control Panel -> Goodies -> Manage MySQL screen, click on the linked name of the user you want to be able to connect remotely (under the “Users with Access” column), and edit the “Allowable Hosts” field.

Submit the form, and you are done! :wink:

–rlparker