1.配置yum源
# 下載mysql源安裝包shell> wgethttp://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm# 安裝mysql源shell> yum localinstall mysql57-community-release-el7-8.noarch.rpm
檢查mysql源是否安裝成功
shell> yum repolist enabled| grep "mysql.*-community.*"
2.安裝mysql
shell>yum install mysql-community-server
3褐奴、啟動(dòng)MySQL服務(wù)
shell> systemctl start mysqld
1
查看MySQL的啟動(dòng)狀態(tài)
shell> systemctl status mysqld● mysqld.service- MySQL Server? Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)Active: active (running) since 五2016-06-2404:37:37CST; 35min agoMain PID:2888(mysqld)? CGroup: /system.slice/mysqld.service└─2888/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid6月2404:37:36localhost.localdomainsystemd[1]: Starting MySQL Server...6月2404:37:37localhost.localdomainsystemd[1]: Started MySQL Server.
4、開(kāi)機(jī)啟動(dòng)
shell> systemctl enable mysqldshell> systemctl daemon-reload
5、修改root默認(rèn)密碼
mysql安裝完成之后捡絮,在/var/log/mysqld.log文件中給root生成了一個(gè)默認(rèn)密碼麦撵。?
查看默認(rèn)密碼
shell> grep'temporary password'/var/log/mysqld.log
用默認(rèn)密碼登錄
shell>mysql-uroot-pmysql>Enter password: Q2>r4=l-DWIP
6.允許root遠(yuǎn)程登錄
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123@asdf' WITH GRANT OPTION;
mysql> flush privileges;
第一句中”%”表示任何主機(jī)都可以遠(yuǎn)程登錄到該服務(wù)器上訪問(wèn)撑刺。如果要限制只有某臺(tái)機(jī)器可以訪問(wèn)囤采,將其換成相應(yīng)的IP即可需曾,如:
GRANT ALL PRIVILEGES ON . TO root@”172.168.193.25” IDENTIFIED BY “123@asdf”;
123@asdf是登錄密碼慧起。
第二句表示從mysql數(shù)據(jù)庫(kù)的grant表中重新加載權(quán)限數(shù)據(jù)菇晃。因?yàn)镸ySQL把權(quán)限都放在了cache中,所以在做完更改后需要重新加載蚓挤。
注意
1.具體生產(chǎn)環(huán)境根據(jù)自己的配置需要再進(jìn)行配置磺送。
2.阿里云云服務(wù)器如果MySQL配置了遠(yuǎn)程訪問(wèn)還是無(wú)法訪問(wèn),可能是阿里云默認(rèn)是不開(kāi)放3306端口的灿意」啦樱可以去阿里云的控制臺(tái)修改網(wǎng)絡(luò)配置。
7.修改字符集編碼 UTF-8
查看當(dāng)前的字符編碼
showvariableslike'char%'
1
檢測(cè)是否都是utf-8(filesystem除外)缤剧,如果不是就得改馅袁,例如這個(gè)character_set_server一般是拉丁編碼?
修改編碼
//停數(shù)據(jù)庫(kù)systemctl stop mysqld//進(jìn)入 my.cnf 文件,一般是在etc路徑下vim /etc/my.cnf//加入要修改的字符集 修改完:wq退出在[mysqld]下追加:character-set-server=utf8在[mysql]下追加:default-character-set=utf8//重啟數(shù)據(jù)庫(kù)systemctl start mysqld
1
2
3
4
5
6
7
8
9
10
11
12
13
當(dāng)你在安裝CentOS6.8上安裝Mysql5.7的時(shí)候荒辕,它可能會(huì)提示你需要更高glibc的相關(guān)庫(kù)汗销,如下提示
libc.so.6:version `GLIBC_2.14' not found-->Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-server-5.7.18-1.el7.x86_64-->Finished Dependency ResolutionError: Package: mysql-community-client-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)Error: Package: mysql-community-server-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: libc.so.6(GLIBC_2.17)(64bit)Error: Package: mysql-community-client-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: libc.so.6(GLIBC_2.14)(64bit)Error: Package: mysql-community-libs-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: libc.so.6(GLIBC_2.14)(64bit)Error: Package: mysql-community-server-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)Error: Package: mysql-community-server-5.7.18-1.el7.x86_64 (mysql57-community)? ? ? ? ? Requires: systemd You could try using--skip-brokentowork around the problem
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
這種提示的原因是你的glibc的庫(kù)的版本太低。glibc是linux系統(tǒng)中最底層的api抵窒,隨便更改底層庫(kù)可能會(huì)造成系統(tǒng)的不穩(wěn)定弛针。是跟系統(tǒng)內(nèi)核密切相關(guān)的東西,你與其去更新這個(gè)底層庫(kù)李皇,還不如去跟新Linux的版本削茁。?
所以我的建議是提升系統(tǒng)版本到CentOS7,再裝MySQL(安裝過(guò)程順暢無(wú)比)。?
當(dāng)然如果有興趣的同學(xué)可以去嘗試一下更新茧跋,附上glibc的下載地址 :?傳送門(mén)