MySQL Forums
Forum List  »  PHP

Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server
Posted by: Jan Brink
Date: May 25, 2007 07:41AM

Debian

Start mysql -u root -p on mysql server
enter root password

mysql>use mysql
mysql>update user set host='your-ip' where host='debian'
mysql>quit

restart mysql

debian:~# /etc/init.d/mysql restart

bingo !

better : create an entry in user table with permissions to connect from ip's you need instead of %

Options: ReplyQuote


Subject
Written By
Posted
Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server
May 25, 2007 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.