-   Linux - Networking (
-   -   Connecting to a Remote MySQL Server (

msound 10-18-2006 07:50 AM

Connecting to a Remote MySQL Server
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?


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!

All times are GMT -5. The time now is 04:50 PM.