mysqld_multi will not start as /var/run/mysqld' for UNIX socket file don't exists

merlin

11/13/22, 3:39 PM

I am trying to start 2 mysql instances on boot (ubuntu 20.04) by using mysqld_multi. The system complains that the directory /var/run/mysqld is missing and I can not figure out why?

content of /etc/mysql/my.cnf:

mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
#user       = multi_admin
#password   = multipass
log        = /var/log/mysql/error.log

[mysqld2]

# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
datadir         = /mnt/data/mysql/data

Logfile:

~$ sudo tail -f /var/log/mysql/error.log
mysqld_multi log file version 2.16; run: Tue Jul 13 17:04:33 2021

Starting MySQL servers

sudo mysqld_multi start 2

logfile:

2021-07-13T15:04:33.578787Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2021-07-13T15:04:33.584507Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
mysqld_multi log file version 2.16; run: Tue Jul 13 17:04:35 2021

Reporting MySQL servers
MySQL server from group: mysqld2 is not running

Without multi the server starts just fine.

179

0 + 0

mysql

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: mysqld_multi will not start as /var/run/mysqld' for UNIX socket file don't exists

TH: mysqld_multi จะไม่เริ่มทำงานเนื่องจาก /var/run/mysqld' ไม่มีไฟล์ซ็อกเก็ต UNIX

RO: mysqld_multi nu va porni ca /var/run/mysqld' pentru fișierul socket UNIX nu există

RU: mysqld_multi не запускается, так как /var/run/mysqld' для файла сокета UNIX не существует

VI: mysqld_multi sẽ không bắt đầu vì /var/run/mysqld' đối với tệp ổ cắm UNIX không tồn tại

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.