Linux installed mysql5.7 binaries

Practice environment:

centos 6.9

mysql mysql-5.7.20-linux-glibc2.12-x86_64

References: https: //dev.mysql.com/doc/refman/5.7/en/binary-installation.html

Needed to install the required software

yum install

> Yum search libaio # search for info

> Yum install libaio # install library

apt installation

> Apt-cache search libaio # search for info

> Apt-get install libaio1 # install library

1, you need to extract the installation directory is generally / use / local / mysql, links need to be addressed quickly socket when not on their own directory, refer to: http: //binary-space.iteye.com/blog/2203617

2, cd to extract the directory

3. Create mysql user group

> Groupadd mysql

> Useradd -r -g mysql -s / bin / false mysql

4, set permissions as needed

5, the installation

> Bin / mysqld –initialize –user = mysql

Tips

2018-01-04T06: 48: 24.652569Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated Please use –explicit_defaults_for_timestamp server option (see documentation for more details)..

2018-01-04T06: 48: 24.881794Z 0 [Warning] InnoDB: New log files created, LSN = 45790

2018-01-04T06: 48: 25.097948Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2018-01-04T06: 48: 25.357248Z 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:. 434c44cb-f11b-11e7-b768- 005056a5b865.

2018-01-04T06: 48: 25.357880Z 0 [Warning] Gtid table is not ready to be used Table ‘mysql.gtid_executed’ can not be opened..

2018-01-04T06: 48: 25.358546Z 1 [Note] A temporary password is generated root @ localhost for: QRdOjg, Y

QRdOjg, Y

The following command can also be used to obtain initial password:

> Grep ‘temporary password’ /var/log/mysqld.log

6, start

./support-files/mysql.server start

7. Log

> ./ bin / mysql -u [user name] [-p password]

8, for the first time login password reset

> Alter user ‘root’ @ ‘localhost’ identified by ‘i-Sprint2011’;

9, remote connectivity needs may need to turn off the firewall

Add the port needs to listen

> / sbin / iptables -i [is i, you need to delete this bracket] INPUT -P TCP – Dport 3306 -J ACCEPT Save Setup

> /etc/init.d/iptables save

View status

> /etc/init.d/iptables status

Note: Connection login mysql If an error, please refer to Blog post:

Http://binary-space.iteye.com/blog/2412768

———————————————————————

If there is any other condensation or in the article, please point out in time,

I am better corrected in time, and we will make us progress together.

Email: [email protected]

QQ: 1035862795

Knocking on the door: Code writes life

Related Posts