host 127.0 0.1 is not allowed to connect to this mysql server 1

host 127.0 0.1 is not allowed to connect to this mysql server

UPDATE mysql.user SET host='%' WHERE user='root';

Here is what the above code is Doing:
1. We’re using the mysql.user table to update the host field for the root user.
2. We’re setting the host field to %, which allows root to connect from any host.
3. We’re using WHERE to specify that we only want to update the root user.

Similar Posts