操作命令
1、创建一个用户：CREATE USER 'syw' IDENTIFIED BY 'user3333%';2、查看用户syw的所有信息：select * from mysql.user;3、修改syw用户的最大限制连接数：GRANT ALL ON *.* TO 'syw'@'%' WITH MAX_USER_CONNECTIONS 4;4、再次查看syw的用户信息，观察参数：MAX_USER_CONNECTIONS:是否被修改成功
命令操作
mysql> CREATE USER 'syw' IDENTIFIED BY 'user3333%';Query OK, 0 rows affected (0.00 sec)
mysql> select * from mysql.user\G;*************************** 1. row ***************************........其他用户的显示信息此处忽略*************************** 5. row ***************************Host: %User: sywSelect_priv: NInsert_priv: NUpdate_priv: NDelete_priv: NCreate_priv: NDrop_priv: NReload_priv: NShutdown_priv: NProcess_priv: NFile_priv: NGrant_priv: NReferences_priv: NIndex_priv: NAlter_priv: NShow_db_priv: NSuper_priv: NCreate_tmp_table_priv: NLock_tables_priv: NExecute_priv: NRepl_slave_priv: NRepl_client_priv: NCreate_view_priv: NShow_view_priv: NCreate_routine_priv: NAlter_routine_priv: NCreate_user_priv: NEvent_priv: NTrigger_priv: NCreate_tablespace_priv: Nssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0 #注意此处最大连接为0plugin: mysql_native_passwordauthentication_string: *C3C2A24BAABD5EE0234A210EAD34B131A688D007password_expired: Npassword_last_changed: -03-06 15:22:26password_lifetime: NULLaccount_locked: N5 rows in set (0.00 sec)
mysql> GRANT ALL ON *.* TO 'syw'@'%' WITH MAX_USER_CONNECTIONS 4;Query OK, 0 rows affected, 1 warning (0.00 sec)
修改后的参数查看
mysql> select * from mysql.user\G;*************************** 1. row ***************************........其他用户的显示信息此处忽略*************************** 5. row ***************************Host: %User: sywSelect_priv: NInsert_priv: NUpdate_priv: NDelete_priv: NCreate_priv: NDrop_priv: NReload_priv: NShutdown_priv: NProcess_priv: NFile_priv: NGrant_priv: NReferences_priv: NIndex_priv: NAlter_priv: NShow_db_priv: NSuper_priv: NCreate_tmp_table_priv: NLock_tables_priv: NExecute_priv: NRepl_slave_priv: NRepl_client_priv: NCreate_view_priv: NShow_view_priv: NCreate_routine_priv: NAlter_routine_priv: NCreate_user_priv: NEvent_priv: NTrigger_priv: NCreate_tablespace_priv: Nssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 4#注意此处信息已更改plugin: mysql_native_passwordauthentication_string: *C3C2A24BAABD5EE0234A210EAD34B131A688D007password_expired: Npassword_last_changed: -03-06 15:22:26password_lifetime: NULLaccount_locked: N5 rows in set (0.00 sec)
