#1130 - Host 'localhost' is not allowed to connect to this MySQL server
Posted by: tiksya (---.71.91.info.com.ph)
Date: August 10, 2006 08:16AM

i accidentaly drop my localhost privilidge in phpmyadmin... how can i get it back?
error goes like:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.



Error
MySQL said:

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

Options: ReplyQuote
Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server
Posted by: CyberSpatium (67.170.181.---)
Date: August 10, 2006 08:47AM

check out the second post here
[forum.wampserver.com]

Options: ReplyQuote
Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server
Posted by: tiksya (---.71.91.info.com.ph)
Date: August 10, 2006 09:01AM

1. Set password in Privilleges in phpMyAdmin from your Browser/Localhost.
Goto: localhost/phpmyadmin/
click on "Privileges" link
click on "edit Privileges" link for ROOT user
and set-up your password (change password) and click go


i can't access phpMyAdmin, it automatically blocks my access

2. Set password in config.inc.php in /wamp/phpmyadmin.
Find and put your password in this line:
$cfg['Servers'][$i]['password'] = 'Your_new_password_here'; // MySQL password (only


I've tried doing this.... but my problem is the "localhost" is the one that cannot access, even if i changed it to new password.

3. after the </directory> line above add the following:

<Directory "C:/Internet/wamp/www/phpmyadmin">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

<Directory "C:/Internet/wamp/www/sqlitemanager">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

4. change location of the directories as your might be different from "C:/Internet/wamp/www/phpmyadmin"

Also in Alias folder (/wamp/Apache2/conf/alias), replace these lines in phpmyadmin.conf and splitemanager.conf:

Order allow,deny
Allow from all

By these lines:

Order deny,allow
Deny from all
Allow from 127.0.0.1



I've done this also.... but no help...localhost denied access

Options: ReplyQuote
Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server
Posted by: CyberSpatium (67.170.181.---)
Date: August 10, 2006 10:06AM

back up your databases if you have any, save your website files, uninstall wamp, delete the entire wamp directory, then try installing wamp again.

Options: ReplyQuote


Sorry, only registered users may post in this forum.