In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.