Shulou(Shulou.com)05/31 Report--

This article mainly explains "the installation steps of MYSQL5.7.17 version". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the installation steps of the MYSQL5.7.17 version.

MYSQL 5.7.17 installation:

Software acquisition:

Download mysql-advanced-5.7.17-linux-glibc2.5-x86_64.tar.gz on the official website

Unpack the installation:

Decompress mysql-advanced-5.7.17-linux-glibc2.5-x86_64.tar.gz

Tar-xvzf mysql-advanced-5.7.17-linux-glibc2.5-x86_64.tar.gz

Copy the extracted installation files to the installation directory (customizable)

[root@VMOS01 mysql] # cp-r mysql-advanced-5.7.17-linux-glibc2.5-x86_64 / usr/local/

[root@VMOS01 mysql] # cd / usr/local

[root@VMOS01 local] # mv mysql-advanced-5.7.17-linux-glibc2.5-x86_64 mysql-5.7.17

Establish a soft link:

[root@VMOS01 local] # ln-s mysql-5.7.17 mysql

[root@VMOS01 local] # ln-s / usr/local/mysql/bin/mysql / usr/bin/mysql

To add a MYSQL running user:

[root@VMOS01 local] # useradd-r-M-u 496s / sbin/nologin mysql

Empower the software and directory to the running user mysql:

[root@VMOS01 local] # chown-R mysql.mysql / usr/local/mysql-5.7.17/

[root@VMOS01 local] # chown-R mysql.mysql / usr/local/mysql

[root@VMOS01 local] # chgrp-R mysql / usr/local/mysql-5.7.17/

Initialize mysql db:

[root@VMOS01 local] # cd / usr/local/mysql

[root@VMOS01 bin] # cd..

[root@VMOS01 mysql] # / bin/mysql_install_db-- user=mysql-- basedir=/usr/local/mysql/-- datadir=/usr/local/mysql/data/

2017-04-09 22:38:11 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld-initialize

2017-04-09 22:38:20 [WARNING] The bootstrap log isn't empty:

2017-04-09 22:38:20 [WARNING] 2017-04-10T05:38:12.530858Z 0 [Warning]-- bootstrap is deprecated. Please consider using-initialize instead

New features of mysql5.7: as you can see above, mysql_install_db is no longer recommended. It is recommended to change it to mysqld-initialize to complete instance initialization.

[root@VMOS01 mysql] # / bin/mysqld-- defaults-file=/etc/my.cnf-- user=mysql-- basedir=/usr/local/mysql/-- datadir=/usr/local/mysql/data/-- initialize

2017-04-10T06:12:09.706181Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-explicit_defaults_for_timestamp server option (see documentation for more details).

2017-04-10T06:12:11.269373Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-04-10T06:12:11.496771Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-04-10T06:12:11.564642Z 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: a27f16b1-1db4-11e7-b5f3-000c2993673d.

2017-04-10T06:12:11.566539Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-04-10T06:12:12.196832Z 0 [Warning] CA certificate ca.pem is self signed.

2017-04-10T06:12:12.439938Z 1 [Note] A temporary password is generated for root@localhost: S8t6ikvw show databases

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Mysql > alter user root@localhost identified by "Root15 ()"

Mysql > show databases

+-+

| | Database |

+-+

| | information_schema |

| | mysql |

| | performance_schema |

| | sys |

+-+

At this point, mysql 5.7.17 installation is complete.

At this point, I believe that everyone on the "MYSQL5.7.17 version of the installation steps" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.