Mac 上安装多个mysql服务器同时运行

直接上三部曲

第一步: 安装多个mysql服务

brew install mysql@5.7

brew install mysql@8.0

第二步: 需要给每个不同的mysql版本配置不同的基本信息

mysql5.7的配置文件my.57.cnf

[mysqld]
bind-address = 127.0.0.1
datadir      = /usr/local/var/mysql57
socket       = /tmp/mysql57/mysql.sock
port         = 3306

[mysqld_safe]
log-error    = /usr/local/var/log/mysql57/mysqld.log
pid-file     = /usr/local/var/run/mysql57/mysqld.pid

mysql8.0的配置文件my.80.cnf

[mysqld]
bind-address = 127.0.0.1
port         = 3307
datadir      = /usr/local/var/mysql80
socket       = /tmp/mysql80/mysql.sock
port         = 3307

[mysqld_safe]
log-error    = /usr/local/var/log/mysql80/mysqld.log
pid-file     = /usr/local/var/run/mysql80/mysqld.pid

第三步: 启动每个服务瞅瞅看哦

brew services start mysql@5.7

brew services start mysql@8.0

因为Mac启动加入了开机自启的开关,所以需要在启动服务的时候带上我们自己配置的配置文件哦

~/Library/LaunchAgents 文件夹是开机自启的任务文件,找到我们启动之后的对应版本的自启任务文件 homebrew.mxcl.mysql@5.7.plist和 homebrew.mxcl.mysql@8.0.plist

里面的配置如下:

homebrew.mxcl.mysql@5.7.plist

<key>ProgramArguments</key>
    <array>
        <string>/usr/local/opt/mysql@5.7/bin/mysqld_safe</string>
        <string>--defaults-file=/usr/local/etc/my.57.cnf</string>
        <string>--datadir=/usr/local/var/mysql57</string>
    </array>

 homebrew.mxcl.mysql@8.0.plist

<key>ProgramArguments</key>
    <array>
        <string>/usr/local/opt/mysql@8.0/bin/mysqld_safe</string>
        <string>--defaults-file=/usr/local/etc/my.80.cnf</string>
        <string>--datadir=/usr/local/var/mysql80</string>
    </array>

进入终端中瞅瞅

/usr/local/opt/mysql@5.7/bin/mysql --socket=/tmp/mysql57/mysql.sock -u root -p

/usr/local/opt/mysql@8.0/bin/mysql --socket=/tmp/mysql80/mysql.sock -u root -p

货分享到此哦