2020年9月9日
不小心把mysql的root权限干掉了怎么办??
1.service mysqld stop
2./usr/bin/mysqld_safe –skip-grant-tables &
3.把权限赋回来
update user setSelect_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