一台linux主机启动多个MySQL数据库的方法

cd /usr/local/mysql-5.7.18/
ll

mkdir data
cd data
mkdir 3307
mkdir 3308
mkdir 3309
mkdir 3310

./mysqld --initialize-insecure --basedir=/usr/local/mysql-5.7.18 --datadir=/usr/local/mysql-5.7.18/data/3307 --user=mysql
./mysqld --initialize-insecure --basedir=/usr/local/mysql-5.7.18 --datadir=/usr/local/mysql-5.7.18/data/3308 --user=mysql
./mysqld --initialize-insecure --basedir=/usr/local/mysql-5.7.18 --datadir=/usr/local/mysql-5.7.18/data/3309 --user=mysql
./mysqld --initialize-insecure --basedir=/usr/local/mysql-5.7.18 --datadir=/usr/local/mysql-5.7.18/data/3310 --user=mysql

cd /usr/local/mysql-5.7.18/data/3307/
mkdir my.conf
vim my.cof
插入狼蚁网站SEO优化内容
[client]
port  = 3307
socker  = /usr/local/mysql-5.7.18/data/3307/mysql.sock
default-character-set=utf-8
 
[mysqld]
port  = 3307
socker  = /usr/local/mysql-5.7.18/data/3307/mysql.sock
datadir  = /usr/local/mysql-5.7.18/data/3307
log-error  = /usr/local/mysql-5.7.18/data/3307/error.log
pid-file  = /usr/local/mysql-5.7.18/data/3307/mysql.pid
 
character-set-server=utf8
lower_case_table_names=1
automit=1

cd /usr/loacl/mysql-5.7.18/bin/
./mysql_safe --defaults-file=/usr/loacl/mysql-5.7.18/data/3307/my.f &
./mysql_safe --defaults-file=/usr/loacl/mysql-5.7.18/data/3308/my.f &
./mysql_safe --defaults-file=/usr/loacl/mysql-5.7.18/data/3309/my.f &
./mysql_safe --defaults-file=/usr/loacl/mysql-5.7.18/data/3310/my.f &

./mysql -uroot -p -P3307 -h127.0.0.1 #注意在/usr/loacl/mysql-5.7.18/bin下执行

alter user 'root'@'localhost' identified by 'xxx';

grant all privileges on . to root@'%' identified by 'xxx';

flush privileges;