1. 发现问题
mysql启动出现报错,一直提示:
ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.pid)
详情请看启动mysql服务时一直提示ERROR The server quit without updating PID file
2. 解决问题
修改/usr/local/mysql8.0/support-files/mysql.server文件中mysqld_safe的启动选项,在第266行加上--user=root --port=3307
两个选项,并使用sudo /usr/local/mysql8.0/support-files/mysql.server start
和sudo /usr/local/mysql8.0/support-files/mysql.server stop
启动和停止服务。
$bindir/mysqld_safe --user=root --port=3307 --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args
用软链接区分不同目录。
# sudo ln -s mysql-5.7.31-macos10.14-x86_64 mysql5.7
# sudo ln -s mysql-8.0.32-macos13-arm64 mysql8.0
添加快速启动命令。
# vim ~/.bash_profile
alias mysql5.7_start="sudo /usr/local/mysql5.7/support-files/mysql.server start"
alias mysql5.7_stop="sudo /usr/local/mysql5.7/support-files/mysql.server stop"
alias mysql8.0_start="sudo /usr/local/mysql8.0/support-files/mysql.server start"
alias mysql8.0_stop="sudo /usr/local/mysql8.0/support-files/mysql.server stop"
# source ~/.bash_profile
测试链接mysql5.7和mysql8.0。