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;
全部评论