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

0. Create mysql user and group information [root@gxoradb1 ~] # groupadd mysql [root@gxoradb1 ~] # useradd-r-g mysql-s / bin/false mysql

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

two。 Extract 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 root 4096 Oct 4 14:56 mysql-5.7.15

3. Adjust directory permissions [root@gxoradb1 local] # cd mysql [root@gxoradb1 mysql] # mkdir mysql-files [root@gxoradb1 mysql] # chmod 750mysql-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. Initialize 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: ALTER USER' root'@'localhost' IDENTIFIED BY 'oracle';mysql > set password for' root'@'localhost'=password ('oracle')

Instructions for binary installation shell > yum install libaio / / install libaio package shell > groupadd mysqlshell > useradd-r-g mysql- s / bin/false mysqlshell > cd / usr/localshell > tar zxvf / path/to/mysql-VERSION-OS.tar.gzshell > ln-s full-path-to-mysql-VERSION-OS mysqlshell > cd mysqlshell > mkdir mysql-filesshell > chmod 750mysql-filesshell > chown-R mysql .shell > chgrp-R mysql .shell > bin/mysql_install_db-user=mysql # Before MySQL 5.7.6shell > bin / mysqld-- initialize-- user=mysql # MySQL 5.7.6 and upshell > bin/mysql_ssl_rsa_setup # MySQL 5.7.6 and upshell > chown-R root .shell > chown-R mysql data mysql-filesshell > bin/mysqld_safe-- user=mysql & # Next command is optionalshell > cp support-files/mysql.server / etc/init.d/mysql.serverDirectoryContents of Directorybin Scriptsmysqld server, client and utility programsdataLog files, databasesdocsMySQL manual in Info formatmanUnix manual pagesincludeInclude (header) fileslibLibrariesshareMiscellaneous support files, including error messages, sample configuration files, SQL for database installation

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.