Mac 安装多个版本的mysql

1.安装多个版本的 MySQL安装 MySQL 8.4brew install mysql8.4安装 MySQL 8.0brew install mysql8.02. 为两个实例分别建立配置文件MySQL 8.4 配置 /Users/xxx/Documents/my84.cnf 内容如下[mysqld] port 3307 socket /tmp/mysql84.sock datadir /Users/xxx/Documents/var/mysql84 pid-file /Users/xxx/Documents/var/mysql84/mysql84.pid log-error /Users/xxx/Documents/var/mysql84/error.log server-id 2 [client] port 3307 socket /tmp/mysql84.sockMySQL 8.0 配置 /Users/xxx/Documents/my80.cnf 内容如下[mysqld] port 3306 socket /tmp/mysql80.sock datadir /Users/xxx/Documents/var/mysql80 pid-file /Users/xxx/Documents/var/mysql80/mysql80.pid log-error /Users/xxx/Documents/var/mysql80/error.log server-id 1 [client] port 3306 socket /tmp/mysql80.sock3. 初始化mysql数据目录创建数据目录mkdir -p /Users/xxx/Documents/var//mysql84mkdir -p /Users/xxx/Documents/var//mysql80mysql安装位置ps: 不同系统位置可能不同自己找一下/opt/homebrew/Cellar/mysql/初始化 MySQL 8.4/opt/homebrew/Cellar/mysql8.4/8.4.8/bin/mysqld --defaults-file/Users/xxx/Documents/my84.cnf --initialize-insecure初始化 MySQL 8.0/opt/homebrew/Cellar/mysql8.0/8.0.45/bin/mysqld --defaults-file/Users/xxx/Documents/my80.cnf --initialize-insecure4. 启动和停止服务启动 MySQL 8.4/opt/homebrew/Cellar/mysql8.4/8.4.8/bin/mysqld_safe --defaults-file/Users/xxx/Documents/my84.cnf 启动 MySQL 8.0/opt/homebrew/Cellar/mysql8.0/8.0.45/bin/mysqld_safe --defaults-file/Users/xxx/Documents/my80.cnf 连接到不同版本数据库mysql -S /tmp/mysql84.sock -u root -p # 连接 8.4mysql -S /tmp/mysql80.sock -u root -p # 连接 8.0停止 MySQL 8.0/opt/homebrew/Cellar/mysql8.0/8.0.45/bin/mysqladmin -uroot -p -S /tmp/mysql80.sock shutdown停止 MySQL 8.4/opt/homebrew/Cellar/mysql8.4/8.4.8/bin/mysqladmin -uroot -p -S /tmp/mysql84.sock shutdown查看mysql进程是否存在ps -ef | grep mysql