MySQL denied access to Error 1044/1045 resolution of the problem

ERROR 1044:access denied for user: ' @127.0.0.1 ' to database ' MySQL '
The error.

Indicates that you have not delegated permissions to the remote connection account, because the security of MySQL is constantly improving, the permission settings are denied by default, you must open your own permissions.

Log in to the MySQL database with mysql-h 192.168.x.x-u root-p mysql command on the server

192.168.x.x for server real IP address

Then use the grant command to delegate permissions.

GRANT all privileges on * * to [email protected] identified by ' Root-password ' with GRANT OPTION;

GRANT all privileges on * * to [email protected] identified by ' Root-password ' with GRANT OPTION;

GRANT all privileges on * * to [email protected] '% ' identified by ' Root-password ' with GRANT OPTION;

MySQL denied access to Error 1044/1045 resolution of the problem