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数据库尝试成功
相关文章
- Centos7解决MySQL登录ERROR 1045 (28000): Access denied for user ‘‘@‘localhost‘ (using
- ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O) MYSQL
- mysql cmd ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O)
- MySQL学习笔记——ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- wamp中的phpmyadmin打开出现:#1045 - Access denied for user 'root'@'localhost' (using password: NO)
- 解决MySQL登录ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)问题
- mac系统中搭建apache+mysql+php的开发环境,安装mysql后,登录报错:mac ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 遇到一个PHP连接MySQL问题,PHP支持MySQL,但是总是提示Access denied for user 'IUSR_TOMC-YKJ'@'localhost' (using password
- 解决MySQL #1045 - Access denied for user 'root'@'localhost' (using password: YES) 的问题
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决