mysql创建超级用户,更新用户权限

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='%';

-----------