Thread
:
Frequently Asked Questions (FAQ)
View Single Post
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
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:
Locate the mysql config file (usually located in /etc/mysql/, called 'my.cnf').
Edit the file with a text editor and search for the string "bind-address=".
My guess is the file only has "bind-address=127.0.0.1" set, change that into "bind-address=your.internet.ip.address".
Exit and save the text editor.
Restart the mysql server (/etc/init.d/mysql restart).
Restart the daemon and wait for the servers to connect!
__________________
HLX:CE Post-It Board
Mavrick4283
View Public Profile
Send a private message to Mavrick4283
Visit Mavrick4283's homepage!
Find More Posts by Mavrick4283