MySQL client/server connection problem

crashsystems · 02-06-2007, 10:19 AM

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.