未能在我的mac上运行特定版本的mysql

Question

我有两个版本的mysql：

~ » brew info mysql                                                                                                                                                                  nirohayon@Nirs-MBP-2
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:
  mariadb (because mysql, mariadb, and percona install the same binaries.)
  mariadb-connector-c (because both install plugins)
  mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
  mysql-connector-c (because both install MySQL client libraries)
  percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.20_1 (323 files, 234.8MB) *
  Poured from bottle on 2018-01-09 at 16:39:57
/usr/local/Cellar/mysql/8.0.11 (254 files, 232.6MB)
  Poured from bottle on 2018-12-26 at 20:33:05
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats

当我切换到5.7.20_1的时候-我去mysql.server start很好，mysql打开外壳。

当我切换到8.0.11 -我去mysql.server start时，我得到了错误：

..。错误！服务器在不更新PID文件的情况下退出(/usr/local/var/MBP 2.pid)。

我不明白，我在这里错过了什么？

Answer 1

不能在同一个数据目录上运行mysql的两个实例。

pid文件用于保证同一数据库上只有一个mysqld进程同时运行。

如果要同时运行MySQL 5.7和MySQL 8，则必须定义两个不同的数据目录。