mysql 5.7编译安装重启_mysql5.7.22在centos7编译安装

1.源码下载地址

https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.22.tar.gz

2.依赖包安装

yum -y install gcc gcc-c++ ncurses ncurses-devel make cmake git

groupadd mysql

useradd -r -g mysql -s /sbin/nologin mysql

mkdir -p /root/mysql/mysql

mkdir -p /root/mysql/data

mkdir -p /root/mysql/log

cd /root

chown -R mysql.mysql mysql/

cmake . -DCMAKE_INSTALL_PREFIX=/root/mysql/mysql -DMYSQL_DATADIR=/root/mysql/data -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/src/mysql-5.7.22/boost -DSYCONFDIR=/etc -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_LOAL_INFILE=1  -DENABLE_DRACE=0  -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EMBEDDED_SERVER=1

make & make install

vi /etc/my.cnf

[client]

port=3306

socket=/root/mysql/data/mysql.sock

default-character-set=utf8

[mysqld]

port=3306

user=mysql

socket=/root/mysql/data/mysql.sock

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

basedir=/root/mysql/mysql

datadir=/root/mysql/data

tmpdir=/root/mysql/tmpdir

character-set-server=utf8

log_error=/root/mysql/log/mysql.err

server_id=2

log_bin=/root/mysql/log/binlog

general_log_file=/root/mysql/log/general_log

general_log=1

slow_query_log=ON

long_query_time=1

slow_query_log_file=/root/mysql/log/query_log

log_queries_not_using_indexes=ON

#######主主复制时主数据库要设置

log-slave-updates=1

#事务特性,最好设为1

sync_binlog=1

cd /root/mysql/mysql/bin

./mysqld  --initialize-insecure --user=mysql --basedir=/root/mysql/mysql --datadir=/root/mysql/data

出现如下错误bin/mysqld --initialize-insecure --user=mysql --basedir=/root/mysql/mysql --datadir=/root/mysql/data

mysqld: Can't change dir to '/root/mysql/data/' (Errcode: 13 - Permission denied)

2018-05-26T09:58:05.494660Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-05-26T09:58:05.669099Z 0 [ERROR] failed to set datadir to /root/mysql/data/

2018-05-26T09:58:05.669148Z 0 [ERROR] Aborting

解决方法：

chown -R mysql:mysql  /rootGRANT REPLICATION SLAVE ON *.* to 'slave'@'172.17.0.%' identified by 'mypassword123';change master to master_host='172.17.0.2',master_port=3306,master_user='slave',master_password='mypassword123',master_log_file='binlog.000005',master_log_pos=1045;

start slave; #启动slave

关闭SELinux

临时关闭：setenforce0

永久关闭

vi /etc/selinux/config

将SELINUX=enforcing改为SELINUX=disabled

设置后需要重启才能生效

创建帐号

授权格式：grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";grant create,select,insert,update on *.*  to 'myuser'@'172.17.0.%'  identified by  "nihaomyuser";

flush privileges;