博百优 | yaozer 博客

tuning-primer.sh 是个蛮有名的MySQL优化工具， 下载地址：http://day32.com/MySQL运行时运行时/

运行时有时候会出现以下错误：

# ./tuning-primer.sh

- INITIAL LOGIN ATTEMPT FAILED -

Testing Stored for passwords:- RETRY LOGIN ATTEMPT FAILED -

Could not auto detect login info!

Do you have your login handy ? [y/N] : y
User: root
Password:
Would you like me to create a ~/.my.cnf file for you? [y/N] : n
- FINAL LOGIN ATTEMPT FAILED -

Unable to log into socket: /var/run/mysqld/mysqld.sock

解决办法：

/etc/init.d/mysql stop
pkill -u mysql
rm -f /var/run/mysqld/*
/etc/init.d/mysql start
./tuning-primer.sh

标签: tuning-primer