标签 mysql 下的文章

配置:

back_log    1000
character_set_server    utf8mb4
collation_server    utf8mb4_general_ci
interactive_timeout 3600
max_connections 1000
wait_timeout    3600

创建数据库和用户:

CREATE DATABASE abc CHARACTER SET utf8mb4;
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'xxx';
GRANT ALL PRIVILEGES ON abc.* TO 'user1'@'localhost';
FLUSH PRIVILEGES;