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.
|
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. |
That did the trick. Thanks for your help.
|
All times are GMT -5. The time now is 10:09 AM. |