mysql5.6.41安装_linux下mysql 5.6.41安装（二进制）

一、环境准备

https://www.cndba.cn/laonanhai/article/2969

实验环境：centos 6.5

数据库版本：5.6.41

二、数据库安装

2.1 安装部分包https://www.cndba.cn/laonanhai/article/2969https://www.cndba.cn/laonanhai/article/2969

yum -y install numactl libaio*

[root@localhost ~]# cd /usr/local/src

[root@localhost src]# wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz

2.3 解压

[root@localhost src]# tar zxf mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz

2.4 复制

https://www.cndba.cn/laonanhai/article/2969

[root@localhost src]# cp -r mysql-5.6.41-linux-glibc2.12-x86_64 /usr/local/mysql

2.5 添加系统mysql组和mysql用户

[root@localhost src]# groupadd mysql

[root@localhost src]# useradd -r -g mysql mysql

创建mysql数据和日志存放目录

[root@localhost src]# cd /

[root@localhost /]# mkdir data

[root@localhost /]# cd data

[root@localhost data]# mkdir mysql

[root@localhost data]# cd mysql

[root@localhost mysql]# mkdir data

[root@localhost mysql]# mkdir log

[root@localhost mysql]# cd log

[root@localhost log]# touch error.log

[root@localhost log]# chown -R mysql:mysql /data/mysql/log

[root@localhost log]# chown -R mysql:mysql /data/mysql/data

切到mysql安装目录

[root@localhost src]# cd /usr/local/mysql

修改当前目录拥有者为mysql用户

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

安装数据库

[root@localhost mysql]# ./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql

2.7 修改/etc/my.cnf文件

https://www.cndba.cn/laonanhai/article/2969

[root@localhost mysql]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

[root@localhost mysql]# vi /etc/my.cnf

配置如下：

[mysqld]

user = mysql

port = 3306

autocommit = 1

server_id = 20180827

character-set-server=utf8

lower_case_table_names=1

basedir = /usr/local/mysql

datadir = /data/mysql/data

socket = /tmp/mysql.sock

pid-file = /data/mysql/data/mysqld.pid

# connection settings #

interactive_timeout=1800

wait_timeout=1800

max_connections =1000

# session memory settings #

read_buffer_size=16M

read_rnd_buffer_size=64M

# log settings #

log_error = /data/mysql/log/error.log

slow_query_log_file = /data/mysql/log/slow.log

log-bin=/data/mysql/log/mysql-bin

expire_logs_days=7

slow_query_log = 1

long-query-time = 1 #慢查询时间 超过1秒则为慢查询

# innodb settings #

innodb_log_buffer_size=64M

innodb_sort_buffer_size=2M

sort_buffer_size=64M

thread_cache_size=80

# replication settings #

master_info_repository = TABLE

relay_log_info_repository = TABLE

sync_binlog = 1

log_slave_updates

binlog_format=row

binlog_rows_query_log_events = 1

relay_log = relay.log

relay_log_recovery = 1

slave_skip_errors = ddl_exist_errors

slave-rows-search-algorithms = 'INDEX_SCAN,HASH_SCAN'

replicate-ignore-db=mysql

replicate-ignore-db=information_schema

replicate-ignore-db=performance_schema

replicate-ignore-db=test

2.8 设置mysql自动启动

https://www.cndba.cn/laonanhai/article/2969

将服务文件拷贝到init.d下，并重命名为mysqld

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

修改/etc/init.d/mysqld文件

[root@localhost mysql]# vi /etc/init.d/mysqld

设置basedir和datadir的路径，配置如下：

basedir=/usr/local/mysql

datadir=/data/mysql/data

赋予可执行权限

[root@localhost mysql]# chmod +x /etc/init.d/mysqld

加入开机启动

[root@localhost mysql]# chkconfig --add mysql

2.9 启动mysql服务并初始化密码https://www.cndba.cn/laonanhai/article/2969https://www.cndba.cn/laonanhai/article/2969

启动mysql服务

[root@localhost mysql]# service mysqld start

Starting MySQL.. SUCCESS!

配置环境变量(也可以用不配置环境变量，设置软链接)

[root@localhost mysql]# vi /etc/profile

加入以下内容：

PATH=/usr/local/mysql/bin:$Path

export PATH

使配置立即生效

[root@localhost mysql]# source /etc/profile

修改密码

[root@localhost mysql]# mysql

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 1

Server version: 5.6.41-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

mysql> set password for root@localhost = password('root');

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to root@'%' identified by 'root';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

重新登录

mysql> exit

Bye

[root@localhost mysql]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 2

Server version: 5.6.41-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set (0.00 sec)

至此，数据库安装完成。

版权声明：本文为博主原创文章，未经博主允许不得转载。

never give up