基于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;