MySQL strange error Host 127.0.0.1 is not allowed to connect

Hi there,

What's your connection details?

Try using "localhost" instead of "127.0.0.1" for the server's address.

If that will do then most likely you have configured MySQL to disallow connecting via TCP sockets.

I solved in this way:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

You might want to run this:
     SELECT User, Host, Password FROM mysql.user;

You might see something like this:

+------+-----------+----------+
| User | Host      | Password |
+------+-----------+----------+
| root | localhost |          |
| root | 127.0.0.1 |          |
| root | ::1       |          |
|      | localhost |          |  <<< this is an anonymous user!
+------+-----------+----------+
4 rows in set (0.00 sec)

You might want to then do this.
SET PASSWORD FOR 'root'@'localhost'= PASSWORD('THEPASSWORD');
SET PASSWORD FOR 'root'@'127.0.0.1'= PASSWORD('THEPASSWORD');
SET PASSWORD FOR 'root'@'::1' = PASSWORD('THEPASSWORD');

For the anonymous user you can set the password unless you want anonymous connections.
SET PASSWORD FOR ''@'localhost'= PASSWORD('THEPASSWORD');