2020年9月9日 作者 zeroheart

不小心把mysql的root权限干掉了怎么办??

1.service mysqld stop

2./usr/bin/mysqld_safe –skip-grant-tables &

3.把权限赋回来
update user set 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' where user='root' and host='%'

4.flush privileges;

5.重启一下service mysql restart