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