环境: mac + brew + mysql
异常:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2);
尝试解决:brew uninstall mysql;
结果:未解决;
尝试google后:解决了;
方案如下:ps -ax | grep mysql,然后关闭服务进程;
brew remove
brew cleanup
彻底清空rm -rf
重新安装
以下命令乱序:
ps -ax | grep mysql
241 brew remove mysql
242 brew cleanup
243 sudo rm /usr/local/mysql
244 sudo rm /usr/local/mysql
245 sudo rm -rf /usr/local/mysql*
246 sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
247 sudo rm -rf /Library/StartupItems/MySQLCOM
248 sudo rm -rf /Library/PreferencePanes/My*
249 vim /etc/hostconfig
250 rm -rf ~/Library/PreferencePanes/My*
251 vim /etc/hostconfig
252 sudo rm -rf /Library/Receipts/mysql*
253 sudo rm -rf /Library/Receipts/MySQL*
254 sudo rm -rf /private/var/db/receipts/*mysql*
255 cat ~/.bash_profile
256 brew doctor
257 brew install mysql
258 unset TMPDIR
259 mysqld -initialize --verbose --user=whoami --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
260 mysqld -initialize --verbose --user=whoami --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
261 mysql.server start
262 brew services start mysql
263 /usr/local/Cellar/mysql/8.0.22/bin/mysql_secure_installation
264 mysql -uroot
265 mysql -u root -p12345678
266 history