mysqladmin: connect to server at 'localhost' failed;错误解决方法
来源:互联网 发布:网络超市的前景 编辑:程序博客网 时间:2024/04/29 07:49
select * from user where User='root';
查看HOST字段填的是%,没有localhost这一项,所以他无法本地访问。
mysql.user表中Host为%的含义
Host列指定了允许用户登录所使用的IP,比如user=root Host=192.168.1.1。这里的意思就是说root用户只能通过192.168.1.1的客户端去访问。 而%是个通配符,如果Host=192.168.1.%,那么就表示只要是IP地址前缀为“192.168.1.”的客户端都可以连接。如果Host=%,表示所有IP都有连接权限。、 这也就是为什么在开启远程连接的时候,大部分人都直接把Host改成%的缘故,为了省事。
网上查的资料
# mysql -u root -p
Enter password:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# mysql -u root -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
网上找到的方法操作很简单,如下:
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root' and host='root' or host='localhost';//把空的用户密码都修改成非空的密码就行了。
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysqld restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
0 0
- 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
- 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
- mysqladmin: connect to server at 'localhost' failed?
- mysqladmin: connect to server at 'localhost' failed
- mysqladmin: connect to server at 'localhost' failed
- 课后第6题
- 浅谈HTTP协议
- Win7 pySpark安装
- 关于抖动动画
- 有关不规则图片的点击响应事件和手势滑动闪退的处理d
- mysqladmin: connect to server at 'localhost' failed;错误解决方法
- Thymeleaf教程 (三) 创建一个多语言的首页
- web应用部署到Linux服务器上,CPU占用过高
- 微型投影仪第三篇——磕磕绊绊
- 洛谷 P1361 小猫爬山
- android 常用注解
- 【OpsDEV】VirtualBox下给Solus安装增强工具
- Idea设置字符编码和内存溢出
- selenium设计模式之PageObject