刪除MySql
brew uninstall mysql
brew cleanup
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo vim /etc/hostconfig （ps：需要?jiǎng)h除其中的MYSQLCOM=-YES-）
sudo rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*
安裝brew
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
安裝MySQL
brew install mysql
mysql.server start
mysql_secure_installation?
mysql -uroot -p
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host? ? ? | user? ? ? ? ? ? | plugin? ? ? ? ? ? ? ? |
+-----------+------------------+-----------------------+
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session? ? | caching_sha2_password |
| localhost | mysql.sys? ? ? ? | caching_sha2_password |
| localhost | root? ? ? ? ? ? | caching_sha2_password | |
+-----------+------------------+-----------------------+
4 rows in set (0.00 sec)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';?
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host? ? ? | user? ? ? ? ? ? | plugin? ? ? ? ? ? ? ? |
+-----------+------------------+-----------------------+
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session? ? | caching_sha2_password |
| localhost | mysql.sys? ? ? ? | caching_sha2_password |
| localhost | root? ? ? ? ? ? | mysql_native_password |
+-----------+------------------+-----------------------+
4 rows in set (0.01 sec)
flush privileges;
