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

Centos6.9 installs Myql database RPM package 1, enter the / usr/src directory

[root@ljctest nginx-1.12.1] # cd / usr/src/

[root@ljctest src] # ls

Debug kernels nginx-1.12.1 nginx-1.12.1.tar.gz

2. Download the rpm package of Myql5.7.19

[root@ljctest****src] # wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar

-- 2017-10-12 11 Fran 16RV 50-https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar

Resolving cdn.mysql.com... 104.95.206.140

Connecting to cdn.mysql.com | 104.95.206.140 |: 443... Connected.

HTTP request sent, awaiting response... 200 OK

Length: 472432640 (451m) [application/x-tar]

Saving to: "mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar"

100% [=

2017-10-12 11:20:48 (1.90 MB/s)-"mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar" saved [472432640plus 47

3. Check the file!

[root@ljctest src] # file mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar

Mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar: POSIX tar archive (GNU)

4. Create a directory for mysql-5.7

[root@ljctest src] # mkdir mysql-5.7

5. Extract the RPM package to the mysql-5.7 folder

[root@ljctest src] # tar-xf mysql-5.7.19-1.el6.x86_64.rpm-bundle.tar-C mysql-5.7/

6. * check whether MySQL is installed on the operating system

[root@mydb1 backup] # rpm-qa | grep mysql

Qt-mysql-4.6.2-26.el6_4.x86_64

Mysql-5.1.71-1.el6.x86_64

Mysql-server-5.1.71-1.el6.x86_64

Mysql-devel-5.1.71-1.el6.x86_64

Mysql-libs-5.1.71-1.el6.x86_64

Delete MyQL (the mysql-libs that comes with the RedHat6.3 server is mysql-libs-5.1.61-4.el6.x86_64, which may conflict with the higher version of mysql-libs)

Yum remove mysql-libs

7, separate installation error (generally rely on the installation of the problem)!

[root@ljctest mysql-5.7] # rpm-ivh mysql-community-server-5.7.19-1.el6.x86_64.rpm

Warning: mysql-community-server-5.7.19-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Error: Failed dependencies:

Libnuma.so.1 () (64bit) is needed by mysql-community-server-5.7.19-1.el6.x86_64

Libnuma.so.1 (libnuma_1.1) (64bit) is needed by mysql-community-server-5.7.19-1.el6.x86_64

Libnuma.so.1 (libnuma_1.2) (64bit) is needed by mysql-community-server-5.7.19-1.el6.x86_64

Mysql-community-client (x86-64) > = 5.7.9 is needed by mysql-community-server-5.7.19-1.el6.x86_64

Mysql-community-common (x86-64) = 5.7.19-1.el6 is needed by mysql-community-server-5.7.19-1.el6.x86_64

[root@ljctest mysql-5.7] # ll

Total 461372

-rw-r--r-- 1 7155 31415 23618024 Jun 24 20:08 mysql-community-client-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 336268 Jun 24 20:08 mysql-community-common-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 3747580 Jun 24 20:08 mysql-community-devel-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 39248236 Jun 24 20:08 mysql-community-embedded-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 136599912 Jun 24 20:08 mysql-community-embedded-devel-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 2177644 Jun 24 20:09 mysql-community-libs-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 1723316 Jun 24 20:09 mysql-community-libs-compat-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 159680896 Jun 24 20:09 mysql-community-server-5.7.19-1.el6.x86_64.rpm

-rw-r--r-- 1 7155 31415 105292128 Jun 24 20:09 mysql-community-test-5.7.19-1.el6.x86_64.rpm

8. If there is a network, use the following installation method to install it successfully.

[root@ljctest mysql-5.7] # yum install. / * .rpm

9. Start mysql

[root@ljctest mysql-5.7] # service mysqld start

Initializing MySQL database: [OK]

Starting mysqld: [OK]

[root@ljctest mysql-5.7] #

[root@ljctest mysql-5.7] # grep 'temporary password' / var/log/mysqld.log

2017-10-12T07:20:33.419494Z 1 [Note] A temporary password is generated for root@localhost:? OJo0_Wrpv70

[root@ljctest mysql-5.7] #

10. Enter mysql and change the password of mysql.

[root@ljctest mysql-5.7] # mysql- uroot-p

Enter password:

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 5

Server version: 5.7.19

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql >

ALTER USER 'root'@'localhost' IDENTIFIED BY' New password

Above, MySQL 5.7.10 installation is complete.

After that, you can also release the firewall, set self-startup, enhance MySQL security settings, and so on.

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

/ etc/init.d/iptables save

Chkconfig mysqld on

Mysql_secure_installation

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.