3、每一個實例單獨一個my.cnf配置文件：
[html] view plain copy PRint?datadir: /mydata/data/3306 /mydata/data/3307 my.cnf: /mydata/data/3306/my.cnf /mydata/data/3307/my.cnf 4、安裝MySQL（通用二進制方式）下面介紹開始安裝：
1：添加用戶和組
[cpp] view plain copy print?[root@CentOS mysql]# groupadd mysql [root@CentOS mysql]# useradd -r -g mysql mysql 2：安裝mysql到/usr/local/mysql下[cpp] view plain copy print?[root@CentOS ~]# cd /tmp [root@CentOS tmp]# ll mysql-5.6.27-linux-glibc2.5-i686.tar.gz -rw-r--r--. 1 root root 304056226 11月 17 04:12 mysql-5.6.27-linux-glibc2.5-i686.tar.gz [root@CentOS tmp]# tar zxf mysql-5.6.27-linux-glibc2.5-i686.tar.gz -C /usr/local/ [root@CentOS tmp]# cd /usr/local/ [root@CentOS local]# mv mysql-5.6.27-linux-glibc2.5-i686/ mysql [root@CentOS local]# chown -R mysql:mysql mysql/ 3：創(chuàng)建MySQL多實例的數(shù)據(jù)目錄[cpp] view plain copy print?[root@CentOS local]# mkdir /mydata/data/{3306,3307}/data -p [root@CentOS mysql]# chown -R mysql:mysql /mydata [root@CentOS data]# tree /mydata/data/ /mydata/data/ ├── 3306 │ └── data └── 3307 └── data 4 directories, 0 files 4：提供配置文件，并編輯[cpp] view plain copy print?[root@CentOS data]# cp /usr/local/mysql/support-files/my-default.cnf /mydata/data/3306/my.cnf [root@CentOS data]# cp /usr/local/mysql/support-files/my-default.cnf /mydata/data/3307/my.cnf [root@CentOS data]# tree /mydata/data/ /mydata/data/ ├── 3306 │ ├── data │ └── my.cnf └── 3307 ├── data └── my.cnf 4 directories, 2 files/mydata/data/3306/my.cnf # 這里是實驗環(huán)境，所以簡單配置。請各位看官根據(jù)實際需求調(diào)整[cpp] view plain copy print?[root@CentOS 3306]# vi /mydata/data/3306/my.cnf [client] passWord = 123456 port = 3306 socket = /mydata/data/3306/mysql_3306.sock default-character-set=utf8 [mysqld] port = 3306 socket = /mydata/data/3306/mysql_3306.sock pid-file = /mydata/data/3306/mysql.pid user = mysql basedir = /usr/local/mysql datadir = /mydata/data/3306 character_set_server=utf8 character_set_client=utf8 collation-server=utf8_general_ci lower_case_table_names=1 max_connections=1000 [root@CentOS 3306]# vi /mydata/data/3307/my.cnf [client] password = 123456 port = 3307 socket = /mydata/data/3307/mysql_3307.sock default-character-set=utf8 [mysqld] port = 3307 socket = /mydata/data/3307/mysql_3307.sock pid-file = /mydata/data/3307/mysql.pid user = mysql basedir = /usr/local/mysql datadir = /mydata/data/3307 character_set_server=utf8 character_set_client=utf8 collation-server=utf8_general_ci lower_case_table_names=1 max_connections=1000 5、修改數(shù)據(jù)目錄的屬主、屬組[root@CentOS /]# chown -R mysql:mysql /mydata/6、添加環(huán)境變量[root@CentOS bin]# vi /etc/profilePATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATHexport PATH[root@CentOS etc]# source /etc/profile7、初始化[root@CentOS /]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mydata/data/3306 --user=mysql[root@CentOS /]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mydata/data/3307 --user=mysql[root@CentOS /]# chown -R mysql:mysql /mydata/8、啟動/關(guān)閉 實例
[cpp] view plain copy print?[root@CentOS 3307]# netstat -tulpn | grep -i mysql [root@CentOS 3307]# mysqld_safe --defaults-file=/mydata/data/3306/my.cnf 2>&1 > /dev/null & [1] 2026 [root@CentOS 3307]# mysqld_safe --defaults-file=/mydata/data/3307/my.cnf 2>&1 > /dev/null & [2] 2251 [root@CentOS 3307]# netstat -tulpn | grep -i mysql tcp 0 0 :::3306 :::* LISTEN 2229/mysqld tcp 0 0 :::3307 :::* LISTEN 2454/mysqld # 關(guān)閉實例,這里mysql的root用戶并沒有設(shè)置密碼，密碼提示直接敲 Enter即可 [root@CentOS 3306]# mysqladmin -uroot -p -S /mydata/data/3306/mysql_3306.sock shutdown Enter password: [1]- Done mysqld_safe --defaults-file=/mydata/data/3306/my.cnf &>/dev/null (wd: /mydata/data/3307) (wd now: /mydata/data/3306) [root@CentOS 3306]# mysqladmin -uroot -p -S /mydata/data/3307/mysql_3307.sock shutdown Enter password: [2]+ Done mysqld_safe --defaults-file=/mydata/data/3307/my.cnf &>/dev/null (wd: /mydata/data/3307) (wd now: /mydata/data/3306) [root@CentOS 3306]# netstat -tulpn | grep -i mysql 9、測試連接登錄實例#我們需要指定通過哪一個套接字進行連接#注意：這里mysql的root用戶并沒有設(shè)置密碼，所以可以直接登錄[cpp] view plain copy print?[root@CentOS /]# mysql -uroot -p -S /mydata/data/3306/mysql_3306.sock mysql> create database d3306; Query OK, 1 row affected (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | d3306 | | data | | mysql | | performance_schema | | test | +--------------------+ 6 rows in set (0.02 sec) mysql> exit; [root@CentOS /]# mysql -uroot -p -S /mydata/data/3307/mysql_3307.sock mysql> create database d3307; Query OK, 1 row affected (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | d3307 | | data | | mysql | | performance_schema | | test | +--------------------+ 6 rows in set (0.01 sec) mysql> system date 2015年 11月 19日 星期四 05:00:48 CST 參考：http://www.linuxidc.com/Linux/2014-07/104508.htm
新聞熱點
疑難解答
