Connecting to a Remote MySQL Server

msound · 10-18-2006, 07:50 AM

I'm currently running MySQL on my home server. I'd like to connect to it from my Ubuntu Desktop using MySQL Administrator. On the server I've opened tcp & upd port 3306 (or whatever the port is, sorry i'm not in front of the server right now). I keep getting a permission error when I try to connect.

When I use the MySQL Administrator locally on the DB server, I can connect to it just fine. Is there a setting in MySQL that I have to configure to allow a remote host to connect?

Thanks.

diilbert · 10-18-2006, 12:03 PM

You have to connect to the MySQL server on the localhost and add a user with any host or '%' access. By default users only have access from the localhost.

msound · 10-18-2006, 12:07 PM

Cool I'll give that a shot. Thanks!