如果你已经设置过密码,并且可以直接登陆,那么下面是解决办法
- 先登进去mysql
$ mysql -u root -p
输入密码后登进去
- 设置允许远程登录
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypass123';
exit 退出即可
如果你已经设置过密码,并且可以直接登陆,那么下面是解决办法
$ mysql -u root -p
输入密码后登进去
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypass123';
exit 退出即可