MySQL 设置root密码报错:mysqladmin: connect to server at ‘localhost’ failed
1.安装完MySQL设置root密码报错如下
[root@vm172-31-0-6 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-31-0-6 ~]# systemctl stop mysqld.service
3 安全模式启动
[root@vm172-31-0-6 mysql]# mysqld_safe --skip-grant-tables &
[1] 20777
[root@vm172-31-0-6 mysql]# 190315 01:43:28 mysqld_safe Logging to ‘/var/log/mysqld.log’.
190315 01:43:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
4 无密码root帐号登陆
复制代码
[root@vm172-31-0-6 mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.43-log MySQL Community Server (GPL)
Copyright ©