Mysql Root Access back

Today want to give a user a database operation permissions,[email protected]% operation has been an error; 1044 no permissions, and some databases do not have write update permissions; there's a lot of information that's missing root permissions. ; start looking for information to restore root privileges;

1. Configure the environment variables first: Add MySQL installation directory in Path C:/mysql/bin;

2. Skip permission Verification Login root: Open cmd, stop MySQL service (manual shutdown or command),

Input Mysqld_safe--skip-grant-tables (this I did not succeed, modified the bin directory under the My.ini file [mysqld] added skip-grant-tables manual start service),

Root no password login mysql-u root; show databases;

View all databases, use MySQL, select User,host from user to view all users;

Update user set Password=password ("123456") where user= "root"; Change the root password,

flush privileges; Refresh data; exit exit; Comment My. INI to add the configuration;

Restart the MySQL service, mysql-u root-p have password login view permission;

Mysql Root Access back