0.创建mysql用户和组信息

[root@gxoradb1 ~]# groupadd mysql[root@gxoradb1 ~]# useradd -r -g mysql -s /bin/false mysql

1.指定安装目录

[root@gxoradb1 ~]# cd /usr/local[root@gxoradb1 local]# lsmysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz

2.解压mysql

[root@gxoradb1 local]# tar -zxvf mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz [root@gxoradb1 local]# mv mysql-advanced-5.7.15-linux-glibc2.5-x86_64/ mysql-5.7.15[root@gxoradb1 local]# ln -s mysql-5.7.15 mysql[root@gxoradb1 local]# ls -lalrwxrwxrwx 1 root root 12 Oct 4 14:58 mysql -> mysql-5.7.15drwxr-xr-x 9 root root4096 Oct 4 14:56 mysql-5.7.15

3.调整目录权限

[root@gxoradb1 local]# cd mysql[root@gxoradb1 mysql]# mkdir mysql-files[root@gxoradb1 mysql]# chmod 750 mysql-files[root@gxoradb1 mysql]# chown -R mysql:mysql .

The mysql-files directory provides a convenient location to use as the value of the secure_file_priv system variable that limits import/export operations to a specific directory.

4.初始化mysql

[root@gxoradb1 mysql]# bin/mysqld --initialize --user=mysql2016-10-04T07:07:05.044029Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-10-04T07:07:05.351321Z 0 [Warning] InnoDB: New log files created, LSN=457902016-10-04T07:07:05.396915Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2016-10-04T07:07:05.454329Z 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: 2825c52a-8a01-11e6-abb2-080027b5eb23.2016-10-04T07:07:05.456104Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2016-10-04T07:07:06.265334Z 0 [Warning] CA certificate ca.pem is self signed.2016-10-04T07:07:06.503976Z 1 [Note] A temporary password is generated for root@localhost: <5Tk+Gs7frb7 //临时口令[root@gxoradb1 mysql]# bin/mysql_ssl_rsa_setup

5.调整目录权限

[root@gxoradb1 mysql]# chown -R root .[root@gxoradb1 mysql]# chown -R mysql data mysql-files

6.启动mysql

[root@gxoradb1 mysql]# bin/mysqld_safe --user=mysql &[1] 11211[root@gxoradb1 mysql]# 2016-10-04T07:10:20.032700Z mysqld_safe Logging to '/usr/local/mysql/data/gxoradb1.err'.2016-10-04T07:10:20.058270Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

7.创建自启动脚本

[root@gxoradb1 mysql]# cp support-files/mysql.server /etc/init.d/mysql.server[root@gxoradb1 mysql]# chkconfig --add mysql.server[root@gxoradb1 mysql]# chkconfig --list mysql.server mysql.server0:off1:off2:on3:on4:on5:on6:off

8.登录mysql数据库

[root@gxoradb1 ~]# mysql -u root -h localhost -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.15-enterprise-commercial-advancedCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

9.修改root用户口令

mysql>ALTERUSER'root'@'localhost'IDENTIFIEDBY'oracle';

mysql>setpasswordfor'root'@'localhost'=password('oracle');

官方文档中对二进制安装的说明

shell>yuminstalllibaio//安装libaio包

shell>groupaddmysqlshell>useradd-r-gmysql-s/bin/falsemysqlshell>cd/usr/localshell>tarzxvf/path/to/mysql-VERSION-OS.tar.gzshell>ln-sfull-path-to-mysql-VERSION-OSmysqlshell>cdmysqlshell>mkdirmysql-filesshell>chmod750mysql-filesshell>chown-Rmysql.shell>chgrp-Rmysql.shell>bin/mysql_install_db--user=mysql#BeforeMySQL5.7.6shell>bin/mysqld--initialize--user=mysql#MySQL5.7.6andupshell>bin/mysql_ssl_rsa_setup#MySQL5.7.6andupshell>chown-Rroot.shell>chown-Rmysqldatamysql-filesshell>bin/mysqld_safe--user=mysql&#Nextcommandisoptionalshell>cpsupport-files/mysql.server/etc/init.d/mysql.server