mysql5.7.x 数据授权导致1141

基于mysql5.7.x

1、数据库备份，后修改配置文件，新增如下配置：

skip-grant-tables  跳过表的权限验证，用户可以执行增删改查
2、然后重新启动mysql，
    service mysqld restart
如果mysql没有注册，可以找到mysql/bin下面的mysqld，执行./mysqld restart 也是一样的

3、查看数据授权：

show grants;

4、修改权限，
在mysql数据库中执行：

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、注释掉数据库配置文件中得配置

skip-grant-tables ，并重启MYSQL服务器；

6.查看

show grants;