首页 > 数据库技术 > 详细

关闭多实例MySQL时报错

时间:2016-07-15 22:00:12      阅读:339      评论:0      收藏:0      [点我收藏+]

在MySQL刚装好两个实例的环境下,两实例启动后再关闭时报错;

[root@edb ~]# /data/3307/mysql stop
Stoping MySQL...
Enter password:
/application/mysql/bin/mysqladmin: connect to server at ‘localhost‘ failed
error: ‘Access denied for user ‘root‘@‘localhost‘ (using password: YES)‘

[root@edb ~]# /data/3306/mysql stop
Stoping MySQL...
Enter password:
/application/mysql/bin/mysqladmin: connect to server at ‘localhost‘ failed
error: ‘Access denied for user ‘root‘@‘localhost‘ (using password: YES)‘

 

解决方法:

为root设置密码

[root@edb ~]# mysqladmin  -u root -S /data/3306/mysql.sock password ‘beatigirl‘

[root@edb ~]# mysqladmin  -u root -S /data/3307/mysql.sock password ‘beatigirl‘

[root@edb ~]# /data/3306/mysql stop
Stoping MySQL...

[root@edb ~]# /data/3307/mysql stop
Stoping MySQL...

[root@edb~]# netstat -lntup|grep 330

 

关闭多实例MySQL时报错

原文:http://11860775.blog.51cto.com/11850775/1826811

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!