centos 7 mysql 创建用户_Centos7 编译安装mysql 8.0.11 及处理创建用户的问题

创建mysql用户

# useradd mysql -s /sbin/nologin

创建程序目录、数据目录、日志目录和boost目录

# mkdir -p /server/mysql

# mkdir -p /server/data

# mkdir -p /server/logs/mysql

# mkdir -p /server/boost

更改目录权限

# chown -R mysql:mysql /server/data/

# chown -R mysql:mysql /server/logs/mysql

下载 mysql 8.0.11 的源码

安装基础环境

# yum -y install make gcc-c++ cmake bison-devel ncurses-devel bison perl perl-devel perl perl-devel openssl-devel

编译安装

# tar zxvf mysql-boost-8.0.11.tar.gz

# cmake -DCMAKE_INSTALL_PREFIX=/server/mysql -DMYSQL_UNIX_ADDR=/server/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/server/data -DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/server/boost -DDOWNLOAD_BOOST=1

# make && make install

更改my.cnf配置

# vim /etc/my.cnf

[client]

port = 3306

socket = /server/data/mysql.sock

[mysqld]

mysqlx-port=33060                                     # 特别注意：8.0默认增加了X plugin

mysqlx-socket=/server/data/mysqlx.sock

port=3306

socket=/server/data/mysql.sock

basedir=/server/mysql

datadir=/server/data

pid-file=/