MySQL Forums
Forum List  »  Install & Repo

Unable to run multiple instances!
Posted by: Muhammad Bashir Al-Noimi
Date: July 29, 2016 12:13PM

Hi,

I want to run multiple instances of MySQL 5.7.13 under Ubuntu 14.04 x64 but when so I created a new group in my.cnf called [mysqld1] and run the following command but unfortunately I get this error message:

mbnoimivm@ubuntu:~$ sudo mysql_install_db --user=mysql --datadir=/var/lib/mysql1
[sudo] password for mbnoimivm:
2016-07-29 21:12:27 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-07-29 21:12:27 [ERROR]   Can't locate the server executable (mysqld).
mbnoimivm@ubuntu:~$ sudo service mysql status
 * MySQL Community Server 5.7.13 is running
mbnoimivm@ubuntu:~$

How can I fix this issue?

--- my.cnf ---
[client]
port        = 3306
socket        = /var/run/mysqld/mysqld.sock
default-character-set = utf8

[mysqld_safe]
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir        = /usr
datadir = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql
explicit_defaults_for_timestamp
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
key_buffer_size = 384M
max_allowed_packet = 128M
#table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 256M
thread_cache_size = 8
query_cache_size = 256M
log-error    = /var/log/mysql/error.log
symbolic-links=0
big-tables
default-storage-engine = MyISAM
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
slow-query-log = 1
slow-query-log-file = /var/log/mysql/slow.log
general-log = 1
general-log-file = /var/log/mysql/general.log
#default-time-zone = 'Europe/Istanbul'
#max_connections = 1002
#open-files-limit = 10000

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
default-character-set = utf8
no-auto-rehash

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


!includedir /etc/mysql/conf.d/

Options: ReplyQuote


Subject
Written By
Posted
Unable to run multiple instances!
July 29, 2016 12:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.