insert into user(Host,User,Password ,Select_priv ,Insert_priv ,Update_priv ,Delete_priv ,Create_priv ,Drop_priv ,Reload_priv ,Shutdown_priv ,Process_priv ,File_priv ,Grant_priv ,References_priv ,Index_priv ,Alter_priv ,Show_db_priv ,Super_priv ,Create_tmp_table_priv,Lock_tables_priv ,Execute_priv ,Repl_slave_priv ,Repl_client_priv ,Create_view_priv ,Show_view_priv ,Create_routine_priv,Alter_routine_priv ,Create_user_priv ,ssl_type ,ssl_cipher ,x509_issuer ,x509_subject ,max_questions ,max_updates ,max_connections ,max_user_connections) values('%','root,'111','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',null,null,null,0,0,0,0);
将某些root用户权限全开放:
----------
UPDATE user SET Select_priv='Y',Insert_priv='Y',Update_priv='Y',Grant_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_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' WHERE user='root';
and host='128.0.1.23'
-----------
将某些root用户权限关闭
UPDATE user SET Select_priv='Y',Insert_priv='N',Update_priv='N',Grant_priv='N',Delete_priv='N',Create_priv='N',Drop_priv='N',References_priv='N',Index_priv='N',Alter_priv='N',Show_db_priv='N',Super_priv='N',Create_tmp_table_priv='N',Lock_tables_priv='N',Execute_priv='N',Repl_slave_priv='N',Repl_client_priv='N',Create_view_priv='N',Show_view_priv='N',Create_routine_priv='N', Alter_routine_priv='N',Create_user_priv='N',Reload_priv='N',Shutdown_priv='N', Process_priv='N',File_priv='N' WHERE user='root' and host='%';
-----------