MySQL database, delete root user after recovery

After deleting the root user in the MySQL users table, we can use the following command to achieve the recovery;

2 ways to start the MySQL database safe mode

1. Modify the configuration file/etc/my.cf, add--skip-grant-tables

2. Use the command to enter Safe mode,

First, you must first close the MySQL services service mysqld stop

Enter Safe Mode Mysqld_safe--skip-grant-tables

3. Add the Use table contents as follows:

mysql> INSERT INTO user set ser= ' root ', ssl_cipher= ', x509_issuer= ', x509_subject= ';

mysql> Update user set host= ' localhost ', select_priv= ' y ', insert_priv= ' y ', update_priv= ' y ', alter_priv= ' y ', delete_priv= ' y ', create_priv= ' y ', drop_priv= ' y ', reload_priv= ' y ', shutd own_priv= ' y ', process_priv= ' y ', file_priv= ' y ', grant_priv= ' y ', references_priv= ' y ', index_priv= ' y ', create_user_priv = ' y ', show_db_priv= ' y ', super_priv= ' y ', create_tmp_table_priv= ' y ', lock_tables_priv= ' y ', execute_priv= ' y ', repl_ slave_priv= ' y ', repl_client_priv= ' y ', create_view_priv= ' y ', show_view_priv= ' y ', create_routine_priv= ' y ', alter_ routine_priv= ' y ', create_user_priv= ' y ' where user= ' root ';

This article is from the "Linux Small Pot Friends" blog, please be sure to keep this source http://ny0716.blog.51cto.com/9154254/1685624

MySQL database, delete root user after recovery