總所周知，MySQL在我們程序員眼中那是必不可少的饶唤。
① rpm yum 安裝
② 二進(jìn)制安裝
③ 編譯安裝
④ 先編譯徐伐，制作rpm，制作yum庫募狂，yum安裝
今天講的是二進(jìn)制安裝方式
首先我們需要獲取mysql5.7.26.tar.gz安裝包
官網(wǎng)下載：https://downloads.mysql.com/archives/community/
圖片.png
我的已經(jīng)下載完成办素，存放在f盤
圖片.png
打開我們的虛擬機(jī)，使用xshell遠(yuǎn)程連接祸穷，安裝前性穿，先檢查源
圖片.png
安裝一些依賴包
yum install -y ncurses-devel libaio-devel lszrz
圖片.png
開始部署環(huán)境
root@13k:/# mkdir application
root@13k:/# rz -E
root@13k:/# mv mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz application/
root@13k:/# cd application/
解壓,改名
root@13k:/application# tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
root@13k:/application# ls
mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz mysql-5.7.26-linux-glibc2.12-x86_64
root@13k:/application# mv mysql-5.7.26-linux-glibc2.12-x86_64/ mysql
root@13k:/application# ls
mysql
root@13k:/application# cd mysql
root@13k:/application/mysql# ll
總用量 36
drwxr-xr-x 2 root root 4096 2月 1 10:56 bin
-rw-r--r-- 1 7161 31415 17987 4月 13 2019 COPYING
drwxr-xr-x 2 root root 55 2月 1 10:56 docs
drwxr-xr-x 3 root root 4096 2月 1 10:56 include
drwxr-xr-x 5 root root 230 2月 1 10:56 lib
drwxr-xr-x 4 root root 30 2月 1 10:56 man
-rw-r--r-- 1 7161 31415 2478 4月 13 2019 README
drwxr-xr-x 28 root root 4096 2月 1 10:56 share
drwxr-xr-x 2 root root 90 2月 1 10:56 support-files
添加環(huán)境變量
root@13k:/application/mysql# vim /etc/profile
export PATH=/application/mysql/bin:$PATH
root@13k:/application/mysql# source /etc/profile
檢查是否添加成功
root@13k:/application/mysql# mysql -V
mysql Ver 14.14 Distrib 5.7.26, for linux-glibc2.12 (x86_64) using EditLine wrapper
刪除系統(tǒng)自帶的mariadb
root@13k:/application/mysql# rpm -qa |grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
root@13k:/application/mysql# yum remove mariadb-libs-5.5.56-2.el7.x86_64 -y
添加用戶
useradd -s /sbin/nologin mysql
授權(quán)
root@13k:/application/mysql# chown -R mysql.mysql /application/*
root@13k:/application/mysql# cd ..
root@13k:/application# ll
總用量 0
drwxr-xr-x 9 mysql mysql 129 2月 1 10:56 mysql
進(jìn)入mysql文件夾創(chuàng)建data數(shù)據(jù)目錄
root@13k:/application/mysql# mkdir data
root@13k:/application/mysql# ls
bin COPYING data docs include lib man README share support-files
初始化數(shù)據(jù)庫
mysqld --initialize --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
#指定用戶 程序目錄 數(shù)據(jù)目錄
root@13k:/application/mysql# mysqld --initialize --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
2020-02-01T03:05:35.363537Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-02-01T03:05:35.752400Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-02-01T03:05:35.821355Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-02-01T03:05:35.883384Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b796f373-449f-11ea-85a0-000c293e8bfe.
2020-02-01T03:05:35.885174Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-02-01T03:05:35.887220Z 1 [Note] A temporary password is generated for root@localhost: ke69s(/!Goov #這個(gè)就是數(shù)據(jù)庫的臨時(shí)密碼
寫入配置文件
cat >/etc/my.cnf <<EOF
[mysqld]
user=mysql
basedir=/application/mysql #數(shù)據(jù)庫路徑
datadir=/application/mysql/data #數(shù)據(jù)文件路徑
socket=/tmp/mysql.sock #鎖文件路徑
server_id=6
port=3306
[mysql]
socket=/tmp/mysql.sock
EOF
配置啟動(dòng)腳本
root@13k:/application/mysql# cd support-files
root@13k:/application/mysql/support-files# ./mysql.server start
Starting MySQL.Logging to '/data/mysql/db01.err'.
SUCCESS!
root@13k:/application/mysql/support-files# cd /etc/init.d/
root@13k:/etc/init.d# cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
重啟mysql服務(wù)
root@13k:/etc/init.d# service mysqld restart
Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
登錄mysql
root@13k:/etc/init.d# mysql -uroot -p
輸入密碼
設(shè)置一個(gè)密碼
mysql> set password=password("123456");
圖片.png
注意：虛擬機(jī)重啟后，登錄mysql報(bào)錯(cuò)提示mysql.sock 的問題雷滚，應(yīng)該是啟動(dòng)腳本失敗需曾，手動(dòng)啟動(dòng)mysql服務(wù)即可,或者把命令寫進(jìn)/etc/rc.local。
