Shulou(Shulou.com)06/01 Report--

This article is mainly about centos6, 7 how to upgrade mysql to mysql5.7 online, if you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading centos6 and 7 how to upgrade mysql to mysql5.7 online.

Centos7 upgrades mysql online:

① downloads mysql feeds

Wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

② install mysql5.7 source

Yum localinstall-y mysql57-community-release-el7-7.noarch.rpm

③ installs database cloud server

Yum install-y mysql-community-server

④ starts the database service

Systemctl start mysqld.service

⑤ Firewall Policy

Iptables-I INPUT-p tcp-m state-- state NEW-m tcp-- dport 3306-j ACCEPT

⑥ View temporary password

Grep 'temporary password' / var/log/mysqld.log

⑦ executes the security script and changes the password

Mysql_secure_installation

Note: when the script is executed for the first time, the password entered is viewed by the ⑤ step

⑧ refresh permission allows other hosts to connect to the database

GRANT ALL PRIVILEGES ON. TO 'root'@'%' IDENTIFIED BY' password' WITH GRANT OPTION

Flush privileges

Centos6.X upgrades mysql online

① downloads mysql feeds

Wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

② install mysql5.7 source

Yum localinstall-y mysql57-community-release-el6-7.noarch.rpm

③ installs database cloud server

Yum install-y mysql-community-server

④ starts the database service

Service mysqld start

⑤ View temporary password

Grep 'temporary password' / var/log/mysqld.log

⑥ executes the security script and changes the password

Mysql_secure_installation

Note: when the script is executed for the first time, the password entered is viewed by the ⑤ step

⑦ refresh permission allows other hosts to connect to the database

GRANT ALL PRIVILEGES ON. TO 'root'@'%' IDENTIFIED BY' password' WITH GRANT OPTION

Flush privileges

⑧ Firewall Policy

Iptables-I INPUT-p tcp-m state-- state NEW-m tcp-- dport 3306-j ACCEPT

The above details about centos6, 7 how to upgrade mysql to mysql5.7 online, are they helpful to you? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.