初学mysql：mysql5.7 glibc+centos7.1安装（一）

1、部署环境

        操作系统：CentOS Linux release 7.2.1511 (Core)

        mysql版本：mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

 

2、安装步骤

          1） 创建Myql用户组合用户以及数据库存放目录

[root@localhost ~]# groupadd mysql

[root@localhost ~]# useradd -g mysql mysql

[root@localhost ~]# mkdir -p /usr/local/mysql/data  --创建Mysql目录以及数据文件存放路径

[root@localhost ~]# mkdir -p /usr/local/mysql/logs   --日志存放路径

          2）安装Mysql

[root@localhost ~]# tar -xvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

[root@localhost ~]# cd mysql-5.7.18-linux-glibc2.5-x86_64/

[root@localhost mysql-5.7.18-linux-glibc2.5-x86_64]# cp -R ./* /usr/local/mysql/

[root@localhost local]# chown -R mysql.mysql /usr/local/mysql/

        3)新增配置文件my.cnf

# vi /etc/my.cnf

[mysqld]

# GENERAL #

user = mysql

default-storage-engine = InnoDB

socket = /tmp/mysql.sock

pid-file = /usr/local/mysql/mysql.pid

port = 3306

# MyISAM #

key_buffer_size = 1344M

# SAFETY #

max_allowed_packet = 16M

max_connect_errors = 1000000

skip_name_resolve

# DATA STORAGE #

datadir = /usr/local/mysql/data

long_query_time = 1

# BINARY LOGGING #

log-bin = /usr/local/mysql/logs/mysql-bin-3306

expire-logs-days = 14

sync-binlog = 1

server-id = 1

max_binlog_size = 500M

# REPLICATION #

relay-log = /usr/local/mysql/logs/relay-bin-3306

slave-net-timeout = 60

# CACHES AND LIMITS #

tmp_table_size = 32M

max_heap_table_size = 32M

max_connections = 500

thread_cache_size = 50

open_files_limit = 65535

table_definition_cache = 4096

table_open_cache = 4096

# INNODB #

innodb_data_file_path = ibdata1:128M;ibdata2:10M:autoextend

innodb_flush_method = O_DIRECT

innodb_log_files_in_group = 2

innodb_lock_wait_timeout = 50

innodb_log_file_size = 256M

innodb_flush_log_at_trx_commit = 1

innodb_file_per_table = 1

innodb_thread_concurrency = 8

innodb_buffer_pool_size = 8G

# LOGGING #

log-error = /usr/local/mysql/logs/mysql-error-3306.log

log-queries-not-using-indexes = 1

slow-query-log = 1

long_query_time = 1

slow-query-log-file = /usr/local/mysql/logs/mysql-slow-3306.log

[mysql]

socket = /tmp/mysql.sock

 

        4）初始化Mysql

[root@localhost mysql5.7]# cd /usr/local/mysql/bin/

[root@localhost bin]#  ./mysqld --user=mysql --basedir=/usr/local/mysql  --datadir=/usr/local/mysql/data --initialize 

[root@localhost bin]# tail -f ../logs/mysql-error-3306.log

2017-07-10T04:10:29.377990Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-07-10T04:10:29.481350Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-07-10T04:10:29.880939Z 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: b5f1d20f-6525-11e7-aa9b-000c2950f315.

2017-07-10T04:10:30.044524Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-07-10T04:10:30.067485Z 1 [Note] A temporary password is generated for root@localhost: ;0&_K24dDMOu

2017-07-10T04:10:31.142413Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.

2017-07-10T04:10:31.142471Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.

2017-07-10T04:10:31.142511Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.

2017-07-10T04:10:31.142537Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.

2017-07-10T04:10:31.142608Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.

 

---生成的ROOT密码注意保存起来：;0&_K24dDMOu

            4）创建init.d启动

[root@localhost bin]# cp ../support-files/mysql.server /etc/init.d/mysqld

[root@localhost bin]# chkconfig --add mysqld

[root@localhost bin]# vim /etc/init.d/mysqld

           5）启动/登录mysql数据库

[root@mysql-node1 bin]# systemctl start mysqld

[root@mysql-node1 bin]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 

[root@mysql-node1 bin]# mysql -uroot -p;0&_K24dDMOu

            6）忘记mysql ROOT密码登录

[root@mysql-node1 bin]# ./mysqld_safe --skip-grant-tables  &

[root@mysql-node1 bin]# mysql -uroot

mysql> update mysql.user set authentication_string=password('mysql_gd17') where user='root';

mysql> \q

[root@mysql-node1 bin]# systemctl restart mysqld.service

[root@mysql-node1 bin]# mysql -uroot -pmysql_gd17