linux 安装 mysql Access denied for user root@localhost (using password: NO)
来源:互联网 发布:武夷山市人口数据 编辑:程序博客网 时间:2024/06/06 17:07
方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
参考:
http://www.jb51.net/LINUXjishu/10981.html
按照方法一处理后,提示说密码过期,还得这么处理一下:
执行以下命令,需要在终端上进行# mysql -u root -predhatmysql> SET PASSWORD = PASSWORD('123456');mysql> quit# mysql -u root -p123456
方法1: 用SET PASSWORD命令
首先登录MySQL。
格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');
方法2:用mysqladmin
格式:mysqladmin -u用户名 -p旧密码 password 新密码
例子:mysqladmin -uroot -p123456 password 123
方法3:用UPDATE直接编辑user表
首先登录MySQL。
mysql> use mysql;
mysql> update user set password=password('123') where user='root' and host='localhost';
mysql> flush privileges;
0 0
- linux 安装 mysql Access denied for user root@localhost (using password: NO)
- 新安装mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- mysql 安装问题 access denied for user 'root'@'localhost' using password yes/no
- Centos 安装mysql 出现'Access denied for user 'root'@'localhost' (using password: NO)'
- [linux][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)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql在linux上出现Access denied for user 'root'@'localhost' (using password: NO)解决方案
- Linux下mysql出错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- linux下安装mysql后Access denied for user 'root'@'localhost' (using password: YES)
- linux安装MySQL出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: NO)
- #1045 - Access denied for user 'root'@'localhost' (using password: NO)
- Access denied for user 'root'@'localhost' (using password: NO)
- Access denied for user 'root'@'localhost' (using password: NO)
- #1045 -Access denied for user 'root'@'localhost' (using password: NO)
- Access denied for user 'root'@'localhost' (using password: NO)
- error: 'Access denied for user 'root'@'localhost' (using password: NO)'
- WPF中设置TEXTBOX为多行文本输入框
- 栈和队列
- js获取cookie
- 虚拟机linux下 /dev/sda2 满了怎么办,测试用过,真实可行
- 从ViewRootImpl类分析View绘制的流程
- linux 安装 mysql Access denied for user root@localhost (using password: NO)
- VisualSVN Server搭建SVN服务器
- 教你透彻了解红黑树
- Object-C 对象初始化
- Filter(过滤器)开发
- 《道德经》和《圣经》中的“道”
- iOS开发:2分钟快速集成支付宝快捷支付
- 精确到ms级别的获取系统时间办法
- SearchView使用