檢索相關(guān)信息

yum search libaio

安裝依賴包

yum install libaio

(檢查 MySQL 是否已安裝 yum list installed | grep mysql
如果有，就先全部卸載，命令如下： yum -y remove mysql-libs.x86_64)

下載mysql的rpm安裝包

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
如果提示-bash: wget: 未找到命令，請先執(zhí)行 yum install wget 安裝 wget

添加 MySQL Yum Repository 到你的系統(tǒng) repository 列表中，執(zhí)行

yum localinstall mysql-community-release-el7-5.noarch.rpm

驗(yàn)證下是否添加成功

yum repolist enabled | grep "mysql.-community."

查看 MySQL 版本，執(zhí)行

yum repolist all | grep mysql

[可選擇] 修改mysql版本

vi /etc/yum.repos.d/mysql-community.repo

通過 Yum 來安裝 MySQL

yum install mysql-community-server

whereis mysql //查看安裝路徑

systemctl start mysqld //啟動(dòng)

第一種方法:

/var/log/mysqld.log 文件中查看初始密碼 A temporary password

然后登錄

mysql -uroot -p

修改密碼

mysql> set global validate_password_length=6;
mysql> set global validate_password_policy=0;
mysql> set password = password('Aa123456');
mysql> select host,user,authentication_string from mysql.user;
mysql> grant all privileges on . to 'root'@'%' identified by 'Aa123456' with grant option;
mysql> select host,user,authentication_string from mysql.user;
mysql> flush privileges;

然后阿里云控制臺 開啟3306端口權(quán)限 外部可以直接訪問

第二種方法:

vi /etc/my.cnf
在[mysqld]的段中加上一句：skip-grant-tables

重啟mysql

service mysqld restart

修改密碼

mysql> set global validate_password_length=6;
mysql> set global validate_password_policy=0;
mysql> set password = password('Aa123456');
mysql> select host,user,authentication_string from mysql.user;
mysql> grant all privileges on . to 'root'@'%' identified by 'Aa123456' with grant option;
mysql> flush privileges;