LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   MySQL client/server connection problem (https://www.linuxquestions.org/questions/linux-server-73/mysql-client-server-connection-problem-526076/)

crashsystems 02-06-2007 10:19 AM

MySQL client/server connection problem
 
I've installed the MySQL server on a Debian Etch box in my office. After installation, I set up the root password, and commented out the config file line that makes it bind to the loopback interface. When I try to connect to the server from any of the hosts on my network, it says that the connection for the host was refused. I need to be able to connect to the db from anywhere in the internal network. I'm sure that I'm just missing a configuration step somewhere. Does anyone know where I should be looking? Thanks.

asommer 02-06-2007 10:51 AM

Did you enter the grant statement inside the MySQL console?

Should be something like:
grant all on *.* to root@"%" identified by 'password';

You should change the "all", "*.*", "root@"%"" and 'password' to whatever is appropriate for your setup.

crashsystems 02-06-2007 12:05 PM

That did the trick. Thanks for your help.


All times are GMT -5. The time now is 10:09 AM.