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