共計 4599 個字符，預計需要花費 12 分鐘才能閱讀完成。
這篇文章主要講解了“怎么使用 OEL7.2 系統 system 管理源碼安裝的 mysql5.7”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著丸趣 TV 小編的思路慢慢深入，一起來研究和學習“怎么使用 OEL7.2 系統 system 管理源碼安裝的 mysql5.7”吧！
1 描述
使用 OEL7.2 系統 system 管理源碼安裝的 mysql5.7 多實例.
2 操作環境
2.1OS info
OEL7.2 x64
3 過程設計
編輯 /etc/my.cnf，本文創建 mysqld@3307.service 與 mysqld@3308.service 兩個實例，分別對應 3307 與 3308 端口。創建相應實例目錄。
復制 systemd 服務文件, 復制 mysql base 目錄下 /usr/local/mysql/usr/lib/systemd/system/ 的 mysqld@.service 文件到系統 /usr/lib/systemd/system 目錄下，并重命名成與多實例名一致的文件。
systemctl daemon-reload
systemctl start mysqld@3307.service
systemctl start mysqld@.service3308
4 詳細步驟操作
[root@localhost ~]# vi /etc/my.cnf
[root@localhost ~]# cat !$
cat /etc/my.cnf
[mysqld@3307]
datadir=/usr/local/mysql/data/3307
socket=/usr/local/mysql/data/3307/mysql.sock
port=3307
log-error=/var/log/mysqld-service3307.log
[mysqld@3308]
datadir=/usr/local/mysql/data/3308
socket=/usr/local/mysql/data/3308/mysql.sock
port=3308
log-error=/var/log/mysqld-service3308.log
[root@localhost ~]# mkdir -p /usr/local/mysql/data/3307
[root@localhost ~]# mkdir -p /usr/local/mysql/data/3308
[root@localhost ~]# chown -R mysql.mysql /usr/local/mysql/data/
[root@localhost ~]# cd /usr/lib/systemd/system
[root@localhost system]# ls -l mysqld*
-rw-r–r–. 1 root root 1637 May 3 03:07 mysqld.service
-rw-r–r–. 1 root root 1668 May 3 03:07 mysqld@.service
[root@localhost system]# cp mysqld@.service mysqld@3307
[root@localhost system]# cp mysqld@.service mysqld@3308
[root@localhost system]# systemctl daemon-reload
[root@localhost system]# mkdir /var/run/mysqld/
[root@localhost system]# chown -R mysql.mysql /var/run/mysqld
[root@localhost system]# cd /var/log/
[root@localhost log]# ls -lrt|tail
-rw-r–r–. 1 root root 8460 May 8 01:20 boot.log
-rw——-. 1 root root 1739 May 8 01:20 cron
-rw-r–r–. 1 root root 360 May 8 01:20 wpa_supplicant.log
-rw——-. 1 root root 594 May 8 01:20 maillog
-rw-rw-r–. 1 root utmp 22656 May 8 01:21 wtmp
-rw-r–r–. 1 root root 291416 May 8 01:21 lastlog
-rw-r—–. 1 mysql mysql 4377 May 8 01:24 mysqld-service3307.log
-rw-r—–. 1 mysql mysql 4449 May 8 01:24 mysqld-service3308.log
-rw——-. 1 root root 540273 May 8 01:24 messages
-rw——-. 1 root root 7764 May 8 01:24 secure
[root@localhost log]# grep password mysqld-service3307.log
2018-05-07T17:24:01.123362Z 1 [Note] A temporary password is generated for root@localhost: x aQ/IT p5%u
[root@localhost log]# grep password mysqld-service3308.log
2018-05-07T17:24:17.635837Z 1 [Note] A temporary password is generated for root@localhost: xt2aq-KYGWnt
[root@localhost log]# /usr/local/mysql/bin/mysql -uroot -p x aQ/IT p5%u -S /usr/local/mysql/data/3307/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type help; or \h for help. Type \c to clear the current input statement.
mysql exit
Bye
[root@localhost log]# /usr/local/mysql/bin/mysql -uroot -p xt2aq-KYGWnt -S /usr/local/mysql/data/3308/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type help; or \h for help. Type \c to clear the current input statement.
mysql exit
Bye
[root@localhost log]#
[root@localhost log]# systemctl stop mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root 3328 2861 0 01:32 pts/0 00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root 3335 2861 0 01:32 pts/0 00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# systemctl start mysqld@3307
[root@localhost log]# systemctl start mysqld@3308
[root@localhost log]# ps -ef |grep mysql
mysql 3367 1 5 01:32 ? 00:00:00 /usr/local/mysql/bin/mysqld –defaults-group-suffix=@3307 –daemonize –pid-file=/var/run/mysqld/mysqld-3307.pid
mysql 3420 1 10 01:32 ? 00:00:00 /usr/local/mysql/bin/mysqld –defaults-group-suffix=@3308 –daemonize –pid-file=/var/run/mysqld/mysqld-3308.pid
root 3449 2861 0 01:32 pts/0 00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl stop mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root 3459 2861 0 01:32 pts/0 00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root 3466 2861 0 01:33 pts/0 00:00:00 grep –color=auto mysql
[root@localhost log]#
感謝各位的閱讀，以上就是“怎么使用 OEL7.2 系統 system 管理源碼安裝的 mysql5.7”的內容了，經過本文的學習后，相信大家對怎么使用 OEL7.2 系統 system 管理源碼安裝的 mysql5.7 這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是丸趣 TV，丸趣 TV 小編將為大家推送更多相關知識點的文章，歡迎關注！
