一、部署安裝MySQL

注：在安裝MySQL前需要卸載掉當(dāng)前已有的mariadb，然后需要安裝gcc環(huán)境

1、安裝cmake

[root@mysql ~]# wget https://github.com/Kitware/CMake/archive/v3.16.4.tar.gz # 下載cmake

[root@mysql ~]# yum -y install openssl-devel # 有時(shí)候安裝cmake的時(shí)候會(huì)報(bào)錯(cuò)，一般就是openssl這個(gè)依賴包沒有裝

[root@mysql ~]# tar zxf cmake-3.16.4.tar.gz

[root@mysql ~]# cd cmake-3.16.4/

[root@mysql cmake-3.16.4]# ./bootstrap

[root@mysql cmake-3.16.4]# gmake && gmake install

2、安裝ncurses

[root@mysql ~]# wget ftp://ftp.gnu.org/gnu/ncurses/ncurses-5.9.tar.gz

[root@mysql cmake-3.16.4]# cd ..

[root@mysql ~]# tar zxf ncurses-5.9.tar.gz

[root@mysql ~]# cd ncurses-5.9/

[root@mysql ncurses-5.9]# ./configure && make && make install

3、安裝bison

[root@mysql ~]# wget http://ftp.gnu.org/gnu/bison/bison-3.1.tar.gz

[root@mysql ~]# tar zxf bison-3.1.tar.gz

[root@mysql ~]# cd bison-3.1/

[root@mysql bison-3.1]# ./configure && make && make install

4、安裝boost

[root@mysql ~]# wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz/download

[root@mysql ~]# tar zxf boost_1_59_0.tar.gz

[root@mysql ~]# mv boost_1_59_0/ /usr/local/boost

5、創(chuàng)建MySQL用戶及所需目錄

[root@mysql ~]# useradd -r -M -s /sbin/nologin mysql

[root@mysql ~]# mkdir -p /usr/local/mysql/data

6、安裝及初始化MySQL

[root@mysql ~]# tar zxf mysql-5.7.29.tar.gz

[root@mysql ~]# cd mysql-5.7.29/

[root@mysql mysql-5.7.29]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_SYSTEMD=1 -DWITH_BOOST=/usr/local/boost && make && make install#配置環(huán)境變量

[root@mysql mysql-5.7.29]# echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile

[root@mysql mysql-5.7.29]# source /etc/profile#更改屬主屬組

[root@mysql mysql-5.7.29]# cd /usr/local/

[root@mysql local]# chown -R mysql:mysql mysql/#進(jìn)行初始化

[root@mysql ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

當(dāng)執(zhí)行初始化操作后，在返回信息的最后一行，將顯示著MySQL數(shù)據(jù)庫root用戶的密碼，也有可能不顯示，那就說明root用戶沒有密碼，我這里顯示的密碼如下(此密碼建議先復(fù)制到一個(gè)文本上，一會(huì)修改密碼需要用到，如果此密碼丟失，需要重新初始化MySQL，重新初始化目錄的步驟：刪除/usr/local/mysql/data目錄下的所有文件及目錄，然后才可以重新初始化成功)：

7、配置并啟動(dòng)MySQL

#再次修改當(dāng)前目錄下的屬組及屬主(初始化后，產(chǎn)生的一些文件)

[root@mysql ~]# chown -R mysql:mysql /usr/local/mysql/#編寫MySQL的主配置文件[root@mysql ~]# vim /etc/my.cnf[mysqld]basedir=/usr/local/mysqldatadir=/usr/local/mysql/dataport=3306server_id=1

#當(dāng)架構(gòu)中存在多個(gè)MySQL服務(wù)器，那么這個(gè)server_id就是各個(gè)MySQL數(shù)據(jù)庫的唯一性。socket=/usr/local/mysql/mysql.socklog-error=/usr/local/mysql/data/mysqld.errsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION#復(fù)制其服務(wù)腳本并啟動(dòng)MySQL

[root@mysql ~]# cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system

[root@mysql ~]# systemctl start mysqld

執(zhí)行啟動(dòng)命令時(shí)，會(huì)報(bào)錯(cuò)。。。。。。

可以通過MySQL錯(cuò)誤日志，定位問題所在：

[root@mysql mysql]# tail data/mysqld.err 2020-04-10T16:41:01.982743Z 0 [Note]

InnoDB: Buffer pool(s) load completed at 200411 0:41:012020-04-10T16:41:01.985619Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.2020-04-10T16:41:01.985630Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.2020-04-10T16:41:01.986055Z 0 [Warning] CA certificate ca.pem is self signed.2020-04-10T16:41:01.986086Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.2020-04-10T16:41:01.986148Z 0 [Note] Server hostname (bind-address): '*'; port: 33062020-04-10T16:41:01.986174Z 0 [Note] IPv6 is available.2020-04-10T16:41:01.986180Z 0 [Note] - '::' resolves to '::';2020-04-10T16:41:01.986195Z 0 [Note] Server socket created on IP: '::'.2020-04-10T16:41:01.987181Z 0 [ERROR] Can't start server: can't check PID filepath: No such file or directory

解決辦法：

修改其服務(wù)控制腳本中指定的PID路徑即可：

[root@mysql mysql]# vim /usr/lib/systemd/system/mysqld.service

PIDFile=/usr/local/mysql/mysqld.pid # 修改這兩行

ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file=/usr/local/mysql/mysqld.pid $MYSQLD_OPTS

確定MySQL數(shù)據(jù)庫啟動(dòng)成功

[root@mysql ~]# systemctl daemon-reload # 重載配置文件

[root@mysql ~]# systemctl restart mysqld # 重啟服務(wù)

[root@mysql ~]# netstat -anput | grep 3306 # 確認(rèn)服務(wù)啟動(dòng)

tcp6 0 0 :::3306 :::* LISTEN 92944/mysqld

8、更改MySQL的root登錄密碼

[root@mysql ~]# mysqladmin -u root -p password '123.com'

Enter password: #這里輸入初始化MySQL后返回的密碼#執(zhí)行成功后，會(huì)輸出一些warning類的提示信息，無關(guān)緊要的，是提示直接將新密碼暴露在了終端，不安全。

[root@mysql ~]# mysql -u root -p123.com # 使用新密碼登錄

總結(jié)

以上是生活随笔為你收集整理的centos 部署mysql5.7_centos7部署MySQL 5.7的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。