MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
来源:互联网 发布:怎么在淘宝买假学生证 编辑:程序博客网 时间:2024/04/20 10:57
MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
无法修改密码
用 service mysqld stop
mysqld_safe --skip-grant-tables &
输入 mysql -uroot -p 回车进入
>use mysql;
> update user set password=PASSWORD("newpass")where user="root";
> flush privileges; 更新权限
> quit 退出
mysql -uroot -p新密码进入
===========================================================
二,忘记本地root的登录密码
解决过程:
1、编辑/etc/my.cnf
在[mysqld] 配置部分添加一行
skip-grant-tables
2、保存后重启mysql
[root@localhost etc]# service mysqld restart
Shutting down MySQL.
Starting MySQL.
3、登录数据库重新设置root密码
[root@localhost ~]# mysql -uroot -p mysql
Enter password:
直接回车进入
Welcome to the MySQL monitor.
Your MySQL connection id is 1
Server version: 5.1.47-log Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database
+--------------------+
| information_schema |
| mysql
| test
+--------------------+
3 rows in set (0.00 sec)
执行下列语句
mysql> update user set password=password("mysql") where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4、删除/etc/my.cnf文件中添加的“skip-grant-tables”行,重启mysql;
用新设的密码就能正常登录了;
三 修改密码a [root@localhost ~]#mysqladmin -u root -p oldpassword newpasswd(记住这个命令是在 /usr/local/mysql/bin中外部 命令)
b. SET PASSWORD FOR root=PASSWORD(’new password’);(对登录数据库后这种方式)
c. UPDATE user SET password=PASSWORD(”new password”) WHERE user=’root’; (对登录数据库 后这种方式)
- 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?
- .Net版本&ckeditor_4.1.2+ckfinder+CuPlayerMiniV4+moPlayer&兼容ie7、ie8和火狐
- OpenCV2 && Qt4 chapter5: 形态学图像处理
- OpenGL中的函数gluPerspective简单理解
- 基于S3C2440的Linux-3.6.6移植——启动LOGO的修改
- 澳洲新人扫盲
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- 分查找实现(Jon Bentley:90%程序员无法正确实现)
- Cocos2d-x 瓦片地图图层类CCTMXLayer
- Android不让弹出键盘挡住View
- pythongame练习
- 主键与外键
- ios 获得手机号码
- H264相关注意事项
- 菜鸟程序员_SB英语学习新体验