Centos6, 7 how to upgrade mysql to mysql5.7 online
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.
