Linux root user login MySQL database permissions are limited

Found a strange problem today, the root user login MySQL database suddenly become restricted permissions, no permissions MySQL Library

My solution is to add a ship-grant password in the my.cnf config file to log in to the database using the root account, to see that all databases can be viewed, and then reset the root account permissions

Grant all on * * to ' root ' @ ' localhost ' identified by ' password ';

Quit MySQL Cancel #skip-grant and then restart the MySQL service, log in again with root mysql everything is ok!

This article is from the "10999243" blog, please be sure to keep this source http://11009243.blog.51cto.com/10999243/1758234

Linux root user login MySQL database permissions are limited