[linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
来源:互联网 发布:ipad 无法加入网络 编辑:程序博客网 时间:2024/05/20 21:23
linux下安装好mysql后无法登陆。。
查了网上说的各种方法,搞了一晚上都没解决。。第二天在群中请教了前辈。。解决了
方法为:用安全模式启动后修改密码
如下:
1. 让mysql可以无密码启动
vi /etc/my.cnf
在[mysqld]中加上skip-grant-tables
2. 重新启动mysql
/etc/init.d/mysql stop
/etc/init.d/mysql start
3. 进入/usr/bin目录下使用sqladmin修改密码
mysqladmin -uroot -p old_pwd new_pwd
或者mysql直接进入
use mysql;
update user set password=PASSWORD('root') where user = 'root';
flush privileges;
或者参考修改mysql密码的其他方法:http://www.cnblogs.com/jyginger/archive/2011/04/27/2030017.html
4. 回到第1步。。删除skip-grant-tables
即可。。以上测试ok..
- [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)
- 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)
- Linux下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)
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- google邮件在outlook中的设置
- Android的AlertDialog详解
- c++学习论坛推荐 强力推荐
- CityEngine示例数据(Tutorial)配套视频教程(英文)
- Android网络收音机项目
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- 使用libvirt管理kvm(API篇)
- [Android实例] Android网络收音机项目(内含源码)
- xen-timer
- 微信-心跳机制
- Android网络连接判断与处理
- MySQL引擎
- Linux下截图工具也玩命
- Linux命令信息重定向