项目场景:
springboot中mysql连接出现
Access denied for user ‘’@‘192.168.56.1’ (using password: YES)
问题描述:
代码都没有问题
原因分析:
mysql连接权限问题
解决方案:
docker exec -it mysql /bin/bash
mysql -uroot -proot
mysql> grant all privileges on . to root@“192.168.56.1” identified by “root”;
Query OK, 0 rows affected, 1 warning (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)