第一次登陆修改密码
ALTER user ‘root‘@‘localhost‘ IDENTIFIED BY ‘12345678‘;
CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘你的密码‘;
GRANT ALL ON *.* TO ‘root‘@‘%‘;
ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘你的密码‘;
FLUSH PRIVILEGES;
原文:https://www.cnblogs.com/yyl001/p/12801779.html