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
sudo mysql.server start
(Authentication plugin 'caching_sha2_password' cannot be loaded:)
usr/local/var/mysql/mysql>sudo mysql.server restart
ERROR! The server quit without updating PID file (/usr/local/var/mysql/nekonoMacBook-Air.local.pid)
Uninstall performed the following command.
-bash: usr/local/var/mysql/mysql: No such file or directory
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.
After that, check if you can specify the version you want to install with
brew 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
- about errors when connecting to mysql (codeigniter, xdebug, mysql)
- about fortran errors
- about errors in python matplotlib
- linux - about the expr command and regular expressions
- c++ - about errors encountered while solving atcoder problems
- about errors in docker-composeyml file
- about amazon linux2 mysql installation
- about the connection cancellation method between docker and mysql
- vba - about the setting of the command button of the user form
- error about mysql when building environment with docker
- python - about variable errors
- mysql - about production operation of application
- mysql - about switching databases
- mysql - about db table naming
- about mysql user
- centos - about rpm build errors that appear in rpmbuild -ta slurm-20025tarbz2
- about python errors
- python - about errors in skorch
- about update of multiple records in mysql
- ruby - about errors related to migration files in rails development
- php - coincheck api authentication doesn't work
- php - i would like to introduce the coincheck api so that i can make payments with bitcoin on my ec site
- [php] i want to get account information using coincheck api
- python - you may need to restart the kernel to use updated packages error
- python 3x - typeerror: 'method' object is not subscriptable
- the emulator process for avd pixel_2_api_29 was killed occurred when the android studio emulator was started, so i would like to
- xcode - pod install [!] no `podfile 'found in the project directory
- vuejs - [vuetify] unable to locate target [data-app] i want to unit test to avoid warning
- android studio - unresolved reference comes out in kotlin