centos7.3下二进制安装mysql5.7.19记录

2017年10月18号，小雨，现在是9点38分。由于搭建liferay7.0不支持旧版本的数据库，所以今天要二进制安装mysql5.7了，不知道会出现什么样的问题。。。
首先看一下二进制安装包里面的文件

[chenshuai@cs mysql]$ lsbin  COPYING  docs  include  lib  man  README  share  support-files

现在过去了15分钟了，由于版本的变化，我发现我好像不会。好吧，我先去看下官方文档吧。好的，现在是14点38分，继续，我喜欢把创建的文件放到一个文件夹下，所以在mysql中新建了一个生产目录的 selfadd 目录，然后在里面用 vi 创建my.cnf 配置文件( 别看里面这么多东西，好多没用的！)：

[chenshuai@cs selfadd]$ vi my.cnf###################BASIC#################[mysqld]port      = 3306user      = mysqlsocket    = /home/chenshuai/mysql/selfadd/mysql.sockpid-file  = /home/chenshuai/mysql/selfadd/mysql.pidbasedir   = /home/chenshuai/mysqldatadir   = /home/chenshuai/mysql/selfadd/data#skip-name-resolve#skip-grant-tablesskip-external-lockingcharacter-set-server=utf8default-storage-engine = innodblower_case_table_names=1##################CONNECT#################max_connections = 2000max_connect_errors = 1000000interactive_timeout = 28800wait_timeout = 28800connect_timeout = 20back_log = 500#FOR FAST CREATE THREADthread_cache_size = 300open_files_limit = 10240table_open_cache = 3000###############THREAD BUFFER#############################FOR EVERY THREAD###########sort_buffer_size = 1Mjoin_buffer_size = 1Mread_buffer_size = 1Mread_rnd_buffer_size = 1M#net_buffer_length = 16ktmp_table_size = 64Mmax_allowed_packet = 128M#FOR MEMORY ENGINEmax_heap_table_size = 64M#################BUFFER#################################FOR ALL THREAD############query_cache_type = 0query_cache_size = 32Mquery_cache_limit = 1M#################LOG BUFFER#############binlog_cache_size = 16Mmax_binlog_cache_size = 32Mbinlog_stmt_cache_size = 32M#################LOG FILE###############sync_binlog = 0binlog_format = rowlog-error         = /home/chenshuai/mysql/selfadd/mysql-err.log#log-bin           = /home/chenshuai/mysql/selfadd/log/master-binmax_binlog_size = 512M#relay-log         = /home/chenshuai/mysql/selfadd/log/relay-binlog_output = fileslow_query_log = 1slow_query_log_file = /home/chenshuai/mysql/selfadd/log/slow_query.loglong_query_time=10general_log = 0general_log_file  = /home/chenshuai/mysql/selfadd/log/general_query_logexpire-logs-days = 3###############INNODB##################innodb_log_buffer_size = 8minnodb_max_dirty_pages_pct = 90innodb_thread_concurrency = 0innodb_flush_method = O_DIRECTinnodb_flush_log_at_trx_commit = 0innodb_lock_wait_timeout = 100innodb_fast_shutdown = 1innodb_read_io_threads = 8innodb_write_io_threads = 8innodb_io_capacity = 1000innodb_use_native_aio = 1innodb_stats_on_metadata = 0innodb_strict_mode = 1innodb_file_format = barracudainnodb_file_format_max = barracudainnodb_file_format_check = 1###############MYISAM###################key_buffer_size = 64Mkey_cache_block_size = 64kmyisam_sort_buffer_size = 64M#################REPLICATE###############server_id =1log_slave_updates=1#######GTID#######sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysqld_safe]err-log  = /home/chenshuai/mysql/selfadd/log/mysqld_safe.logpid-file = /home/chenshuai/mysql/selfadd/data/mysql.pid[mysql]no-auto_rehashdefault_character-set = gbk[client]port = 3306socket = /home/chenshuai/mysql/selfadd/mysql.sock"my.cnf" [New] 119L, 3513C written                            [chenshuai@cs selfadd]$ lsmy.cnf

可以看到已经创建好了 my.cnf 了。然后回到 mysql 目录下初始化数据库：

[chenshuai@cs mysql]$ bin/mysqld --initialize --user=chenshuai --basedir=/home/chenshuai/mysql  --datadir=/home/chenshuai/mysql/selfadd/data --pid-file=/home/chenshuai/mysql/selfadd/data/mysql.pidbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

出现这个错误是因为缺少依赖包，我们需要安装一下：

[chenshuai@cs mysql]$ sudo yum install -y libaio[sudo] password for chenshuai: Loaded plugins: fastestmirrorbase                                                     | 3.6 kB     00:00     epel                                                     | 4.3 kB     00:00     extras                                                   | 3.4 kB     00:00     updates                                                  | 3.4 kB     00:00     (1/7): base/7/x86_64/group_gz                              | 156 kB   00:00     (2/7): epel/x86_64/group_gz                                | 170 kB   00:00     (3/7): extras/7/x86_64/primary_db                          | 110 kB   00:00     (4/7): epel/x86_64/updateinfo                              | 841 kB   00:00     (5/7): base/7/x86_64/primary_db                            | 5.7 MB   00:01     (6/7): updates/7/x86_64/primary_db                         | 2.9 MB   00:01     (7/7): epel/x86_64/primary_db                              | 4.8 MB   00:01     Determining fastest mirrorsResolving Dependencies--> Running transaction check---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved================================================================================ Package         Arch            Version                    Repository     Size================================================================================Installing: libaio          x86_64          0.3.109-13.el7             base           24 kTransaction Summary================================================================================Install  1 PackageTotal download size: 24 kInstalled size: 38 kDownloading packages:libaio-0.3.109-13.el7.x86_64.rpm                           |  24 kB   00:00     Running transaction checkRunning transaction testTransaction test succeededRunning transaction  Installing : libaio-0.3.109-13.el7.x86_64                                 1/1   Verifying  : libaio-0.3.109-13.el7.x86_64                                 1/1 Installed:  libaio.x86_64 0:0.3.109-13.el7                                                Complete!

然后再执行以下：

[chenshuai@cs mysql]$ bin/mysqld --initialize --user=chenshuai --basedir=/home/chenshuai/mysql  --datadir=/home/chenshuai/mysql/selfadd/data --pid-file=/home/chenshuai/mysql/selfadd/data/mysql.pid2017-10-18T06:36:24.416816Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2017-10-18T06:36:26.467320Z 0 [Warning] InnoDB: New log files created, LSN=457902017-10-18T06:36:26.687113Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2017-10-18T06:36:26.810394Z 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: aaca389e-b3ce-11e7-bb9f-00163e0a4495.2017-10-18T06:36:26.812383Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2017-10-18T06:36:26.813434Z 1 [Note] A temporary password is generated for root@localhost: jRy2njkM-uo5

咦呵！还给我警告，不过最后也出来数据库密码了，先记下了，以后再慢慢研究。然后我就启动一下子：

[chenshuai@cs mysql]$ ./bin/mysqld --defaults-file=./selfadd/my.cnf &[1] 20705[chenshuai@cs mysql]$ ps -ef |grep mysqlchenshu+ 20705 20262  1 15:28 pts/0    00:00:00 ./bin/mysqld --defaults-file=./selfadd/my.cnfchenshu+ 20743 20262  0 15:29 pts/0    00:00:00 grep --color=auto mysql

嗯！看样子是启动了，用刚才的随机密码进入一下试试：

[chenshuai@cs mysql]$ ./bin/mysql --defaults-file=./selfadd/my.cnf -u root -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.7.19-logCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> 

还不错，进来了，那我们就修改密码吧！

mysql> alter user 'root'@'localhost' identified by '666666';Query OK, 0 rows affected (0.00 sec)mysql> quitBye

这里我将密码修改为666666，然后退出。现在是15点40分，发表！