mysql-error-1130

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

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 … Read more

Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server

Possibly a security precaution. You could try adding a new administrator account: mysql> CREATE USER ‘monty’@’localhost’ IDENTIFIED BY ‘some_pass’; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’localhost’ -> WITH GRANT OPTION; mysql> CREATE USER ‘monty’@’%’ IDENTIFIED BY ‘some_pass’; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’%’ -> WITH GRANT OPTION; Although as Pascal and others … Read more