在CentOS 7下mysql 5.7.18 安裝配置方法圖文教程

這篇文章主要為大家詳細介紹了centos 7下mysql 5.7.18 安裝配置方法圖文教程,具有一定的參考價值,感興趣的小伙伴們可以參考一下

介紹如何在Linux下安裝mysql 5.7.18

1、下載MySQL:官網(wǎng)www.mysql.com/,點擊Downlosas,翻到網(wǎng)頁底部,下載社區(qū)版,一路點下去,選擇通用Linux,下載64位那個,注意檢查MD5
值。

在CentOS 7下mysql 5.7.18 安裝配置方法圖文教程

2、安裝關(guān)鍵步驟,直接貼出命令

[cpp]?view?plain?copy?在CODE上查看代碼片派生到我的代碼片  [root@CentOS?MySQL]#?tar?-xzvf?mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz?-C?/usr/local?  [root@CentOS?MySQL]#?cd?/usr/local?  [root@CentOS?local]#?mv?mysql-5.7.17-linux-glibc2.5-x86_64?mysql?  [root@CentOS?local]#?cd?mysql?  [root@CentOS?mysql]#?mkdir?data?  [root@CentOS?mysql]#?groupadd?mysql?  [root@CentOS?mysql]#?useradd?-r?-g?mysql?-s/bin/false?mysql?  [root@CentOS?mysql]#?chown?-R?mysql:mysql?./?  [root@CentOS?mysql]#?bin/mysqld?--initialize?--user=mysql?--basedir=/usr/local/mysql?--datadir=/usr/local/mysql/data?  2017-02-23T07:43:03.404885Z?0?[Warning]?TIMESTAMP?with?implicit?DEFAULT?value?is?deprecated.?Please?use?--explicit_defaults_for_timestamp?server?option?(see?documentation?for?more?details).?  2017-02-?  ?  23T07:43:04.442174Z?0?[Warning]?InnoDB:?New?log?files?created,?LSN=45790?  2017-02-23T07:43:04.588507Z?0?[Warning]?InnoDB:?Creating?foreign?key?constraint?system?tables.?  2017-02-23T07:43:04.646721Z?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:?b5c8e226-f99b-11e6-beb5-b7c1a1e39029.?  2017-02-23T07:43:04.671492Z?0?[Warning]?  ?  Gtid?table?is?not?ready?to?be?used.?Table?'mysql.gtid_executed'?cannot?be?opened.?  2017-02-23T07:43:04.672338Z?1?[Note]?A?temporary?password?is?generated?for?root@localhost:?I%e=s+lfx9ko?  [root@CentOS?mysql]#?  ?  bin/mysql_ssl_rsa_setup?--datadir=/usr/local/mysql/data?  Generating?a?2048?bit?RSA?private?key?  .....................................+++?  ..............................+++?  writing?new?private?key?to?'ca-key.pem'?  -----?  Generating?a?2048?bit?RSA?private?key?  .........................................+++?  .........................+++?  writing?new?private?key?to?'server-key.pem'?  -----?  Generating?a?2048?bit?RSA?private?key?  ..................................................+++?  ...................................................................................................................................................................................................+++?  writing?  ?  new?private?key?to?'client-key.pem'?  -----?  [root@CentOS?mysql]#?cd?support-files?  [root@CentOS?support-files]#?cp?my-default.cnf?/etc/my.cnf?  [root@CentOS?support-files]#?gedit?/etc/my.cnf?  [root@CentOS?support-files]#?cp?mysql.server?/etc/init.d/mysqld?  [root@CentOS?support-files]#?service?mysqld?start?  Starting?MySQL.Logging?to?'/usr/local/mysql/data/CentOS.cn.err'.?  .?SUCCESS!?  [root@CentOS?support-files]#?ps?aux?|grep?mysql?  root??18279?0.0?0.0?11764?1576?pts/0?S?17:34?0:00?/bin/sh?  ?  /usr/local/mysql/bin/mysqld_safe?--datadir=/usr/local/mysql/data?--pid-file=/usr/local/mysql/data/CentOS.cn.pid?  mysql??18449?1.9?9.5?1182688?177940?pts/0?Sl?17:34?0:00?/usr/local/mysql/bin/mysqld?--?  ?  basedir=/usr/local/mysql?--datadir=/usr/local/mysql/data?--plugin-dir=/usr/local/mysql/lib/plugin?--user=mysql?--log-error=/usr/local/mysql/data/CentOS.cn.err?--pid-file=/usr/local/mysql/data/CentOS.cn.pid?  ?  --socket=/tmp/mysql.sock?--port=3306?  ?  [root@CentOS?support-files]#

一行一行解釋:

把壓縮包解壓到/usr/local目錄下,就是把MySQL安裝在該目錄下。

切換到/usr/local,把剛才解壓后的文件夾重命名為mysql。

在mysql目錄下創(chuàng)建data文件夾,用來存儲MySQL的數(shù)據(jù)。

增加用戶組mysql。

增加用戶名mysql屬于mysql組。

修改mysql目錄的擁有者和組。

初始化MySQL,分兩步:

第一步,bin/mysqld? 注意后面給的參數(shù),之一部會產(chǎn)生一個臨時密碼,保存,后面登錄數(shù)據(jù)庫要用到;

第二步,bin/mysql_ssl_rsa_setup,看起來像是對數(shù)據(jù)庫安全的處理,注意后面給的參數(shù)。

切換到support-files目錄。

把my-default.cnf拷貝到 /etc/my.cnf,注意CentOS7自帶了一個my.cnf文件,覆蓋掉。

編輯該文件,只對18,19,20,22行修改,如下

把mysql.server文件拷貝到/etc/init.d/mysqld下,主要負責MySQL的開機啟動。

啟動mysqld進程。

查詢mysql進程。有兩個: /mysql/bin/mysqld_safe、/mysql/bin/mysqld

3、后續(xù)配置:

登錄mysql,修改臨時密碼:/usr/local/mysql/bin/mysql -u root -p 回車輸入初始化時生成的臨時密碼,修改密碼:

set password for? ‘root’@localhost=password(‘xxxxxx’);

每次登錄mysql客戶端嫌輸絕對路徑麻煩,就建一個軟連接:ln -s? /usr/local/mysql/bin/mysql? /usr/bin/mysql,這樣也省去了配PATH路徑的麻煩。

mysqld的開機啟動,使用chkconfig命令

chkconfig?--add?mysqld?#增加mysqld服務(wù)  chkconfig?--list????#列出所有的系統(tǒng)服務(wù)

看一下是不是在所有等級都是打開狀態(tài),例如:

chkconfig?--level?35?mysqld?on?  #設(shè)定mysqld在等級3和5為開機運行服務(wù)

? 版權(quán)聲明
THE END
喜歡就支持一下吧
點贊10 分享