步驟如下：

一、編譯安裝兩個mysql，步驟如下

安裝第一個數據庫(主數據庫)

(紅色部分為默認數據庫文件路徑，可改成其他如：data、var等)

tar zxvf mysql-6.0.11-alpha.tar.gz

cd mysql-6.0.11-alpha

./configure --prefix=/usr/local/mysql3306 --sysconfdir=/usr/local/mysql/etc --with-tcp-port=3306 --localstatedir=/usr/local/mysql3306/var--with-unix-socket-path=/tmp/mysql3306.sock --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=gbk,gb2312,binary --enable-thread-safe-client --with-plugins=innobase --with-mysqld-user=mysql --with-charset=utf8? --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static

make && make install

安裝第二個數據庫(從數據庫)

tar zxvf mysql-6.0.11-alpha.tar.gz

cd mysql-6.0.11-alpha

./configure --prefix=/usr/local/mysql3307 --sysconfdir=/usr/local/mysql3307/etc --with-tcp-port=3307 --localstatedir=/usr/local/mysql3307/var--with-unix-socket-path=/tmp/mysql3307.sock --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=gbk,gb2312,binary --enable-thread-safe-client --with-plugins=innobase --with-mysqld-user=mysql --with-charset=utf8? --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static

make && make install

如需支持所有字符集 修改為：--with-extra-charsets=all 即可

二、分別初始化數據庫腳本(在編譯目錄執行下)

scripts/mysql_install_db --basedir=/usr/local/mysql3306/ --user=mysql

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

注：可用--datadir=PATH參數指定數據庫文件路徑，默認為編譯時-- localstatedir

三、修改從庫配置文件

拷貝配置文件：

cp /usr/local/software/mysql-6.0.11-alpha/support-files/my-medium.cnf /usr/local/mysql/etc/my.cnf

cp /usr/local/software/mysql-6.0.11-alpha/support-files/my-medium.cnf /usr/local/mysql3307/etc/my.cnf

四、修改各個數據庫的my.cnf文件

主要內容如下：

添加InnoDB支持：

[client]

#password?????? = your_password

port??????????? = 3307????????????????????? --數據庫端口號

socket????????? = /tmp/mysqls.sock??? --sock文件路徑

default-character-set=utf8??????????? --客戶端UTF8連接

[mysqld]

port??????????? = 3307????????????????????? --數據庫端口號

socket????????? = /tmp/mysqls.sock ?? --sock文件路徑

default-storage-engine=INNODB

default-character-set=UTF8?????????? --默認字符集

init_connect='SET NAMES utf8'?????? --以UTF8連接

skip-name-resolve?????????????????????? ?--取消DNS反向解析

lower_case_table_names=1??????????? --不區分表名大小寫

啟動數據庫(進入各自目錄)

主：./scripts/mysqld_safe &

從：./scripts/mysqld_safe &

配置開啟自動：

cp /usr/local/software/mysql-6.0.11-alpha/support-files/mysql.server /etc/init.d/mysql

cp /usr/local/software/mysql-6.0.11-alpha/support-files/mysql.server /etc/init.d/mysql3307

修改/etc/init.d/mysql3007中basedir與datadir為即可

basedir=/usr/local/mysql3307

datadir=/usr/local/mysql3307/var

停止數據庫

主：./mysqladmin shutdown

從：./mysqladmin shutdown

總結

以上是生活随笔為你收集整理的mysql配置两个猪数据库_Linux下安装启动多个Mysql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。