mysql8错误：Access denied for user
2022-09-14 本文已影响0人
sunpy
1. 先修改my.cnf
skip-grant-tables
2. 重启mysql
docker restart 容器id
3. 登录mysql
docker exec -it 容器id /bin/bash
mysql -uroot
4. 修改mysql的root密码
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'spy123456';
5. 刷新权限
flush privileges;
