MariaDB多实例的安装配置

时间：2018-06-10 12:50:50 收藏：0 阅读：154

初始化数据库：

mysql_install_db --basedir=/var/lib/mysql --datadir=/data/3306/data --user=mysql

mysql_install_db --basedir=/var/lib/mysql --datadir=/data/3307/data --user=mysql

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root

[mysqld1]
socket = /data/3306/mysql.sock
port = 3306
pid-file = /data/3306/mysql.pid
datadir = /data/3306
log = /data/3306/log/mysqld1.log
user = mysql


[mysqld2]
socket = /data/3307/mysql.sock
port = 3307
pid-file = /data/3307/mysql.pid
datadir = /data/3307
log = /data/3307/log/mysqld1.log
user = mysql

mysqld_multi --defaults-extra-file=/data/my_multi.cnf start|stop 1,2

mysqladmin -uroot -S /data/3306/mysql.sock password 123456

原文：https://www.cnblogs.com/luck123/p/9162602.html