MySql 授权新用户某个数据库命令一览

2022-10-22 09:10
143
0

CREATE USER 'mysql_user'@'localhost' IDENTIFIED BY 'mysql_user_pwd';

CREATE USER 'mysql_user'@'127.0.0.1' IDENTIFIED BY 'mysql_user_pwd'; 

CREATE USER 'mysql_user'@'%' IDENTIFIED BY 'mysql_user_pwd'; 

GRANT ALL PRIVILEGES ON mysql_db.* TO 'mysql_user'@'localhost'; 

GRANT ALL PRIVILEGES ON mysql_db.* TO 'mysql_user'@'%'; 

GRANT ALL PRIVILEGES ON mysql_db.* TO 'mysql_user'@'127.0.0.1';

ALTER DATABASE mysql_dbCHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 

SET GLOBAL max_connections = 4000;

SET GLOBAL interactive_timeout = 300;

SET GLOBAL wait_timeout = 300;

FLUSH PRIVILEGES;

全部评论