CentOS 7 版本將MySQL數(shù)據(jù)庫軟件從默認的程序列表中移除，那么CentOS 7版本如何安裝MySQL呢，本文將指導大家具體的方法。

首先切換賬戶權限到root權限，登錄CentOS 7 系統(tǒng)的云主機后輸入：[dc2-user@didiyun?dc2-user]#?sudo?su

切換成root權限，然后執(zhí)行下面的安裝方法：

官網(wǎng)安裝mysql-server方法：[root@didiyun?dc2-user]#?yum?install?-y?wget[root@didiyun?dc2-user]#?wget?http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm[root@didiyun?dc2-user]#?rpm?-ivh?mysql57-community-release-el7-8.noarch.rpm[root@didiyun?dc2-user]#?yum?install?mysql-community-server?-y

啟動mysql[root@didiyun?dc2-user]#?systemctl?start?mysqld

驗證是否啟動[root@didiyun?dc2-user]#?systemctl?status?mysqld

mysql安裝完成之后，在/var/log/mysqld.log文件中給root生成了一個默認密碼。通過下面的方式找到root默認密碼，然后登錄mysql進行修改：[root@didiyun?dc2-user]#?grep?'temporary?password'?/var/log/mysqld.log

2018-05-23T09:24:03.800263Z?1?[Note]?A?temporary?password?is?generated?for?root@localhost:?p?iT>b?iv7st

可以看到初始密碼為 p?iT>b?iv7st，登錄數(shù)據(jù)庫：[root@didiyun?dc2-user]#?mysql?-uroot?-p

Enter?password:

Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g.Your?MySQL?connection?id?is?2Server?version:?5.7.22Copyright?(c)?2000,?2018,?Oracle?and/or?its?affiliates.?All?rights?reserved.Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?itsaffiliates.?Other?names?may?be?trademarks?of?their?respectiveowners.Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement.

mysql>

重新設置root密碼mysql>?set?password?for?'root'@'localhost'=password('Mypass12@');

為數(shù)據(jù)庫設置遠程連接

首先在防火墻規(guī)則中打開3306端口

設置mysqlmysql>?grant?all?privileges?on?*.*?to?root@'%'identified?by?'123456';

如果是非root用戶(mysql的root用戶)遠程登錄，則要先創(chuàng)建用戶mysql>create?user?'username'@'%'?identified?by?'password';

然后再進行連接[root@didiyun?dc2-user]#mysql?-h??-uusername?-p

Enter?password:?******

Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g.

Your?MySQL?connection?id?is?11

Server?version:?5.6.39?MySQL?Community?Server?(GPL)

Copyright?(c)?2000,?2017,?Oracle?and/or?its?affiliates.?All?rights?reserved.

Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its

affiliates.?Other?names?may?be?trademarks?of?their?respective

owners.

Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement.

mysql>

總結

以上是生活随笔為你收集整理的mysql重装远程服务未_CentOS 7系统安装与远程连接MySQL(5.7)的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。