Troubleshoot MySQL "Access denied for user ' root ' @ ' IP address '" issue

After building the MySQL database according to the method in the previous article, it is found that the other machines are still inaccessible.

After modifying the permissions, refer to the following article to find that root in the local machine is inaccessible.

Http://www.cnblogs.com/ycsfwhh/archive/2012/08/07/2626597.html

Later use select Host, user, grant_priv from user;

Find Grant_priv A list of issues, only users with Grant_priv can grant permissions to other users.

Modify it to the following so that's fine.

+-------------------------------------------------+------+------------+| Host                                            | user | Grant_priv |+-------------------------------------------------+------+------------+|%                                               | root | Y          | | gzns-ecom-baiduhui-201605-m42n02.gzns.baidu.com | root | Y          | | 127.0.0.1                                       | root | Y          | |:: 1                                             | root | Y          | | localhost                                       |      | N          | | gzns-ecom-baiduhui-201605-m42n02.gzns.baidu.com |      | N          | | localhost                                       | root | N          |+-------------------------------------------------+------+------------+

Troubleshoot MySQL "Access denied for user ' root ' @ ' IP address '" issue