Unable to log in to phpmyadmin, report 1130 error resolution

phenomenon: After installing mysql, mysql find phpmyadmin can not log in, return error 1130, but the line in the login mysql -u root -p mysql command

analysis and solutions:
After querying mysql's 1130 error is caused by remote access users without remote permissions. Solution: After logging in to mysql locally, change the “host” entry in the “user” table in the “mysql” from ' localhost” to '%'. Mysql -u root -p mysql>use mysql; mysql>select 'host' from user where user='root'; mysql>update user set host = '%' where user ='root'; mysql>flush privileges; mysql> Select 'host' from user where user='root'; The first sentence is to log in as the user root. Second sentence: Select mysql library Third sentence: View the host value of the user table in the mysql library (you can connect to access Host/IP name) Fourth sentence: Modify the host value (add the host/IP address with the content of the wildcard %), of course, you can also directly increase the IP address. Fifth sentence: Refresh the MySQL system permission related table. Sixth sentence: Re-review The user table has been modified. . Finally, restart the mysql service to complete.