Root permission error and resolution during Grant command execution in Linux---mysql

Finally resolved the root user password login problem, in the new user Test1 authorization when the following error occurred, prompting root permissions problem:

Mysql> GRANT All on * * to ' test1 ' @ ' localhost ' identified by ' 123456 '; ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Check the online many ways to say # Mysqld_safe-u MySQL--skip-grant-tables old method into the change password, tried, or no effect. Later saw a great God said may be related to Grant_priv, so manually modify, restart, and then execute the grant authorization command, OK. Dare not alone, write to share with you, easy to solve the problem. 650) this.width=650; "src=" Http://img.baidu.com/hi/face/i_f03.gif "alt=" I_f03.gif "/>

Here's how to fix it:

The root user grant_priv in the user table may be in the off state N, you need to enable Y

Update user Set Grant_priv = ' Y ' where user = ' root ';

Root permission error and resolution during Grant command execution in Linux---mysql