mysql5.7.29 cmake_CentOS8 编译安装 Mysql5.7.29

Dear 丶 2023-01-12 11:37 32阅读 0赞

安装必要的运行环境

yum install -y gcc gcc-c++ bzip2-devel bzip2-libs bison perl-Module-Install.noarch libtirpc-devel ncurses ncurses-devel bison cmake

yum install ncurses ncurses-devel bison cmake -y

yum install libtirpc-devel -y

检查cmake 是否安装

rpm -qa|grep cmake

解压boost

cd /usr/local

wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost\_1\_59\_0.tar.gz

tar xzf boost\_1\_59\_0.tar.gz

mv boost\_1\_59\_0/ boost

下载mysql

cd /usr/local/src/

wget "https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.29.tar.gz"

或者 wget "https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.29.tar.gz"

tar -zxvf mysql-5.7.29.tar.gz

cd mysql-5.7.29

建立相应目录

mkdir -p /data/mysql/data

mkdir -p /data/mysql/log/

mkdir -p /data/mysql/binlog/

mkdir -p /data/mysql/tmp/

cmake配置编译参数

cmake . -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql57 \\

\-DSYSCONFDIR=/etc \\

\-DMYSQL\_DATADIR=/data/mysql/data \\

\-DMYSQL\_UNIX\_ADDR=/data/mysql/tmp/mysql.sock \\

\-DDEFAULT\_CHARSET=utf8 \\

\-DDEFAULT\_COLLATION=utf8\_general\_ci \\

\-DEXTRA\_CHARSETS=gbk,gb2312,utf8,ascii \\

\-DENABLED\_LOCAL\_INFILE=ON \\

\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\

\-DWITH\_FEDERATED\_STORAGE\_ENGINE=1 \\

\-DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 \\

\-DWITHOUT\_EXAMPLE\_STORAGE\_ENGINE=1 \\

\-DWITHOUT\_PARTITION\_STORAGE\_ENGINE=1 \\

\-DWITH\_ZLIB=bundled \\

\-DWITH\_EMBEDDED\_SERVER=1 \\

\-DWITH\_DEBUG=0 \\

\-DWITH\_SYSTEMD=1 \\

\-DWITH\_BOOST=/usr/local/boost

编译安装

make && make install

用户组及权限

groupadd mysql

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

chown -R mysql.mysql /data/mysql/

配置MySQL系统环境变量

echo 'export PATH=/usr/local/src/mysql57/bin:$PATH' >>/etc/profile

tail -1 /etc/profile

//export PATH=/usr/local/src/mysql/bin:$PATH

生效

source /etc/profile

初始化数据库

\#修改/etc/my.cnf文件，和5.6之前的版本不一样，5.7版本support-files目录下没有.cnf文件，因此，需要自己手动编辑

cp /etc/my.cnf /etc/my.cnf.bak

vim /etc/my.cnf

写入

\[client\]

port = 3689

socket = /data/mysql/tmp/mysql.sock

default-character-set = utf8

\[mysqld\]

port = 3689

user = mysql

basedir = /usr/local/mysql57

datadir = /data/mysql/data

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

socket = /data/mysql/tmp/mysql.sock

tmpdir = /data/mysql/tmp

character\_set\_server = utf8

server-id = 1

max\_connections = 100

max\_connect\_errors = 10

sql\_mode = NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_AUTO\_VALUE\_ON\_ZERO,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,PIPES\_AS\_CONCAT,ANSI\_QUOTES

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

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

添加PID目录并给予权限

mkdir -p /var/run/mysqld

chown mysql.mysql /var/run/mysqld

初始化数据库

/usr/local/mysql57/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57 --datadir=/data/mysql/data

创建快捷启动级开机服务启动

cp /usr/local/mysql57/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/

改变 /usr/lib/systemd/system/mysqld.service 下的pid目录

将PIDFile=/var/run/mysqld/mysqld.pid 改为 PIDFile=/data/mysql/tmp/mysql.pid

加入权限

systemctl daemon-reload

systemctl enable mysqld.service

systemctl start mysqld

启动mysql创建本地管理帐号及删除无密码帐号

/usr/local/mysql57/bin/mysqladmin -u root password 'orange\#123'

/usr/local/mysql57/bin/mysql -uroot -p'orange\#123' -e "delete from mysql.user where password='';"

/usr/local/mysql57/bin/mysql -uroot -p'orange\#123' -e "flush privileges;"

创建用户

/usr/local/mysql57/bin/mysql -uroot -p

create user 'orange'@'%' identified by 'Hu\#jgh%GVhb@5dGf35';

grant all privileges on \*.\* to 'orange'@'%';

flush privileges;

查看my.cnf命令

/usr/local/mysql-5.7.27/bin/mysqld --verbose --help|grep my.cnf

报错

先清除CMakeCache.txt

rm -rf CMakeCache.txt

CMake Error at rapid/plugin/group\_replication/rpcgen.cmake:93 (MESSAGE):

Could not find rpcgen

解决方法

wget https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz

tar xf rpcsvc-proto-1.4.tar.gz

cd rpcsvc-proto-1.4

./configure

make && make install

ln -s /usr/local/mysql-5.7.27/bin/mysql /usr/bin

cp /usr/local/mysql-5.7.27/bin/my\_print\_defaults /usr/bin

mysql5.7.29 cmake_CentOS8 编译安装 Mysql5.7.29

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL-CentOS安装MySQL8

相关 mysql5.6编译安装包_MySQL5.6编译安装

相关 MySQL：Centos8安装Mysql8。

相关安装mysql8

相关 centos8安装mysql8_centos8上安装mysql8

相关编译安装MySQL

相关 MySQL的编译安装

相关 MySQL编译安装笔记

相关 mysql编译安装

相关 CentOS7编译安装MySQL8.0