mysqldatabasephpmyadminprivilegesmysql-error-1130

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

I issued a command of:

DROP USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';

...in PhpMyAdmin. Immediately after the execution, I was forced out PhpMyAdmin. I got:

error

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

how to resolve my problem?

Solution

  • Use the IP instead:

    DROP USER 'root'@'127.0.0.1'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';

    For more possibilities, see this link.

    To create the root user, seeing as MySQL is local & all, execute the following from the command line (Start > Run > "cmd" without quotes):

    mysqladmin -u root password 'mynewpassword'

    Documentation, and Lost root access in MySQL.