使用navicat连接Linux上的数据库时,新建一个库出现异常
无法创建
access denied for user root@% to database
返回Linux查看mysql状态
状态正常,navicat也能正常连接,排除掉应该是权限的问题
docker exec -it d7bcc087dce1 bash 进入mysql容器
mysql -u root -p 登录账号密码
grant all privileges on *.* to 'root'@'%' with grant option; 修改权限
exit 两次退出
docker restart d7bcc087dce1 重启mysql服务
创建成功。
正规的线下环境肯定是不能这么干的。
- database docker access denied 问题database docker access denied database access denied xxxxxx 39 password access denied localhost password access denied status_access_denied access denied basic http access denied clone basic localhost ubuntu access denied 39 localhost access denied maxwell mysql access denied