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

Installation environment

OS:RHEL 6.5_X64

Mysql:mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz

1. Confirm whether the dependency package has been installed

[root@dbrac16 ~] # yum info libaio | grep-A 1 Installed

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Installed Packages

Name: libaio

2. Create users and groups

[root@dbrac16 ~] # groupadd mysql

[root@dbrac16] # useradd-r-g mysql-s / bin/false mysql

3. Extract the installation package and modify permissions

[root@dbrac16 ~] # cd / usr/local/

[root@dbrac16 local] # tar-xvzf / root/mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz

[root@dbrac16 local] # mv mysql-5.7.16-linux-glibc2.5-x86_64/ mysql

[root@dbrac16 local] # cd mysql/

[root@dbrac16 mysql] # mkdir mysql-files data

[root@dbrac16 mysql] # chown-R mysql:mysql.

4. Modify the configuration file

[root@dbrac16 mysql] # vim / etc/my.cnf

[mysqld]

Datadir=/usr/local/mysql/data

Socket=/usr/local/mysql/mysql.sock

User=mysql

Symbolic-links=0

Character-set-server=utf8

Slow-query-log

Long_query_time=3

Log-output=TABLE

Expire_logs_days = 7

Event_scheduler=1

Innodb_file_per_table=1

Innodb_log_file_size=536870912

Innodb_buffer_pool_size=1073741824

Max_binlog_size=1073741824

Log_bin_trust_function_creators=1

Innodb_stats_on_metadata=0

Max_connect_errors = 1000000

Max_connections = 5000

Skip_name_resolve = 1

Explicit_defaults_for_timestamp=true

[mysqld_safe]

Log-error=/var/log/mysqld.log

Pid-file=/usr/local/mysql/my.pid

[client]

Socket=/usr/local/mysql/mysql.sock

[mysql]

Prompt= (\ u @\ h) [\ d]\ _

5. Initialize

[root@dbrac16 mysql] # bin/mysqld-initialize-user=mysql

100 200 300 400 500

100 200 300 400 500

2017-05-10T06:45:22.857917Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-05-10T06:45:22.979376Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-05-10T06:45:23.050120Z 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: 3de828ce-354c-11e7-9f0b-0050568a4cf6.

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

2017-05-10T06:45:23.055440Z 1 [Note] A temporary password is generated for root@localhost: iTunes JRv8dBoMagnedO

2017-05-10T06:45:24.359775Z 1 [Warning] 'user' entry' root@localhost' ignored in-- skip-name-resolve mode.

2017-05-10T06:45:24.359823Z 1 [Warning] 'user' entry' mysql.sys@localhost' ignored in-- skip-name-resolve mode.

2017-05-10T06:45:24.359844Z 1 [Warning] 'db' entry' sys mysql.sys@localhost' ignored in-- skip-name-resolve mode.

2017-05-10T06:45:24.359861Z 1 [Warning] 'proxies_priv' entry' @ root@localhost' ignored in-skip-name-resolve mode.

2017-05-10T06:45:24.360360Z 1 [Warning] 'tables_priv' entry' sys_config mysql.sys@localhost' ignored in-- skip-name-resolve mode.

[root@dbrac16 mysql] # bin/mysql_ssl_rsa_setup

Generating a 2048 bit RSA private key

. +

.. + +

Writing new private key to 'ca-key.pem'

-

Generating a 2048 bit RSA private key

. . +

.. + +

Writing new private key to 'server-key.pem'

-

Generating a 2048 bit RSA private key

. +

.. + +

Writing new private key to 'client-key.pem'

-

6. Configure the service

[root@dbrac16 mysql] # cp support-files/mysql.server / etc/init.d/mysqld

[root@dbrac16 mysql] # chkconfig-- add mysqld

[root@dbrac16 mysql] # chkconfig-- list mysqld

Mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

[root@dbrac16 mysql] # / etc/init.d/mysqld start

Starting MySQL. SUCCESS!

[root@dbrac16 mysql] # echo 'export PATH=/usr/local/mysql/bin:$PATH' > > / etc/profile

[root@dbrac16 mysql] # source / etc/profile

7. Change the password

[root@dbrac16 mysql] # mysql-u root-p

Enter password: iTunes JRv8dBojol do

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

Your MySQL connection id is 2

Server version: 5.7.16

Copyright (c) 2000, 2016, 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.

(root@localhost) [(none)] SET PASSWORD = PASSWORD ('123456')

Query OK, 0 rows affected, 1 warning (0.00 sec)

(root@localhost) [(none)] flush privileges

Query OK, 0 rows affected (0.00 sec)

(root@localhost) [(none)] use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with-A

Database changed

(root@localhost) [mysql] update user set host ='% 'where user =' root'

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

(root@localhost) [mysql] flush privileges

Query OK, 0 rows affected (0.00 sec)

[root@dbrac16 mysql] # / etc/init.d/mysqld restart

Shutting down MySQL.. SUCCESS!

Starting MySQL. SUCCESS!

8. Check the operation status

[root@dbrac16 mysql] # netstat-tunlp | grep 3306

Tcp 0 0: 3306: * LISTEN 28493/mysqld

[root@dbrac16 mysql] # ps-ef | grep mysql | grep-v grep

Root 28321 10 12:04 pts/0 00:00:00 / bin/sh / opt/data/mysql/bin/mysqld_safe-- datadir=/opt/data/mysql/data-- pid-file=/opt/data/mysql/data/dbrac16.pid

Mysql 28493 28321 0 12:04 pts/0 00:00:00 / opt/data/mysql/bin/mysqld-basedir=/opt/data/mysql-datadir=/opt/data/mysql/data-plugin-dir=/opt/data/mysql/lib/plugin-user=mysql-log-error=/var/log/mysqld.log-pid-file=/opt/data/mysql/data/dbrac16.pid-socket=/opt/data/mysql/mysql.sock

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.