Home>

I accidentally installed the latest version of mysql, and after re-installing ver5.6, mysql command is just an error and I can't proceed.
* List of error commands below

I uninstalled, but the error was not resolved.

mysql -u root
(Authentication plugin 'caching_sha2_password' cannot be loaded:)
sudo mysql.server start
ERROR! The server quit without updating PID file (/usr/local/var/mysql/nekonoMacBook-Air.local.pid)
usr/local/var/mysql/mysql>sudo mysql.server restart
-bash: usr/local/var/mysql/mysql: No such file or directory
Uninstall performed the following command.
ps -ax | grep mysql
Stop and kill all MySQL processes
brew remove mysql
brew cleanup
sudo rm/usr/local/mysql
sudo rm -rf/usr/local/var/mysql
sudo rm -rf/usr/local/mysql *
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf/Library/StartupItems/MySQLCOM
sudo rm -rf/Library/PreferencePanes/My *
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
Edit and delete the line/etc/hostconfigMYSQLCOM = -YES-
rm -rf ~/Library/PreferencePanes/My *
sudo rm -rf/Library/Receipts/mysql *
sudo rm -rf/Library/Receipts/MySQL *
sudo rm -rf/private/var/db/receipts/* mysql *
  • Answer # 1

    Solved when restarting os update without turning off mac for a long time.

  • Answer # 2

    Are you using a Mac?
    This is miso in front, but I uninstalled it here.
    https://qiita.com/akiko-pusu/items/aef52b723da2cb5dc596

    After that, check if you can specify the version you want to install withbrew search mysql, and how about the settings?

    brew search mysql
    =>Formulae
    automysqlbackup mysql-connector-c ✔ [email protected]
    mysql ✔ mysql-connector-c ++ [email protected] ✔
    mysql ++ mysql-sandbox [email protected]
    mysql-client ✔ mysql-search-replace mysqltuner
    mysql-cluster mysql-utilities
    ==>Casks
    mysql-connector-python mysql-utilities navicat-for-mysql
    mysql-shell mysqlworkbench sqlpro-for-mysql