.jpg)
本篇文章給大家介紹一下mysql進(jìn)行安裝部署的方法。有一定的參考價(jià)值，有需要的朋友可以參考一下，希望對(duì)大家有所幫助。
mysql安裝部署
1.二進(jìn)制安裝
1.清除殘留軟件
rpm?-qa|grep?mariadb yum?remove?mariadb-libs?-y rm?-rf?/etc/my.cnf
2.下載軟件包安裝依賴
wget?https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz yum?install?-y?libaio-devel
3.解壓到指定目錄
tar?zxf?mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz?-C?/opt/ mv?/opt/mysql-5.7.28-linux-glibc2.12-x86_64?/opt/mysql-5.7.28
4.創(chuàng)建軟鏈接
ln?-s?/opt/mysql-5.7.28?/opt/mysql
5.配置環(huán)境變量
echo?'export?PATH=$PATH:/opt/mysql/bin'?>>/etc/profile source?/etc/profile mysql?-V
6.編寫(xiě)配置文件
ccat>?/etc/my.cnf?<h3>7.創(chuàng)建數(shù)據(jù)目錄</h3><pre class="brush:sql;toolbar:false;">mkdir?-p?/data/mysql_3306
8.創(chuàng)建mysql用戶
useradd?-s?/sbin/nologin?-M?mysql
9.授權(quán)軟件目錄和數(shù)據(jù)目錄為mysql
chown?-R?mysql:mysql?/data/ chown?-R?mysql:mysql?/opt/mysql*
10.初始化數(shù)據(jù)庫(kù)目錄
mysqld?--initialize-insecure?--user=mysql?--basedir=/opt/mysql?--datadir=/data/mysql_3306/
11.復(fù)制啟動(dòng)文件并配置systemctl
cp?/opt/mysql/support-files/mysql.server?/etc/init.d/mysqld chkconfig?--add?mysqld systemctl?start?mysqld
12.檢查
netstat?-lntup|grep?3306 mysql
2.多實(shí)例安裝配置
1.創(chuàng)建多實(shí)例的數(shù)據(jù)目錄
mkdir?-p?/data/mysql_330{7,8} chown?-R?mysql:mysql?/data/mysql_330*
2.初始化數(shù)據(jù)庫(kù)目錄
mysqld?--initialize-insecure?--user=mysql?--basedir=/opt/mysql?--datadir=/data/mysql_3307/ mysqld?--initialize-insecure?--user=mysql?--basedir=/opt/mysql?--datadir=/data/mysql_3308/
3.創(chuàng)建多實(shí)例配置文件
cat?>/data/mysql_3307/my.cnf?/data/mysql_3308/my.cnf?<h3>4.配置啟動(dòng)文件</h3><pre class="brush:sql;toolbar:false;">cat?>/etc/systemd/system/mysqld_3307.service?/etc/systemd/system/mysqld_3308.service?<h3>5.重載并重啟</h3><pre class="brush:sql;toolbar:false;">systemctl?daemon-reload systemctl?start?mysqld_3307.service?mysqld_3308.service
6.檢查多實(shí)例是否啟動(dòng)成功查看端口
netstat?-lntup|grep?330*
7.配置密碼
mysqladmin?password?-S?/tmp/mysql_3307.sock mysqladmin?password?-S?/tmp/mysql_3308.sock
8.登陸多實(shí)例
mysql?-S?/tmp/mysql_3307.sock?-p mysql?-S?/tmp/mysql_3308.sock?-p
相關(guān)推薦：《mysql教程》
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
