mysql(44) : 初始化/修改密码

设置时区, 开启远程访问

set global time_zone = '+8:00';
set time_zone = '+8:00';

GRANT ALL ON *.* TO 'root'@'%';

ALTER USER "root"@"localhost" IDENTIFIED  BY "123456";
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;


SELECT user, host, authentication_string, plugin FROM mysql.user WHERE user = 'root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON * TO 'root'@'%';
flush privileges;