ceontos源码安装mysql8_CentOS 7编译安装MySQL 8.0

原标题：CentOS 7编译安装MySQL 8.0

前期准备条件

查看linux的版本

[root@mysql etc] # cat /etc/RedHat-release

CentOS Linux release7.3.1611(Core)

•Could NOTfind Curses

yum installncurses-devel

•Bison executable notfoundinPATH

yum installbison

备注：

安装过程中会缺少基础包，本实例环境缺少上述包，先提前安装相应的包

1.cmake的源编译安装

[root@db software] # nohup tar zxvf cmake-3.11.1.tar.gz &

[root@db software] # cd cmake-3.11.1

[root@db cmake -3.11.1] # ./configure

[root@localhost cmake -3.0.1] # gmake && make install

2.wolfssl包的部署安装[可选项]

*. 从wolfssl.com网站下载wolfssl -3.13.0.zip压缩包

*. 解压至/data/software/mysql -8.0.11/extra/wolfssl -3.13.0目录中。

*. cd extra/wolfssl -3.13.0/IDE/MYSQL

*. 执行 do.sh脚本

*. use -DWITH_SSL=wolfssl forCMake

3.openssl和openssl-devel[本实验使用的是system ssl]

yuminstall –y openssl openssl-devel

4.mysql的编译安装

[root@mysql software]#tar zxvf mysql-8.0.11.tar.gz

[root@mysql software]# cd mysql-8.0.11/

[root@mysql software]# mkdir Zdebug

[root@mysql software]# cd Zdebug

cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DENABLED_LOCAL_INFILE=ON

-DWITH_INNODB_MEMCACHED=ON

-DWITH_SSL=system

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_FEDERATED_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1

-DCOMPILATION_COMMENT="zsd edition"

-DDOWNLOAD_BOOST=1

-DWITH_BOOST=/tmp

-DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.sock

-DSYSCONFDIR=/data/mysqldata/3306 > /data/software/mysql-8.0.11/Zdebug/mysql_cmake80.log 2>&1

出现下列日志:

............

-- Configuring done

-- Generating done

-- Build files have been written to: /data/software/mysql-8.0.11/Zdebug

............

说明编译成功，其中-DWITH_SSL=system用的是linux操作系统的openssl，需要安装openssl和openssl-devel包，才可以被编译

如果需要编译安装快速，可以运用多线程加快编译安装，命令如下:

make -j 12

make install

•MySQL 8.0的软件目录结构

[root@mysql Zdebug] # cd /usr/local/mysql/

[root@mysql mysql] # ls -l

total 612

drwxr-xr-x. 2root root 4096May 1614: 20bin

drwxr-xr-x. 2root root 55May 1614: 20docs

drwxr-xr-x. 3root root 266May 1614: 20include

drwxr-xr-x. 4root root 173May 1614: 20lib

-rw-r --r--. 1 root root 301518 Apr 8 14:44 LICENSE

-rw-r --r--. 1 root root 301518 Apr 8 14:44 LICENSE-test

drwxr-xr-x. 4root root 30May 1614: 20man

drwxr-xr-x. 10root root 4096May 1614: 21mysql- test

-rw-r --r--. 1 root root 687 Apr 8 14:44 README

-rw-r --r--. 1 root root 687 Apr 8 14:44 README-test

drwxr-xr-x. 28root root 4096May 1614: 21share

drwxr-xr-x. 2root root 90May 1614: 21support-files

5.创建mysql用户&并修改相关文件

[root@mysql mysql] # groupadd mysql

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

6.设置用户操作系统资源的限制

[root@localhost cmake -3.0.1] # vi /etc/security/limits.conf

mysql soft nproc 65536

mysql hard nproc 65536

mysql soft nofile 65536

mysql hard nofile 65536

验证limit是否生效

[root@mysql ~] # su - mysql

[mysql@mysql ~]$ ulimit -a

日志如下:

openfiles (-n) 65536

maxuser processes (-u) 65536

............

7.创建MySQL数据目录及赋予相应权限

#cd/data/

#mkdir -p /data/mysqldata/{3306/{data,tmp,binlog,innodb_ts,innodb_log},backup,s}

#chown -R mysql:mysql mysqldata

#su - mysql

8.配置my.cnf文件

$ vi /data/mysqldata/3306/my.cnf

[client]

port = 3306

socket = /data/mysqldata/3306/mysql.sock

# The MySQL server

[mysqld]

port = 3306

user = mysql

socket = /data/mysqldata/3306/mysql.sock

pid-file = /data/mysqldata/3306/mysql.pid

basedir = /usr/local/mysql

datadir = /data/mysqldata/3306/data

tmpdir = /data/mysqldata/3306/tmp

open_files_limit = 60000

explicit_defaults_for_timestamp

server-id = 1203306

lower_case_table_names = 1

character-set-server = utf8

federated

#sql_mode=STRICT_TRANS_TABLES

max_connections = 1000

max_connect_errors = 100000

interactive_timeout = 86400

wait_timeout = 86400

sync_binlog=0

back_log=100

default-storage-engine = InnoDB

log_slave_updates = 1

#*********** Logs related settings ***********

log-bin = /data/mysqldata/3306/binlog/mysql-bin

binlog_format= mixed

binlog_cache_size=32m

max_binlog_cache_size=64m

max_binlog_size=512m

long_query_time = 1

log_output = FILE

log-error = /data/mysqldata/3306/mysql-error.log

slow_query_log = 1

slow_query_log_file = /data/mysqldata/3306/slow_statement.log

#log_queries_not_using_indexes

general_log = 0

general_log_file = /data/mysqldata/3306/general_statement.log

#expire-logs-days = 14

binlog_expire_logs_seconds = 1728000

relay-log = /data/mysqldata/3306/binlog/relay-bin

relay-log-index = /data/mysqldata/3306/binlog/relay-bin.index

#****** MySQL Replication New Feature*********

master-info-repository=TABLE

relay-log-info-repository=TABLE

relay-log-recovery

#*********** INNODB Specific options ***********

innodb_buffer_pool_size = 2048M

transaction-isolation=REPEATABLE-READ

innodb_buffer_pool_instances = 8

innodb_file_per_table = 1

innodb_data_home_dir = /data/mysqldata/3306/innodb_ts

innodb_data_file_path = ibdata1:2048M:autoextend

innodb_thread_concurrency = 8

innodb_log_buffer_size = 16M

innodb_log_file_size = 128M

innodb_log_files_in_group = 3

innodb_log_group_home_dir = /data/mysqldata/3306/innodb_log

innodb_flush_log_at_trx_commit = 2

innodb_max_dirty_pages_pct = 70

innodb_flush_method=O_DIRECT

[mysql]

no-auto-rehash

default-character-set=gbk

prompt = (u@h) [d]>_

9.初始化MySQL数据库

$/usr/local/mysql/bin/mysqld --defaults-file= /data/mysqldata/3306/my.cnf --initialize --user=mysql

10.启动mysql服务

$/usr/local/mysql/bin/mysqld_safe --defaults-file= /data/mysqldata/3306/my.cnf --user=mysql &

11.登陆数据库

备注:密码来自于error log日志，明细如下:

2018- 05- 16T07: 17: 57.335486Z 5[Note] [MY- 010454] [Server] A temporary password is generated forroot@localhost: j

$/usr/ local/mysql/bin/mysql -uroot -p 'j

12.数据库一些基本权限配置

•修改root账号密码:

ALTER USER 'root'@ 'localhost'IDENTIFIED WITH sha256_password BY 'zsd@7101'PASSWORD EXPIRE INTERVAL 360DAY;

•查看目前的用户账号

(root@localhost) [(none)]> select user,host from mysql.user;

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

| user |host |

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

|mysql.infoschema | localhost |

| mysql.session |localhost |

|mysql.sys | localhost |

| root |localhost |

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

☀ Linux技术交流群：1670392(新群，火热加群中……)返回搜狐，查看更多

责任编辑：