MySQL错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
来源:互联网 发布:知乎日本长寿 编辑:程序博客网 时间:2024/05/16 12:24
From terminal I enter(终端输入):
mysql -u root
which outputs this error(输出错误为):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
To try and resolve it I stopped mysql from ‘System Preferences’, then from terminal typed:(为了解决这个问题,从‘System Perferences’结束mysql)
sudo mysqld_safe —skip-grant-tables
I opened a second tab and entered(再一次启动mysql):
mysql -u root
Then from in mysql(显示):
update mysql.user set password_expired = 'N', authentication_string=PASSWORD('newpassword') where user = 'root';
解决办法:
For security reason mysql -u root want work untill you pass -p in command so try with below way.(由于安全原因,mysql -u root在遇到pass -p的时候才能开始工作)
mysql -u root -p[Enter] //enter your localhost password
所以,在终端输入上述命令,mysql -u root -p
,回车输入密码即可。
阅读全文
0 0
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- 解决MySql登录错误ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解决方法
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- mysql解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 新安装mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql GRANT with ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO
- [Java面试八]Hibernate总结以及在面试中的一些问题
- PHP分页
- 设计模式-java工厂模式2(抽象工厂模式)
- IT生涯, 我的常用软件清单
- 从内核角度剖析fork的执行过程(linux0.11)
- MySQL错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- JavaWeb-018-中文处理
- ESP8266 WiFi串口模块的学习与使用(一)
- 【设计模式】工厂模式(Factory Pattern)
- URL编码
- linux socketcan编程详解
- [LeetCode-Algorithms-39] "Combination Sum" (2017.11.29-WEEK13)
- JavaWeb-019-Cookie概述
- SpringBoot入门系列:第一篇 Hello World