当前位置：网站首页>Liunx下Navicat连接mysql报错ACCESS DENIED FOR USER ‘ROOT‘@‘XXX.XXX.XXX.XXX‘ (USING PASSWORD: YES
Liunx下Navicat连接mysql报错ACCESS DENIED FOR USER ‘ROOT‘@‘XXX.XXX.XXX.XXX‘ (USING PASSWORD: YES
2022-04-21 08:10:00 【凌晨程序猿】
最近在本地搭建一个Liunx系统，安装了mysql在Liunx使用正常，密码也是正确，然后用Navicat连接一下，结果发现直接报错被拒绝访问，经过网上一顿查找终于找到了处理方法
解决方案
进入mysql
mysql -u root -p
执行下面语句
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
最后重启mysql服务
service mysqld restart
重新使用Navicat连接成功！！！
版权声明
本文为[凌晨程序猿]所创，转载请带上原文链接，感谢
https://blog.csdn.net/qq_44920883/article/details/124283206
边栏推荐
- visio设置网络拓扑图
- PIP was installed successfully, but pycharm reported an error
- 6. 堪比JMeter的.Net压测工具 - Crank 实战篇 - 收集诊断跟踪信息与如何分析瓶颈
- 输入四个整数按照从小到大的顺序排列
- ASUS good screen 120Hz high refresh rate, opening a new pattern of OLED Market
- 深入浅出 Ext4 块和 Inode 分配器的优化（下）
- docker怎么访问宿主中redis服务6379端口
- Experiment 1: basic operation of database
- Postgresql limit sql性能分析
- SIP语音环境中十大经典问题及解决办法
猜你喜欢
随机推荐
触发EPOLLIN 和 EPOLLOUT的所有情况
求其最大公约数和最小公倍数
Introduction to ACM [tree diameter]
Developing grpc application based on well-known micro service framework go micro
eval（）函数
在链表结点后插入新结点
逻辑回归----案例：癌症分类预测
Linux 配置redis 开机自动启动
Add a cute girl to your website
ASUS good screen 120Hz high refresh rate, opening a new pattern of OLED Market
分类中解决类别不平衡问题
Be sure to look at the nine steps of MES model selection. Which step did you miss? (top)
链表结点的删除
The problem of reading configuration file in feign request interceptor
什么是父子关系和菱形继承
You can remove cached packages by executing ‘yum clean packages‘. Error: GPG check FAILED
SIP语音环境中十大经典问题及解决办法
机器学习之线性回归初窥
About deep learning drawing
Convert n arrays into JSON form