mysqladmin: connect to server at 'localhost' failed
来源:互联网 发布:数据库开发工程师培训 编辑:程序博客网 时间:2024/04/19 06:55
1、mysqladmin: connect to server at 'localhost' failed
C:\Users\Simon>mysqladmin -u root -password 123456mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: YES)'
解决方法:1、怀疑是本机装了IPv6,导致localhost映射不到127.0.0.1。
尝试:修改/drivers/etc/hosts中建立本地映射。
结果:mysql不能启动。
2、使用update语句更改密码,结果发现没有mysql库。于是采用安全启动。
以下是网上的方案:
需要注意的是,service mysqld stop是Linux系统的命令。在windows使用net stop Mysql.
另外,在windows系统没有mysqld_safe命令,我是直接运行mysqld –skip-grant-tables。这个时候控制台不会提示下一条命令。需要另外开一个窗口登录mysql
service mysqld stopmysqld_safe --skip-grant-tablesmysql> use mysql;Database changedmysql> update user set password=PASSWORD('123456') where user='root';Query OK, 3 rows affected (0.05 sec)Rows matched: 3 Changed: 3 Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)mysql> \qBye
- 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;错误解决方法
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- 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
- mysqladmin: connect to server at 'localhost' failed;错误解决方法
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- MYSQL登录错误:mysqladmin: connect to server at 'localhost' failed
- UDP void CFasonDlg::OnSend()
- jQuery中return false,e.preventDefault(),e.stopPropagation()的区别
- UDP void CDASocket::OnReceive(int nErrorCode)
- typedef用法小结
- 开源软件版权盈利问题:个人理解
- mysqladmin: connect to server at 'localhost' failed
- 分析android动画模块
- 如何使用wmwifirouter 进行网络共享,使usb to wifi成为AP无线接入呢。
- 在 Eclipse 中使用命令行
- Struts2学习笔记(七)之文件的下载
- hibernate 经验谈(一)
- 数字图像读书笔记
- 六大原则之“单一职责原则(SRP)“笔记
- QQ2012 Beta1登录协议之重定向