初始化数据库:
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
附录:
MariaDB [(none)]> show variables like '%timeout%';
MariaDB [(none)]> show variables like 'log_bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
+---------------------------------+-------+
2 rows in set (0.00 sec)
#手动修改参数
MariaDB [(none)]> set global wait_timeout=30;
flush table with read lock #锁表
unlock tables #解锁