一、mysql编译安装：

cd/usr/local/srcwgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gztarzxvfmysql-5.6.35-linux-glibc2.5-x86_64.tar.gzmvmysql-5.6.35-linux-glibc2.5-x86_64/usr/local/mysqlcd/usr/local/mysqluseraddmysqlmkdir-p/data/mysqlchown-Rmysql:mysql/data/mysql./scripts/mysql_install_db--user=mysql--datadir=/data/mysqlcpsupport-files/my-default.cnf/etc/my.cnfcpsupport-files/mysql.server/etc/init.d/mysqld

2.1 创建目录：

mkdir/usr/local/mysql3307chown-Rmysql.mysql/usr/local/mysql3307/mkdir-p/data/mysql3307chown-Rmysql.mysql/data/mysql3307mkdir-p/home/data/mysql3307/binlogchown-Rmysql.mysql/home/data/mysql3307

2.2 配置文件

[root@zhdya01~]#vim/etc/my.cnf#Foradviceonhowtochangesettingspleasesee#http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html#***DONOTEDITTHISFILE.It'satemplatewhichwillbecopiedtothe#***defaultlocationduringinstall,andwillbereplacedifyou#***upgradetoanewerversionofMySQL.[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminlog=/var/log/mysqld_multi.log[mysqld1]socket=/usr/local/mysql3307/mysql.sockport=3307pid-file=/usr/local/mysql3307/mysql.piddatadir=/data/mysql3307log_bin=/home/data/mysql3307/binlogserver-id=1innodb_buffer_pool_size=128Minnodb_flush_log_at_trx_commit=0

2.3 初始化数据库

/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql3307

3.1 创建目录：

mkdir/usr/local/mysql3308chown-Rmysql.mysql/usr/local/mysql3308/mkdir-p/data/mysql3308chown-Rmysql.mysql/data/mysql3308mkdir-p/home/data/mysql3308/binlogchown-Rmysql.mysql/home/data/mysql3308

3.2 配置文件

[root@zhdya01~]#vim/etc/my.cnf#Foradviceonhowtochangesettingspleasesee#http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html#***DONOTEDITTHISFILE.It'satemplatewhichwillbecopiedtothe#***defaultlocationduringinstall,andwillbereplacedifyou#***upgradetoanewerversionofMySQL.[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminlog=/var/log/mysqld_multi.log[mysqld1]socket=/usr/local/mysql3307/mysql.sockport=3307pid-file=/usr/local/mysql3307/mysql.piddatadir=/data/mysql3307log_bin=/home/data/mysql3307/binlogserver-id=1innodb_buffer_pool_size=128Minnodb_flush_log_at_trx_commit=0[mysqld2]socket=/usr/local/mysql3308/mysql.sockport=3308pid-file=/usr/local/mysql3308/mysql.piddatadir=/data/mysql3308log_bin=/home/data/mysql3308/binlogserver-id=2innodb_buffer_pool_size=128Minnodb_flush_log_at_trx_commit=0

3.3 初始化数据库

/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql3308

/etc/init.d/mysqldstartmysqld_multi--defaults-extra-file=/etc/my.cnfstart1,2[root@zhdya01bin]#!netnetstat-lntp-lntpActiveInternetconnections(onlyservers)ProtoRecv-QSend-QLocalAddressForeignAddressStatePID/Programnametcp000.0.0.0:220.0.0.0:*LISTEN1241/sshdtcp00127.0.0.1:250.0.0.0:*LISTEN2087/mastertcp600:::3306:::*LISTEN4406/mysqldtcp600:::3307:::*LISTEN4197/mysqldtcp600:::3308:::*LISTEN3359/mysqldtcp600:::8080:::*LISTEN2222/javatcp600:::22:::*LISTEN1241/sshdtcp600::1:25:::*LISTEN2087/master

[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfreportReportingMySQLserversMySQLserverfromgroup:mysqld1isrunningMySQLserverfromgroup:mysqld2isrunning

[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfstop1,2[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfreportReportingMySQLserversMySQLserverfromgroup:mysqld1isnotrunningMySQLserverfromgroup:mysqld2isnotrunning

[root@zhdya01bin]#mysql--socket=/usr/local/mysql3307/mysql.sockWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis1Serverversion:5.6.35-logMySQLCommunityServer(GPL)Copyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>