MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
来源:互联网 发布:高中编程软件 编辑:程序博客网 时间:2024/06/05 03:08
原地址:http://myotragusbalearicus.wordpress.com/2011/11/21/mysql-error-1045-28000-access-denied-for-user-rootlocalhost-using-password-no/
I’ve upgraded MySQL server version to 5.1.54-1ubuntu4 and when I try to connect to the database I’m getting this error:
$ mysql -u root Error 1045 (28000): Access deniedfor user 'root'@'localhost'(using password: NO)
Maybe updating the package the updater overwrote the root password.
To restore it:
- Stop mysqld deamons.
$sudo service mysql stop
- Go to mysql/bin directory
$cd /usr/bin
- Start a mysql deamon with this option:
$sudo mysqld_safe --skip-grant-tables
- Open another terminal and open a mysql session to execute this:
$ mysqlmysql> use mysql;mysql> UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user ='root';mysql> exit;
- Now kill the mysqld_safe process and restart mysqld normally:
$sudo service mysql start
- 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]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
- MySQL:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Ubuntu下 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)
- Django 通用视图
- ssh执行远程服务器需要sudo提权的脚本
- vsftp建立虚拟用户不同目录分配不同权限操作步骤详解
- python计算程序开始到程序结束的运行时间和程序运行的CPU时间
- php遍历文件夹所有文件子文件夹函数
- MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- PHP根据IP地址获取所在城市
- 有向图的十字链表存储表示 以及相关操作(包括增加弧、删除弧、删除顶点等)
- UVa:10994 Simple Addition
- PHP基础学习
- 11
- android 多点触碰实现图片的缩放
- 读取文本文件2
- 解释比特币原理