MySQL 设置root密码报错:mysqladmin: connect to server at 'localhost' failed

1.安装完MySQL设置root密码报错如下

[root@vm172--- data]# mysqladmin -uroot password "linux@123"
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

2.停止MySQL服务

[root@vm172--- ~]# systemctl stop mysqld.service

3 安全模式启动

[root@vm172--- mysql]# mysqld_safe --skip-grant-tables &
[]
[root@vm172--- mysql]# :: mysqld_safe Logging to '/var/log/mysqld.log'.
:: mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

4 无密码root帐号登陆

[root@vm172--- mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6.-log MySQL Community Server (GPL) Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mysql;
Database changed

5 手动update修改密码

mysql> update user set password=password("linux@123") where user='root' and host='localhost';
Query OK, row affected (0.00 sec)
Rows matched: Changed: Warnings: mysql> flush privileges;
Query OK, rows affected (0.00 sec) mysql> quit
Bye

重新使用密码登录

[root@vm172--- mysql]# mysql -uroot -plinux@
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6.-log MySQL Community Server (GPL) Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>

6 正常重新启动

[root@vm172--- ~]# service mysqld start

#查看进程

[root@vm172--- ~]# ps -ef|grep mysql
root : pts/ :: tail -f -n /var/log/mysqld.log
mysql : ? :: /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql : ? :: /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root : pts/ :: grep --color=auto mysql

#查看端口号

[root@vm172--- ~]# netstat -lntup|grep
tcp 0.0.0.0: 0.0.0.0:* LISTEN /mysqld

至此mysql密码修改完成。

最新文章

  1. 自定义view--实现滑动
  2. ng-repeat && ng-options的故事
  3. while语句
  4. 【poj2417】 Discrete Logging
  5. js控制iframe跳转
  6. jqGrid API 相关
  7. jquery图片轮播代码
  8. sqlserver中的序列
  9. 痞子衡嵌入式:恩智浦MCU安全加密启动一站式工具NXP-MCUBootUtility用户指南
  10. HttpRequest,HttpResponse,乱码,转发和重定向
  11. js命名空间的函数namespace
  12. P2885 [USACO07NOV]电话线Telephone Wire
  13. swift计算 switch case
  14. 在远程桌面服务中配置RD网关直接访问内网
  15. latex 公式距离
  16. es query_string 和 match 的区别
  17. java 不通过第三个字符串,实现一个字符串倒序
  18. Python pip离线部署
  19. DB2和Oracle中Date比较
  20. 论文笔记《Feedforward semantic segmentation with zoom-out features》

热门文章

  1. php优秀框架codeigniter学习系列——CI_Lang类学习
  2. redis初始化服务器
  3. python实际练习1——简单购物车
  4. Linux "ls -l"文件列表权限详解 【转】
  5. 关于第一次在IDEA上使用lombok时注解完全不起作用
  6. JavaScript Node节点笔记
  7. C++编程入门
  8. React native 中使用Fetch请求数据
  9. windows安装oracle-odbc驱动错误原因
  10. MySQL 报错 1093