文章

创建软件存放目录

mkdir /home/soft/
cd /home/soft/

卸载Centos7自带的mariadb

yum -y remove maria*

rm /etc/my.cnf

下载mysql5.6的源码包

wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.40.tar.gz

解压mysql5.6的源码包

tar zxvf mysql-5.6.40.tar.gz

依赖包

yum -y install gcc gcc-c++ ncurses-devel bison bison-devel perl perl-devel autoconf

安装cmake

yum -y install cmake

添加MySQL运行账户和组

groupadd mysql
useradd -s /sbin/nologin -M -g mysql mysql

编译mysql

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \

make && make install

修改文件夹权限

chown -R root:mysql /usr/local/mysql/

chown -R mysql:mysql /usr/local/mysql/data/

拷贝配置文件my.cnf

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

vi /etc/my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
# server_id = .....
socket = /tmp/mysql.sock

初始化数据库

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

设置成开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

chkconfig mysqld on

设置mysql环境变量

vi /etc/profile
添加：
export PATH=$PATH:/usr/local/mysql/bin

source /etc/profile

初始化MySQL及相关安全选项配置

mysql_secure_installation

开启3306端口

firewall-cmd --permanent --add-port=3306/tcp

firewall-cmd --reload

配置192.168.20.65可以通过root:123456访问数据库

GRANT ALL PRIVILEGES ON *.* to 'root'@'192.168.20.65' IDENTIFIED BY '123456' WITH GRANT OPTION;

从mysql数据库中的授权表重新载入权限

flush privileges;