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;