關閉多執行個體MySQL時報錯

標籤：localhost   server   password   密碼   mysql   

在MySQL剛裝好兩個執行個體的環境下，兩執行個體啟動後再關閉時報錯；

[[email protected] ~]# /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)‘

[[email protected] ~]# /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設定密碼

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

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

[[email protected] ~]# /data/3306/mysql stop
Stoping MySQL...

[[email protected] ~]# /data/3307/mysql stop
Stoping MySQL...

[[email protected]~]# netstat -lntup|grep 330

 

關閉多執行個體MySQL時報錯