這篇文章主要為大家展示了“l(fā)inux如何安裝MySQL5.7的方法”,內(nèi)容簡(jiǎn)而易懂,條理清晰,希望能夠幫助大家解決疑惑,下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“l(fā)inux如何安裝mysql5.7的方法”這篇文章吧。
創(chuàng)新互聯(lián)是一家專注于網(wǎng)站設(shè)計(jì)、成都網(wǎng)站設(shè)計(jì)與策劃設(shè)計(jì),安慶網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)做網(wǎng)站,專注于網(wǎng)站建設(shè)十載,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:安慶等地區(qū)。安慶做網(wǎng)站價(jià)格咨詢:18982081108
mysql 單節(jié)點(diǎn)安裝,前查詢:https://my.oschina.net/u/3411575/blog/5047890
步驟1:
自行下載mysql5.7
步驟2:
解壓:
tar -xvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
步驟3:
移動(dòng)解壓得到的文件夾,并重命名:
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
步驟4:
創(chuàng)建文件夾
/home/mysql/data3306
/home/mysql/data3307
/home/mysql/data3309
步驟5:
編輯/etc/my.cnf
client] port=3306 socket=/tmp/mysql.sock [mysqld_multi] mysqld = /usr/local/mysql/bin/mysqld_safe mysqladmin = /usr/local/mysql/bin/mysqladmin log = /home/mysql/mysqld_multi.log [mysqld] user=mysql basedir = /usr/local/mysql sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION [mysqld3306] mysqld=mysqld mysqladmin=mysqladmin datadir=/home/mysql/data3306/data port=3306 server_id=3306 socket=/tmp/data3306.sock log-output=file slow_query_log = 1 long_query_time = 1 slow_query_log_file = /home/mysql/mysql3306/log/slow.log log-error = /home/mysql/mysql3306/log/error.log binlog_format = mixed log-bin = /home/mysql/mysql3306/log/mysql3306_bin [mysqld3309] mysqld=mysqld mysqladmin=mysqladmin datadir=/home/mysql/data3308/data port=3309 server_id=3309 socket=/tmp/data3309.sock log-output=file slow_query_log = 1 long_query_time = 1 slow_query_log_file = /home/mysql/mysql3309/log/slow.log log-error = /home/mysql/mysql3309/log/error.log binlog_format = mixed log-bin = /home/mysql/mysql3309/log/mysql3309_bin
步驟6:
新建單獨(dú)實(shí)例的初始化配置文件(要與/etc/my.cnf文件配置保持一致) 分別存放在 /home/mysql/data3306 /home/mysql/data3307 /home/mysql/data3309 中
my.cnf(3306.cnf)
[client] port= 3306 socket= /home/mysql/data3306/mysql.sock default-character-set=utf8 [mysqld] user=mysql port=3306 basedir=/usr/local/mysql datadir=/home/mysql/data3306/data server_id=3306 socket=/home/mysql/data3306/mysql.sock log-output=file slow_query_log=1 long_query_time=1 slow_query_log_file=/home/mysql/data3306/log/slow.log symbolic-links=0 log-error=/home/mysql/data3306/log/error.log log-bin=/home/mysql/data3306/log/bin.log pid-file=/home/mysql/data3306/mysql3306.pid binlog_format=mixed lower-case-table_names=1 log-bin-trust-function-creators=1 sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION character-set-server=utf8
my.cnf(3307.cnf)
[client] port= 3307 socket= /home/mysql/data3307/mysql.sock default-character-set=utf8 [mysqld] user=mysql port=3307 basedir=/usr/local/mysql datadir=/home/mysql/data3307/data server_id=3307 socket=/home/mysql/data3307/mysql.sock log-output=file slow_query_log=1 long_query_time=1 slow_query_log_file=/home/mysql/data3307/log/slow.log symbolic-links=0 log-error=/home/mysql/data3307/log/error.log log-bin=/home/mysql/data3307/log/bin.log pid-file=/home/mysql/data3307/mysql3307.pid binlog_format=mixed lower-case-table_names=1 log-bin-trust-function-creators=1 sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION character-set-server=utf8
my.cnf(3309.cnf)
[client] port= 3309 socket= /home/mysql/data3309/mysql.sock default-character-set=utf8 [mysqld] user=mysql port=3309 basedir=/usr/local/mysql datadir=/home/mysql/data3309/data server_id=3309 socket=/home/mysql/data3309/mysql.sock log-output=file slow_query_log=1 long_query_time=1 slow_query_log_file=/home/mysql/data3309/log/slow.log symbolic-links=0 log-error=/home/mysql/data3309/log/error.log log-bin=/home/mysql/data3309/log/bin.log pid-file=/home/mysql/data3309/mysql3309.pid binlog_format=mixed lower-case-table_names=1 log-bin-trust-function-creators=1 sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION character-set-server=utf8
步驟6-1:
創(chuàng)建文件夾/home/mysql/data330{6,7,9}/log并創(chuàng)建文件圖中4個(gè)文件
步驟7:
開(kāi)始賦權(quán)限
chown mysql:mysql -R /home/mysql/ chown mysql:mysql -R /usr/local/mysql
步驟8:
初始化數(shù)據(jù)庫(kù), 這里生成mysql.sock文件 :
/usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/data3306/my.cnf --initialize --basedir=/usr/local/mysql/ --datadir=/home/mysql/data3306/data /usr/local/mysql/bin/mysqld_safe --defaults-file=/home/mysql/data3306/my.cnf & /usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/data3307/my.cnf --initialize --basedir=/usr/local/mysql/ --datadir=/home/mysql/data3307/data /usr/local/mysql/bin/mysqld_safe --defaults-file=/home/mysql/data3307/my.cnf & /usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/data3309/my.cnf --initialize --basedir=/usr/local/mysql/ --datadir=/home/mysql/data3309/data /usr/local/mysql/bin/mysqld_safe --defaults-file=/home/mysql/data3309/my.cnf &
這里會(huì)生成默認(rèn)密碼,可以去error.log中看
//-----------------------------------------以上-數(shù)據(jù)庫(kù)初始化完畢----
步驟9:
命令行中運(yùn)行各個(gè)mysql實(shí)例:
/usr/local/mysql/bin/mysql -uroot -p -S /home/mysql/data3306/mysql.sock
輸入初始化密碼:
修改密碼:
SET PASSWORD = PASSWORD('123456'); ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; FLUSH PRIVILEGES;
設(shè)置navicat可連接:
use mysql #訪問(wèn)mysql庫(kù) update user set host = '%' where user = 'root'; #使root能再任何host訪問(wèn) FLUSH PRIVILEGES; #刷新
步驟10:
navicat連接數(shù)據(jù)庫(kù)
停止節(jié)點(diǎn):
查看進(jìn)程號(hào) :ps aux | grep mysql
以上是“l(fā)inux如何安裝mysql5.7的方法”這篇文章的所有內(nèi)容,感謝各位的閱讀!相信大家都有了一定的了解,希望分享的內(nèi)容對(duì)大家有所幫助,如果還想學(xué)習(xí)更多知識(shí),歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道!
標(biāo)題名稱:linux如何安裝mysql5.7的方法
當(dāng)前URL:http://bm7419.com/article48/jcedep.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供小程序開(kāi)發(fā)、虛擬主機(jī)、商城網(wǎng)站、網(wǎng)站排名、網(wǎng)站設(shè)計(jì)公司、做網(wǎng)站
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)