Description<\/p>\n
This article uses MySQL-5.7.18. The operating system is 64-bit CentOS Linux release 7.2.1511 (Core), installed as a desktop.<\/p>\n
Uninstall MariaDB<\/p>\n
CentOS7 defaults to installing MariaDB instead of MySQL, and the yum server also removes the MySQL-related packages. Because MariaDB and MySQL may conflict, so first uninstall MariaDB.<\/p>\n
View the installed DebianDB related rpm package.<\/p>\n
rpm -qa | grep mariadb
\nView the installed MariaDB-related yum package, package name to be rpmjudged by the results of the order.<\/p>\n
yum list mariadb-libs
\nRemove the installed MariaDB-related yum package, the package name to yum listjudge the results according to the order. This step requires root privileges.<\/p>\n
yum remove mariadb-libs
\nDownload the MySQL rpm package<\/p>\n
As the software package is large, you can first use other ways (such as Thunder) to download. Using rpm, but also can not be installed under the conditions of the network – this is yum can not do. To install other versions of MySQL, please go to the official website to search the corresponding rpm download link.<\/p>\n
wget https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
\nUse the rpm package to install MySQL<\/p>\n
The following steps require root privileges. And because of the dependencies between the packages, the rpmcommands must be executed in sequence.<\/p>\n
mkdir mysql-5.7.18
\ntar -xv -f mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar -C mysql-5.7.18
\ncd mysql-5.7.18\/
\nrpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm
\nrpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm
\nrpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm
\nrpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm
\nAfter the installation is successful, you can also delete the installation files and temporary files.<\/p>\n
cd ..
\nrm -rf mysql-5.7.18
\nrm mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
\nModify the MySQL initial password<\/p>\n
The following steps require root privileges.<\/p>\n
Since the beginning does not know the password, first modify the configuration file \/etc\/my.cnfso that MySQL skip the login when the permissions check. Add a line<\/p>\n
skip-grant-tables
\nRestart MySQL.<\/p>\n
service mysqld restart
\nFree password to log in to MySQL.<\/p>\n
mysql
\nIn the mysql client to execute the following order, modify the root password.<\/p>\n
use mysql;
\nUPDATE user SET authentication_string = password(‘your-password’) WHERE host = ‘localhost’ AND user = ‘root’;
\nquit;
\nModify the configuration file to \/etc\/my.cnfdelete the previous line skip-grant-tablesand restart MySQL. This step is very important and failure to perform can lead to serious security problems.
\nLog in using the password you just set.<\/p>\n
mysql -u root -p
\nMySQL will force the need to re-modify the password, and can not be a simple rule password.<\/p>\n
ALTER USER root@localhost IDENTIFIED BY ‘your-new-password’;
\nSteps may be a little trouble, have not yet thought of other ways, first use this.<\/p>\n","protected":false},"excerpt":{"rendered":"
Description<\/p>\n
This article uses MySQL-5.7.18. The operating system is 64-bit CentOS Linux release 7.2.1511 (Core), installed as a desktop.<\/p>\n
Uninstall MariaDB<\/p>\n
CentOS7 defaults to installing MariaDB instead of MySQL, and the yum server also removes the MySQL-related packages. Because MariaDB and MySQL may conflict, so first uninstall MariaDB.<\/p>\n
View the installed DebianDB related rpm package.<\/p>\n
[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6740"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6740"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6740\/revisions"}],"predecessor-version":[{"id":6741,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6740\/revisions\/6741"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}