.jpg)
這篇文章主要介紹了centos7 下mysql5.7.19安裝教程詳解,小編認(rèn)為非常不錯(cuò)，特此分享到腳本之家平臺(tái)，需要的朋友參考下吧
1、下載
從官網(wǎng)下載mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz，版本為5.7.19
下載地址：
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gzLinux
2、創(chuàng)建mysql用戶組及用戶
l? 創(chuàng)建mysql用戶組
#groupadd?mysql
l? 在mysql用戶組下創(chuàng)建mysql用戶
#useradd?mysql?-g?mysql
3、確定安裝目錄和數(shù)據(jù)目錄
我的mysql安裝目錄為/data/mysql，數(shù)據(jù)目錄為/data/mysql/data。
4、上傳安裝文件到服務(wù)器
把mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz文件通過ftp工具放到/data/installfiles目錄.
5、解壓tar.gz文件/data目錄
#cd?/data/installfiles #tar?-xvf?mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
6、修改目錄名
將mysql-5.7.19-linux-glibc2.12-x86_64更名為mysql并移動(dòng)到 /usr/local/mysql下。
#mv?mysql-5.7.19-linux-glibc2.12-x86_64?/data/mysql
7、創(chuàng)建存放數(shù)據(jù)目錄
在/data /mysql下創(chuàng)建data目錄
#mkdir?/data/mysql/data
8、對(duì)mysql用戶進(jìn)行授權(quán)
?將mysql目錄及下面的文件、子目錄文件主改成mysql
#cd?/data #chown?-R?mysql:mysql?mysql/
給與mysql目錄及下面的文件、子目錄755權(quán)限
#chmod?-R?755?mysql/
9、編譯安裝并初始化mysql，并記住臨時(shí)密碼
#/data/mysql/bin/mysqld?--initialize?--user=mysql?--datadir=/data/mysql/data?--basedir=/data/mysql
當(dāng)時(shí)安裝的臨時(shí)密碼為：root@localhost:3?2YBeSg:Nte?
10、創(chuàng)建日志文件目錄
mkdir?-p?/data/mysql/log/mariadb/ cd?/data/mysql/log/mariadb/ touch?mariadb.log chmod?-R?775?mariadb.log chown?-R?mysql:mysql?mariadb.log chown?-R?mysql:mysql?/data/mysql
11、啟動(dòng)mysql服務(wù)
/data/mysql/support-files/mysql.server?start
12、登錄msyql，輸入密碼（密碼為第9步驟的初始化密碼）
#mysql?-u?root?-p
13、 修改密碼為“123456”
msql>alter?user?'root'@'localhost'?identified?by?'123456'; mysql>use?mysql; msyql>update?user?set?user.Host='%'?where?user.User='root'; mysql>flush?privileges; mysql>quit
14、修改/etc/my.cnf文件
#?instructions?in?http://fedoraproject.org/wiki/Systemd socket=/tmp/mysql.sock [mysqld] datadir=/data/mysql/data socket=/tmp/mysql.sock max_connections=1000 #?Disabling?symbolic-links?is?recommended?to?prevent?assorted?security?risks symbolic-links=0 #?Settings?user?and?group?are?ignored?when?systemd?is?used. #?If?you?need?to?run?mysqld?under?a?different?user?or?group, #?customize?your?systemd?unit?file?for?mariadb?according?to?the #?instructions?in?http://fedoraproject.org/wiki/Systemd [mysqld_safe] log-error=/data/mysql/log/mariadb/mariadb.log pid-file=/data/mysql/run/mariadb/mariadb.pid # #?include?all?files?from?the?config?Directory # !includedir?/etc/my.cnf.d
修改標(biāo)紅部分內(nèi)容。
.png)
