MYSQLD_MULTI(1) MariaDB Database System MYSQLD_MULTI(1) (NAME) mysqld_multi - MariaDB (SYNOPSIS) mysqld_multi [] {start|stop|report} [GNR[,GNR] ...] (DESCRIPTION) mysqld_multi mariadbd ( mysqld) TCP/IP . . mysqld_multi [mysqldN] ( [mariadbdN]) my.cnf ( --config-file ) . N . << >> GNR . mysqld_multi . [mysqld] ( [mariadbd]) . TCP/IP . mysqld_multi : shell> mysqld_multi [] {start|stop|report} [GNR[,GNR] ...] start stop report . GNR . mysqld_multi . GNR . . GNR [mysqld17] 17 . (dash) . GNR 10-13 [mysqld10] [mysqld13] . . ( ) GNR . [mysqld17] : shell> mysqld_multi start 17 [mysqld8] [mysqld10] [mysqld13] : shell> mysqld_multi stop 8,10-13 : shell> mysqld_multi --example mysqld_multi : o --no-defaults . o --defaults-file=file_name . o --defaults-extra-file=file_name ( ). [mysqld_multi] [mysqldN] ( [mariadbdN]) . [mysqld_multi] mysqld_multi . [mysqldN] mariadbd . [mysqld] ( [mariadbd]) [mysqld_safe] ( [mariadbd_safe]) mariadbd mariadbd_safe . --defaults-file=file_name [mysqld] [mysqld_safe] . (OPTIONS) mysqld_multi : o --help . o --example . o --log=file_name (). . o --mariadb-admin=prog_name mariadb-admin ( mysqladmin) . o --mariadbd=prog_name mariadbd ( mysqld) . mariadbd_safe ( mysqld_safe) . mariadbd_safe mariadbd ledir [mysqldN] . mariadbd_safe . ( mariadbd_safe(1) ). : [mysqld38] mariadbd = mariadbd-debug ledir = /opt/local/mysql/libexec o --no-log (stdout) . . o --password=password MariaDB mariadb-admin . MariaDB . o --silent . o --tcp-ip () MariaDB TCP/IP . . TCP/IP . . stop report . o --user=user_name MariaDB mariadb-admin . o --verbose . o --version . o --wsrep-new-cluster () . mysqld_multi: o : mysqld_multi mariadbd mariadbd . mariadbd (data directory) . . (threaded) . o : mariadbd . root . o MariaDB mariadbd ( mariadb-admin) . SHUTDOWN . . multi_admin : shell> mariadb -u root -S /tmp/mariadb.sock -p Enter password: mariadb> GRANT SHUTDOWN ON *.* -> TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'; . mysqld_multi multi_admin . o TCP/IP mariadbd . ( --bind-address ). o --pid-file mariadbd_safe mariadbd ( --mariadbd=mariadbd_safe). mariadbd (PID) . mariadbd_safe mariadbd mariadbd_safe mariadbd kill -9 (segmentation fault) . mariadbd_safe . mysqld_multi . mariadbd_safe : ---------------------------------------------------------------- MY_PWD=`pwd` # Check if we are starting this relative (for the binary release) if test -d $MY_PWD/data/mariadb -a \ -f ./share/mariadb/english/errmsg.sys -a \ -x ./bin/mariadbd ---------------------------------------------------------------- . mariadbd_safe(1) . o --user mariadbd mysqld_multi root . mariadbd . mysqld_multi . mariadbd . . [mysqldN] << >> . . # This file should probably be in your home dir (~/.my.cnf) # or /etc/my.cnf # Version 2.1 by Jani Tolonen [mysqld_multi] mariadbd = /usr/local/bin/mariadbd_safe mariadb-admin = /usr/local/bin/mariadb-admin user = multi_admin password = multipass [mysqld2] socket = /tmp/mariadb.sock2 port = 3307 pid-file = /usr/local/mysql/var2/hostname.pid2 datadir = /usr/local/mysql/var2 language = /usr/local/share/mariadb/english user = john [mysqld3] socket = /tmp/mysql.sock3 port = 3308 pid-file = /usr/local/mysql/var3/hostname.pid3 datadir = /usr/local/mysql/var3 language = /usr/local/share/mariadb/swedish user = monty [mysqld4] socket = /tmp/mysql.sock4 port = 3309 pid-file = /usr/local/mysql/var4/hostname.pid4 datadir = /usr/local/mysql/var4 language = /usr/local/share/mariadb/estonia user = tonu [mysqld6] socket = /tmp/mysql.sock6 port = 3311 pid-file = /usr/local/mysql/var6/hostname.pid6 datadir = /usr/local/mysql/var6 language = /usr/local/share/mariadb/japanese user = jani (COPYRIGHT) Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation (GNU General Public License) . . . : Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA (SEE ALSO) MariaDB : (AUTHOR) MariaDB () MariaDB 11.8 5 March 2025 MYSQLD_MULTI(1)