docker pull mysql:5.7
docker run -d -p 3306:3306 --privileged=true -v /opt/mysql/conf/my.cnf:/etc/my.cnf -v /docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci
进入命令行
docker exec -it mysql bash
输入密码:123456
创建用户
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY 'test123' WITH GRANT OPTION;
修改为国内时区
select sysdate() from dual;
set global time_zone = '+8:00';
重新登录后时间生效