Mac os 使用brew安装mysql
第一步:下载安装
brew install mysql
第二步:设为开机自启
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
第三步:启动mysql
mysql.server start
第四步:进入mysql
mysql -uroot
第五步:配置密码
select user,password,host from mysql.user;
delete from mysql.user where user='';
delete from mysql.user where host='::1';
set password for root@localhost=password('000000');
GRANT ALL PRIVILEGES ON *.* TO 'miaohr'@'%' IDENTIFIED BY '000000';
flush privileges;
第六步:重启mysql
mysql.server restart
卸载mysql:
brew remove mysql
brew cleanup
launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
rm ~/Library/LaunchAgents/com.mysql.mysqld.plist
sudo rm -rf /usr/local/var/mysql