CentOS7默認數(shù)據(jù)庫是mariadb, 但是 好多用的都是mysql ，但是CentOS7的yum源中默認好像是沒有mysql的。
上一篇安裝的是5.6的但是我想安裝5.7的 yum安裝是最簡單的 嘗試過編譯安裝各種問題，最后就決定用yum。
(經(jīng)過一段時間的學習又寫了一篇用源碼安裝mysql5.7.22的 點擊打開鏈接)
1.卸載 先停掉mysql進程 沒有安裝過的可以直接跳過
| pkill -9 mysqld rpm -qa|grep -i mysql |
用命令 yum -y remove
| yum -y remove mysql-community-client-5.6.38-2.el7.x86_64 |
卸載不掉的用 rpm -ev
依次卸載 直到?jīng)]有
2.下載mysql的repo源 這個安裝的mysql5.7.20 /**糾正一下，這源下載的是最新的版本 ****/
| [root@localhost ~]# cd /usr/local/src/ [root@localhost src]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm [root@localhost src]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm [root@localhost src]# yum -y install mysql-server |
（也可以指定安裝目錄 yum --installroot=/usr/local/mysql --releasever=/ -y install mysql-server ）我沒試，這樣裝環(huán)境變量配置都不用你管，裝上直接啟動就行。安裝路徑是默認的。
一路 y
根據(jù)步驟安裝就可以了，
默認配置文件路徑：
配置文件：/etc/my.cnf
日志文件：/var/log/var/log/mysqld.log
服務啟動腳本：/usr/lib/systemd/system/mysqld.service
socket文件：/var/run/mysqld/mysqld.pid
配置 my.cnf vim /etc/my.cnf
| [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock server_id = 1 expire_logs_days = 3 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid |
不過安裝完成后，密碼為隨機密碼，需要重置密碼。
4. 啟動mysql服務
新聞熱點
疑難解答
圖片精選
