Environment: Virtual Machine + CentOS 7<\/p>\n
1. download binary package, the following mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz link is the official website<\/p>\n
cd \/usr\/local\/src<\/p>\n
wget https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.7\/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
\n2. extract, rename<\/p>\n
[root@beta src]# tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz<\/p>\n
[root@beta src]# ls
\nindex.html?id=471614 mysql-5.7.19-linux-glibc2.12-x86_64 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
\n[root@beta src]# mv mysql-5.7.19-linux-glibc2.12-x86_64 \/usr\/local\/mysql
\n3. Initialize<\/p>\n
[root@beta mysql]# useradd -M -s \/sbin\/nologin mysql<\/p>\n
[root@beta mysql]# ls
\nbin COPYING docs include lib man README share support-files
\n[root@beta mysql]# mkdir -p \/usr\/local\/mysql\/data\/mysql
\n[root@beta mysql]# chown mysql \/usr\/local\/mysql\/data\/mysql
\nThe following step attention to the last sentence:<\/p>\n
[root@beta mysql]# .\/bin\/mysqld –initialize –user=mysql –datadir=\/usr\/local\/mysql\/data\/mysql
\n2017-09-27T03:44:47.999985Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
\n2017-09-27T03:44:49.011240Z 0 [Warning] InnoDB: New log files created, LSN=45790
\n2017-09-27T03:44:49.180334Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
\n2017-09-27T03:44:49.245777Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 3649ce8c-a336-11e7-a43f-000c292b2832.
\n2017-09-27T03:44:49.266053Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
\n2017-09-27T03:44:49.268172Z 1 [Note] A temporary password is generated for root@localhost: ADB&yGx-d8ab<\/p>\n
ADB&yGx-d8ab
\nThen execute:<\/p>\n
[root@beta mysql]# .\/bin\/mysql_ssl_rsa_setup –datadir=usr\/local\/mysql\/data\/mysql
\nGenerating a 2048 bit RSA private key
\n………………….+++
\n…+++
\nwriting new private key to ‘ca-key.pem’
\n—–
\nGenerating a 2048 bit RSA private key
\n…………………….+++
\n…………………………………………………………………….+++
\nwriting new private key to ‘server-key.pem’
\n—–
\nGenerating a 2048 bit RSA private key
\n………………..+++
\n…………………..+++
\nwriting new private key to ‘client-key.pem’
\n4. Copy the configuration file and startup script<\/p>\n
First check whether there is \/etc\/my.cnf, if not<\/p>\n
cp support-files\/my-default.cnf \/etc\/my.cnf
\nEdit \/etc\/my.cnf, focus on the following changes, the other as far as possible comment out:<\/p>\n
basedir = \/usr\/local\/mysql
\ndatadir = \/\/usr\/local\/mysql\/data\/mysql
\nsocket = \/tmp\/mysql.sock
\n2. Start the script<\/p>\n
cp support-files\/mysql.server \/etc\/init.d\/mysqld
\nEdit \/etc\/init.d\/mysqld, only modify the following:<\/p>\n
basedir=\/usr\/local\/mysql
\ndatadir=\/data\/mysql
\nAdd \/etc\/init.d\/mysqld to the startup item:<\/p>\n
[root@beta mysql]# chkconfig –add mysqld
\n[root@beta mysql]# chkconfig –list<\/p>\n
systemd ‘systemctl list-unit-files’?
\ntarget
\nsystemctl list-dependencies [target]?<\/p>\n
5. Start the service<\/p>\n
\/etc\/init.d\/mysqld start
\n6. Set the root password<\/p>\n
Log in with the initial password (see step 3 above)<\/p>\n
\/usr\/local\/mysql\/bin\/mysql -uroot -p\u2018\u2019 #-p?\u2019\u2019
\nAppears mysql>, enter set password = password (‘new password’);<\/p>\n
Exit, login with new password<\/p>\n
2. Forget the initial password<\/p>\n
To \/etc\/my.cnf\/[mysqld] Add a line below skip-grant-tables, restart mysqld: \/etc\/init.d\/mysqld restart<\/p>\n
[mysqld]
\nskip-grant-tables
\nbasedir=\/usr\/local\/mysql
\ndatadir=\/usr\/local\/mysql\/data\/mysql
\nsocket=\/tmp\/mysql.sock<\/p>\n
[root@beta ~]# \/etc\/init.d\/mysqld restart
\nShutting down MySQL.. SUCCESS!
\nStarting MySQL.. SUCCESS!
\nRe-login mysql:<\/p>\n
[root@beta ~]# \/usr\/local\/mysql\/bin\/mysql -uroot
\nmysql> enter: update mysql.user set authentication_string = password (‘123333’) where user = ‘root’;<\/p>\n
mysql> update mysql.user set authentication_string=password(‘123333′) where user=’root’;
\nQuery OK, 1 row affected, 1 warning (0.00 sec)
\nRows matched: 1 Changed: 1 Warnings: 1
\nQuit, delete my.cnf added skip-grant-tables, restart mysqld<\/p>\n
New password re-login mysql:<\/p>\n
[root@beta ~]# \/usr\/local\/mysql\/bin\/mysql -uroot -p’123333′
\nmysql: [Warning] Using a password on the command line interface can be insecure.
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 13
\nServer version: 5.7.19 MySQL Community Server (GPL)<\/p>\n
Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql><\/p>\n","protected":false},"excerpt":{"rendered":"
Environment: Virtual Machine + CentOS 7<\/p>\n
1. download binary package, the following mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz link is the official website<\/p>\n
cd \/usr\/local\/src<\/p>\n
wget https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.7\/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz 2. extract, rename<\/p>\n
[root@beta src]# tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz<\/p>\n
[root@beta src]# ls index.html?id=471614 mysql-5.7.19-linux-glibc2.12-x86_64 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz [root@beta src]# mv mysql-5.7.19-linux-glibc2.12-x86_64 \/usr\/local\/mysql 3. Initialize<\/p>\n
[root@beta mysql]# useradd -M -s \/sbin\/nologin mysql<\/p>\n
[root@beta mysql]# ls bin COPYING […]<\/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\/7303"}],"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=7303"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7303\/revisions"}],"predecessor-version":[{"id":7304,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7303\/revisions\/7304"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}