之前在 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';