mysql权限脚本_Mysql 增加用户与分配用户权限脚本

脚本如下：

增加用户

grant all on gprs_pii.* to [email protected]'%' identified by 'gprs';

更新用户权限

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',  ssl_type               = 'Y',  ssl_cipher             = 'Y',  x509_issuer            = 'Y',  x509_subject           = 'Y',  max_questions          = 'Y',  max_updates            = 'Y',  max_connections        = 'Y',  max_user_connections   = 'Y' where user = 'gprs' df;