操作命令
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: syw
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_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
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0 #注意此处最大连接为0
plugin: mysql_native_password
authentication_string: *C3C2A24BAABD5EE0234A210EAD34B131A688D007
password_expired: N
password_last_changed: 2023-03-06 15:22:26
password_lifetime: NULL
account_locked: N
5 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: syw
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_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
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 4 #注意此处信息已更改
plugin: mysql_native_password
authentication_string: *C3C2A24BAABD5EE0234A210EAD34B131A688D007
password_expired: N
password_last_changed: 2023-03-06 15:22:26
password_lifetime: NULL
account_locked: N
5 rows in set (0.00 sec)