Shulou(Shulou.com)06/01 Report--

Accidentally revoked all the root permissions of mysql, on the Internet to find a lot of ways to restore, after practice, found that this method is feasible, specially write it down.

1. First hit the service mysqld stop command, which stops the mysql.

2. Launch mysql in safe mode with the command / usr/bin/mysqld_safe-- skip-grant-tables (where the parameter-skip-grant-tables means to skip database verification)

3. Log in to mysql with mysql-u root-p. You do not need to enter a password.

4. Select the database table mysql, and the command is: USE mysql

5 、 GRANT ALL PRIVILEGES ON. TO root@localhost IDENTIFIED BY 'password' WITH GRANT OPTION

6 、 flush privileges

After performing the above steps.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.