ERROR 1130
Posted by: rodotheos (---.otenet.gr)
Date: November 04, 2006 09:52PM

Hi,
I have just installed the new wamp5 server and after trying to change the root password I'm getting the following error message:

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MYSQL server

I did the following...
>mysql -u root mysql
mysql> update user set password='my_new_password' where user='root';
mysql>flush privileges;

What I have done wrong?
Do I need to change something else?

Options: ReplyQuote
Re: ERROR 1130
Posted by: yfastud (---.il-chicago0.sa.earthlink.net)
Date: November 05, 2006 12:10AM

Yes, check this post:

[forum.wampserver.com]

Options: ReplyQuote
Re: ERROR 1130
Posted by: CyberSpatium (71.237.217.---)
Date: November 05, 2006 09:00PM

you need to add the new password to your phpmyadmin config file.
C:\wamp\phpmyadmin\config.inc.php

find:
$cfg['Servers'][$i]['password'] = '';

change to:
$cfg['Servers'][$i]['password'] = '_Your_New_Password_Here_';

for more info about changing passwords, permissions, and adding users with phpmyadmin, see my very detailed tutorial here:
[forum.wampserver.com]


CyberSpatium
WAMP English Forum Admin

Options: ReplyQuote


Sorry, only registered users may post in this forum.