#1130 - Host 'localhost' is not allowed to connect to this MySQL server - After running an Acunetix scan
When your server is running with --skip-grant-tables, you disable all MySQL security so you're not allowed GRANT commands. What you can do, is access the "mysql" database and directly SELECT and UPDATE the rows you need to change. In your case it will be the user table.
A simple Illustrated solution!
I had the same issue.
You can add skip-grant-tables
to the my.ini file for the [mysqld]
tag, under # The MySQL server
, and restart the mysql server.
You can now open phpmyadmin and go to the user table in the mysql database. Make sure that the value of the password attribute is empty and that the value of host attribute is localhost. I was facing the second error. PHPMyAdmin was trying to connect with host value as 'localhost' and the table contained the value 127.0.0.1.
Remove skip-grant-tables from my.ini and restart the mysql server. This should work.