xx996
0%

docker启动mysql容器之后报错 

1
2
3
4
5
6
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
grant all privileges on *.* to 'root'@'%'; 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;

1
2
3
4
5
6
7

CREATE USER 'lzz'@'%' IDENTIFIED BY '123456';

grant all privileges on *.* to 'lzz'@'%' with grant option;

set global time_zone = '+8:00';

mysql数据库时间少一天

1
characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai

把serverTimezone值修改为Asia/Shanghai