mysql5. 7. X data authorization leads to 1141

be based on mysql5.7.x

1、 Database backup , Modify the configuration file after , Add the following configuration ：

skip-grant-tables   Skip the permission verification of the table , Users can add, delete, modify and query
2、 And then restart it mysql,
    service mysqld restart
If mysql Not registered , Can find mysql/bin Below mysqld, perform ./mysqld restart It's the same

3、 View data authorization ：

show grants;

4、 Modify the permissions ,
stay mysql Execute... In the database ：

UPDATE `mysql`.`user` SET `Host`='localhost', `User`='root', `Select_priv`='Y', `Insert_priv`='Y', `Update_priv`='Y', `Delete_priv`='Y', `Create_priv`='Y', `Drop_priv`='Y', `Reload_priv`='Y', `Shutdown_priv`='Y', `Process_priv`='Y', `File_priv`='Y', `Grant_priv`='Y', `References_priv`='Y', `Index_priv`='Y', `Alter_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', `Event_priv`='Y', `Trigger_priv`='Y', `Create_tablespace_priv`='Y', `ssl_type`='', `ssl_cipher`='', `x509_issuer`='', `x509_subject`='', `max_questions`='0', `max_updates`='0', `max_connections`='0', `max_user_connections`='0', `plugin`='mysql_native_password', `authentication_string`='*AF73E80C6232D0438D09FB61B287C556B4DFE144', `password_expired`='N', `password_last_changed`='2019-06-21 13:38:30', `password_lifetime`=NULL, `account_locked`='N' WHERE (`Host`='localhost') AND (`User`='root');

5、 Comment out the configuration in the database configuration file

skip-grant-tables , And restart MYSQL The server ;

6. see

show grants;