mysql安装的坑

安装
推荐使用homebrew，官方下载可能出现问题

brew install mysql

如果安装失败 可能是homebrew的镜像有问题
修改配置文件 vim ~/.bash_profile
修改homebrew镜像 https://blog.csdn.net/ZQD666/article/details/106875722/
保存配置 source ~/.bash_profile

安装结束会提示

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start

执行mysql.server start，可能报错

bogon:~ xueqiu$ /usr/local/Cellar/mysql/8.0.19_1/bin/mysqld_safe: line 144: /usr/local/var/mysql/bogon.err: Permission denied
rm: /usr/local/var/mysql/bogon.pid: Permission denied
2020-10-14T02:16:04.6NZ mysqld_safe Fatal error: Can't remove the pid file:
/usr/local/var/mysql/bogon.pid.
Please remove the file manually and start /usr/local/Cellar/mysql/8.0.19_1/bin/mysqld_safe again;
mysqld daemon not started
/usr/local/Cellar/mysql/8.0.19_1/bin/mysqld_safe: line 144: /usr/local/var/mysql/bogon.err: Permission denied

可能是之前安装的版本卸载的不干净，一定把当前的版本的mysql卸载干净后重新安装才行。

brew uninstall -f mysql
brew cleanup
// 将 Cellar 目录下相关的 mysql 目录都删除
rm -rf /usr/local/Cellar/mysql
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*
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*
sudo rm -f /etc/my.cnf
brew install mysql //重新安装，然后再次启动
mysql.server start //直接出现SUCCESS!

也有可能mysql文件的访问权限问题

// 修改权限
chown -R mysql:mysql /usr/local/var/mysql

链接数据库

mysql -u root -p
// 登录密码是空，直接enter即可登录

注意：mysql语句的每一段命令必须用分号作为结尾。

修改密码

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

退出数据库

mysql> quit;

下次使用

打开数据库
mysql.server start
查看数据库状态
mysql.server status
重新打开数据库
sudo mysql.server restart
链接数据库
mysql -u root -p
创建数据库
mysql> create DATABASE RUNOOB;
。。。。