- 出现以下错误
ERROR 1820 (HY000):You must reset your password using ALTER USER statement before executing this statement
mysql> ALTER USER USER() IDENTIFIED BY ‘l!vWT#mL93’;
具体可看https://www.cnblogs.com/faithH/p/11821114.html
- 命令窗口登陆mysql,然后执行下述sql
alter user ‘root’@‘localhost’ identified with mysql_native_password BY ‘newpassword’;
flush privileges;
修改ip的限制
grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
flush privileges;