1: 本地使用 mysql -u root -p 登陆到MySQL数据库中
2: 键入
UPDATE mysql.user SET Password=PASSWORD('填写新的密码') WHERE User='root';
3: 退出MySQL
4: 使用 systemctl restart mysql.service 重新启动MySQL数据库;
5: 远程使用navicat登陆MySQL数据库尝试成功
相关文章
- Access denied for user 'root'@'localhost' (using password:YES)
- IDEA报错“Access denied for user ‘root‘@‘localhost‘ (using password: YES)”
- phpMyAdmin提示“Access denied for user 'root'@'localhost' (using password: NO)”的解决办法
- 错误 ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
- 解决mysql中Access denied for user ‘root‘@‘%‘ to database...的问题
- mysql 中登录报错:ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)ERROR
- 42.Pycharm连接数据库出现错误:1045、1044:django.db.utils.OperationalError: (1045, "Access denied for user 'Whois'@'localhost' (using password: YES)”)
- 113资讯网:安装程序进入Admin后台出现:SQLSTATE[HY000] [1045] Access denied for user'root'@'localhost' (using password: YES)
- [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
- Mac Mysql mysql_secure_installation Error: Access denied for user 'root'@'localhost' (using password: YES)