Mac下安装 Mysql 8.0

之前在 Mac 下安装 Mysql 8.0 的时候和 Mysql 5.7 有一些不一样的地方，这里把我自己的安装过程简单记录一下。

安装 brew

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

安装 Mysql 8.0

brew install mysql

mysql.server start

mysql_secure_installation 

mysql -uroot -p

mysql> select host,user,plugin from mysql.user;

flush privileges;

启动、停止、重启

mysql.server start
mysql.server stop
mysql.server restart

修改密码

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
FLUSH PRIVILEGES;

删除 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：需要删除其中的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.*

添加账号

CREATE USER 'sampadm'@'localhost' IDENTIFIED BY 'secret';

赋权

GRANT ALL ON sampdb.* TO 'sampadm'@'localhost';