1:创建多个mysql的配置文件,如my3306.cnf,my3307.cnf,my3308.cnf
my3306.cnf 指定socket ,端口,文件路径,错误信息
[mysqld]
socket = /var/lib/mysql3306/mysql.sock
port = 3306
datadir = /var/lib/mysql3306
log-error = /var/log/mysql1.err
my3307.cnf配置:
[mysqld]
socket = /var/lib/mysql3307/mysql.sock
port = 3307
datadir = /var/lib/mysql3307
log-error = /var/log/mysql2.err
my3308.cnf配置:
[mysqld]
socket = /var/lib/mysql3308/mysql.sock
port = 3308
datadir = /var/lib/mysql3308
log-error = /var/log/mysql3.err
安装MySQL
rpm -ivh 安装包.rpm --force
rpm -ivh 安装包.rpm --force
rpm -ivh 安装包.rpm --force
MySQL初始化
mysql_install_db --user=mysql --ldata=/var/lib/mysql3306
mysql_install_db --user=mysql --ldata=/var/lib/mysql3307
mysql_install_db --user=mysql --ldata=/var/lib/mysql3308
MySQL启动
mysqld_safe--defaults-extra-file=/etc/my3306.cnf --user=mysql --skip-grant-tables
mysqld_safe--defaults-extra-file=/etc/my3307.cnf --user=mysql
--skip-grant-tables
mysqld_safe--defaults-extra-file=/etc/my3308.cnf --user=mysql
--skip-grant-tables
echo "usemysql; " >a.sql
echo"update user set password=password(\"$1\") whereuser=\"root\";">>a.sql
echo"delete from user where user='' or user is null;">>a.sql
echo"update user set host='%' where host='localhost';">>a.sql
echo "flushprivileges; ">>a.sql
mysql –P3306<a.sql
mysql –P3307<a.sql
mysql –P3308<a.sql
使用以下命令启动对应的mysql服务端口:
mysqld_safe --defaults-extra-file=/etc/my3306.cnf
mysqld_safe--defaults-extra-file=/etc/my3307.cnf
mysqld_safe --defaults-extra-file=/etc/my3308.cnf
停止MYSQL服务端口:
mysqladmin -uroot -S /var/lib/mysql3306/mysql.sock shutdown -P密码
mysqladmin -uroot -S /var/lib/mysql3307/mysql.sockshutdown -P密码
mysqladmin -uroot -S /var/lib/mysql3308/mysql.sockshutdown -P密码