LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Networking (https://www.linuxquestions.org/questions/linux-networking-3/)
-   -   Connecting to a Remote MySQL Server (https://www.linuxquestions.org/questions/linux-networking-3/connecting-to-a-remote-mysql-server-493484/)

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?

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!


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