centos7.4下源码安装mysql5.7

本人安装过数据库好多次了，之前选择的版本可能有问题，之后会发截图，记住选择的版本，否则白做无用功。

附 mysql5.7官网下载地址： https://dev.mysql.com/downloads/mysql/5.7.html#downloads

上图才是正确的源码包。

下载mysql的依赖包boost

wget --no-check-certificate http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

安装系统自带的mysql所依赖的包

yum -y install autoconf automake libtool cmake ncurses-devel openssl-devel lzo-devel zlib-devel gcc gcc-c++

解压软件包

tar zxvf boost_1_59_0.tar.gz
tar zxvf mysql-5.7.27.tar.gz

创建mysql用户

useradd -M -s /sbin/nologin mysql

编译mysql：

cmake . -DCMAKE_INSTALL_PREFIX=/data/mysql/mysql-5.7.27 \
-DMYSQL_DATADIR=/data/mysql/mysql-5.7.27/data \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/opt/boost_1_59_0 \
-DSYSCONFDIR=/etc/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_EMBEDDED_SERVER=1 \
-DMYSQL_TCP_PORT=3306;

make
make install

设置启动程序

cp /opt/mysql-5.7.27/support-files/mysql.server /etc/init.d/mysqld

修改 /etc/init.d/mysqld文件中的 basedir= 和 datadir= 的值为如下：下面的路径时本人设置的。

basedir=/data/mysql/mysql-5.7.27
datadir=/data/mysql/mysql-5.7.27/data

添加执行权限

chmod +x /etc/init.d/mysqld

将MySQL的安装目录和数据存储目录添加为 上面创建的mysql普通用户

chown -R mysql.mysql mysql/

附一份mysql的配置文件，仅供参考：

[client]
port = 3306
socket = /data/mysql/mysql-5.7.27/mysql.sock
default-character-set = utf8

[mysqld]
user = mysql
port = 3306
socket = /data/mysql/mysql-5.7.27/mysql.sock
basedir = /data/mysql/mysql-5.7.27
datadir = /data/mysql/mysql-5.7.27/data
pid-file = /data/mysql/mysql-5.7.27/mysql.pid
max_connections = 1000
max_connect_errors = 6000
init-connect = 'SET NAMES utf8'
character-set-server = utf8
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 16M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
back_log = 300
performance_schema = 0
skip-external-locking

server-id = 101
log_bin = /data/mysql/mysql-5.7.27/binlog/bin
binlog_format = mixed
binlog_cache_size = 1M
log_slave_updates = 1
expire_logs_days = 30
log_error = /data/mysql/mysql-5.7.27/mysql-error.log
slow_query_log = 1
long_query_time = 3
slow_query_log_file = /data/mysql/mysql-5.7.27/mysql-slow.log

default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 1000M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_lock_wait_timeout = 120
innodb_sort_buffer_size = 16M
wait_timeout = 28800

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

初始化数据库

/data/mysql/mysql-5.7.27/bin/mysqld --initialize-insecure --user=mysql --basedir=/data/mysql/mysql-5.7.27 --datadir=/data/mysql/mysql-5.7.27/data

启动数据库

/etc/init.d/mysqld start

进入数据库

mysql -uroot -p #因为没设置密码，这里为空就可