共計 2976 個字符，預計需要花費 8 分鐘才能閱讀完成。
這篇文章主要介紹多實例安裝 mysql 5.7 的示例分析，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！
datadir:
mkdir -p /home/data/3306
mkdir -p /home/data/3307
mkdir -p /home/data/3308
chown -R mysql /home/data/
cd /opt/mysql
初始化 mysql
./bin/mysqld –initialize –datadir=/home/data/3306 –user=mysql
./bin/mysqld –initialize –datadir=/home/data/3307 –user=mysql
./bin/mysqld –initialize –datadir=/home/data/3308 –user=mysql
啟動 mysql
bin/mysqld_safe –defaults-file=/opt/mysql/3306.cnf –user=mysql
bin/mysqld_safe –defaults-file=/opt/mysql/3307.cnf –user=mysql
bin/mysqld_safe –defaults-file=/opt/mysql/3308.cnf –user=mysql
修改密碼
注意: 執行 bin/mysqld –initialize 的時候, 日志會輸出初始化的密碼
關鍵字 A temporary password is generated for root@localhost:
mysql set password = password(rootroot
mysql flush privileges;
配置環境變量
vim /etc/profile 添加
export PATH=$PATH:/opt/mysql/bin
刷新環境變量
source /etc/profile
配置別名
vim /root/.bashrc
“`
alias mysql3306= mysql -uroot -prootroot -P3306 –socket=/home/data/3306/mysql.sock
alias start_mysql_3306= /opt/mysql/bin/mysqld_safe –defaults-file=/opt/mysql/3306.cnf –user=mysql
alias stop_mysql_3306= mysqladmin shutdown -uroot -p rootroot –socket=/home/data/3306/mysql.sock
alias mysql3307= mysql -uroot -prootroot -P3307 –socket=/home/data/3307/mysql.sock
alias start_mysql_3307= /opt/mysql/bin/mysqld_safe –defaults-file=/opt/mysql/3307.cnf –user=mysql
alias stop_mysql_3307= mysqladmin shutdown -uroot -p rootroot –socket=/home/data/3307/mysql.sock
alias mysql3308= mysql -uroot -prootroot -P3308 –socket=/home/data/3308/mysql.sock
alias start_mysql_3308= /opt/mysql/bin/mysqld_safe –defaults-file=/opt/mysql/3308.cnf –user=mysql
alias stop_mysql_3308= mysqladmin shutdown -uroot -p rootroot –socket=/home/data/3308/mysql.sock
“`
建立主從
change master to
MASTER_HOST= 192.168.64.52 ,
MASTER_USER= root ,
MASTER_PASSWORD= rootroot ,
MASTER_PORT=3306,
MASTER_CONNECT_RETRY=10,
MASTER_AUTO_POSITION = 1;
編輯 /opt/mysql/3306.cnf
“`
[mysql]
prompt = \u@master \R:\m:\s [\d]
[client]
port = 3306
socket = /data/mysql/data/mysql.sock
[mysqld]
datadir=/home/data/3306
socket=/home/data/3306/mysql.sock
skip-name-resolve
symbolic-links=0
log_bin = binlog
binlog_format= ROW
slow_query_log = 1
slow_query_log_file = slow.log
log-error = error.log
innodb_buffer_pool_size =512MB
innodb_buffer_pool_instances = 1
[mysqld_safe]
log-error=/home/data/3306/mysqld-err.log
“`
編輯 /opt/mysql/3307.cnf
“`
[mysql]
prompt = \u@3307\R:\m:\s [\d]
[client]
port =3307
socket = /data/mysql/data/mysql.sock
[mysqld]
datadir=/home/data/3307
socket=/home/data/3307/mysql.sock
skip-name-resolve
symbolic-links=0
log_bin = binlog
binlog_format= ROW
slow_query_log = 1
slow_query_log_file = slow.log
log-error = error.log
innodb_buffer_pool_size =512MB
innodb_buffer_pool_instances = 1
“`
編輯 /opt/mysql/3308.cnf
“`
[mysql]
prompt = \u@3308\R:\m:\s [\d]
[client]
port =3308
socket = /data/mysql/data/mysql.sock
[mysqld]
datadir=/home/data/3308
socket=/home/data/3308/mysql.sock
skip-name-resolve
symbolic-links=0
log_bin = binlog
binlog_format= ROW
slow_query_log = 1
slow_query_log_file = slow.log
log-error = error.log
innodb_buffer_pool_size =512MB
innodb_buffer_pool_instances = 1
“`
以上是“多實例安裝 mysql 5.7 的示例分析”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注丸趣 TV 行業資訊頻道！
