View Single Post
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
Old 11-23-2012 , 14:10   Re: Frequently Asked Questions (FAQ)
#20

Q: My mysql server gives a 'Server error: Access denied for user 'user'@'host' (using password: YES)' error.
Q: My mysql server won't let my webserver connect.
Q: My mysql server only allows connections from localhost.

A:On a linux machine you can do the following:

  1. Locate the mysql config file (usually located in /etc/mysql/, called 'my.cnf').
  2. Edit the file with a text editor and search for the string "bind-address=".
  3. My guess is the file only has "bind-address=127.0.0.1" set, change that into "bind-address=your.internet.ip.address".
  4. Exit and save the text editor.
  5. Restart the mysql server (/etc/init.d/mysql restart).
  6. Restart the daemon and wait for the servers to connect!
__________________
Mavrick4283 is offline