MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
来源:互联网 发布:石家庄星云网络 编辑:程序博客网 时间:2024/04/26 22:14
MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
2012-06-01 19:08:56| 分类:Mysql| 标签:mysql数据库密码出错 mysql数据库问题 |举报|字号 订阅
一、mysql登录错误
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
解决办法:破解mysql密码
#> service mysqld stop
#>mysqld_safe --skip-grant-tables &
输入 mysql -uroot -p 回车进入
>use mysql;
> update user set password=PASSWORD("newpass")where user="root";
更改密码为 newpassord
> flush privileges; 更新权限
> quit 退出
service mysqld restart
mysql -uroot -p新密码进入
二,忘记本地root的登录密码
解决过程:
1、编辑/etc/my.cnf
在[mysqld] 配置部分添加一行
skip-grant-tables 0 0
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
- MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at "localhost" failed
- fedora16 MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
- mysqladmin: connect to server at 'localhost' failed;错误解决方法
- mysqladmin: connect to server at 'localhost' failed;错误解决方法
- mysqladmin: connect to server at 'localhost' failed;错误解决方法
- mysql问题解决:mysqladmin: connect to server at 'localhost' failed
- mysqladmin: connect to server at 'localhost' failed?
- 三层,你真的理解了吗?
- Java文件及文件目录排序
- IOS 如何从ViewController获取一个UIView上的某种或者某个控件
- json添加修改删除
- easyrecovery使用教程,easyrecovery使用方法
- MYSQL登录错误:mysqladmin: connect to server at ‘localhost’ failed
- 判断哪一种位置读取方式比当前的位置修复更加的准确
- MonkeyTalk自动化之——Tests and Verification
- POJ 1840 Eqs(哈希)
- 读《C++ Primer 第四版》再温C++ —— Chapter 12 类
- Julia:Datetime的用法
- python测试——doctest和unittest
- SQL 函数
- springMVC使用html视图配置详解