运行两个mysql实例 [英] Running two instances of mysql

问题描述

我试图在同一台机器上运行两个 MySQL 实例，并将 my.cnf 文件设置如下:

I'm trying to run two instances of MySQL on the same machine and setup my.cnf file as the following:

[mysqld1]
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3307
datadir     = /var/lib/mysql

[mysqld2]
user        = mysql
pid-file    = /var/run/mysqld/mysqld2.pid
socket      = /var/run/mysqld/mysqld2.sock
port        = 3308
datadir     = /var/lib/mysql2

当我执行mysqld_multi start命令时，出现如下错误:

When I execute mysqld_multi start command, it arises the following error:

在/var/lib/mysql2 中安装新数据库

Installing new database in /var/lib/mysql2

2016-10-06 17:47:23 [警告] mysql_install_db 已弃用.请考虑切换到 mysqld --initialize 2016-10-06 17:47:23 [错误]找不到服务器可执行文件 (mysqld).

2016-10-06 17:47:23 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize 2016-10-06 17:47:23 [ERROR] Can't locate the server executable (mysqld).

致命错误:试图在 [mysqld2] 组下启动 mysqld，但没有数据找到或可以创建目录.使用的数据目录:/var/lib/mysql2

FATAL ERROR: Tried to start mysqld under group [mysqld2], but no data directory was found or could be created. data directory used: /var/lib/mysql2

我该如何解决这个问题?

How can I solve this?

注意:MySQL 在 Ubuntu 16.0.4 和 MySQL 5.7 上运行

Note: MySQL is running on Ubuntu 16.0.4 and MySQL 5.7

推荐答案

我知道一个问题.

2016-10-06 17:47:23 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize 2016-10-06 17:47:23 [ERROR] Can't locate the server executable (mysqld).

请将/use/bin/mysqld_multi 文件中的第 343 行改为 344&345 行

Please vim the line 343 to 344&345 in the file /use/bin/mysqld_multi

343   #$install_cmd="/usr/bin/mysql_install_db ";
344   $install_cmd="/usr/bin/mysqld ";
345   $install_cmd.="--initialize ";
346   $install_cmd.="--user=mysql ";
347   $install_cmd.="--datadir=$datadir";

这篇关于运行两个mysql实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！