统信服务器操作系统-源码编译MySQL

艾哥 · 发表于昨天 09:44

本文以统信服务器操作系统A、E版 + MySQL 5.7.27作为演示！！

提示：请先查看常见报错

1、安装MySQL

1.1 安装依赖软件包

yum -yinstall cmake gitmake gcc gcc-c++ vim

复制代码

1.2 下载MySQL源码并解压

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz
tar xf mysql-boost-5.7.27.tar.gz
cd mysql-5.7.27/

复制代码

1.3 预编译（报错参考编译报错）

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DSYSCONFDIR=/etc \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS=all \-DDOWNLOAD_BOOST=1\-DWITH_BOOST=./boost/boost_1_59_0

复制代码

1.4 编译安装

make-j16&&makeinstall

复制代码

-j 指定参与编译时所用到的核，根据实际情况指定

2、配置MySQL

2.1 创建MySQL程序用户

useradd-M-s /sbin/nologin mysql

复制代码

2.2 修改程序目录的所有者

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

复制代码

2.3 将MySQL添加到系统服务

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

复制代码

2.4 配置环境变量

echo'export PATH=$PATH:/usr/local/mysql/bin'>> /etc/profile
source /etc/profile

复制代码

3、初始化数据库

3.1 创建数据文件夹

cd /usr/local/mysql/
mkdir data &&chown mysql:mysql data/ -R

复制代码

3.2 初始化

./bin/mysqld --initialize--basedir=/usr/local/mysql\--datadir=/usr/local/mysql/data --user=mysql

复制代码

初始化完成后结尾处会有默认密码，请自行保留

3.1 编辑配置文件

vim /etc/my.cnf
[mysqld]datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
symbolic-links=0[mysqld_safe]
log-error=/var/log/mysql.log

复制代码

4、启动/停止MySQL

systemctl start mysqld # 启动MySQL
systemctl stop mysqld # 停止MySQL
systemctl restart mysqld # 重启MySQL
systemctl status mysqld # 查看状态

复制代码

5、使用数据库（无法正常使用）

mysql -uroot-p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.27
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
段错误 (核心已转储)# 参考使用报错^_^

复制代码

常见问题

如果遇到下述类似报错：
1、编译报错

-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:64 (MESSAGE):
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
# yum -y install ncurses-devel

复制代码

Checking for module 'libtirpc'
-- Package 'libtirpc', required by 'virtual:world', not found
CMake Error at cmake/rpc.cmake:69 (MESSAGE):
Could not find rpc/rpc.h in /usr/include or /usr/include/tirpc
Call Stack (most recent call first):
# yum -y install libtirpc-devel

复制代码

CMake Error at rapid/plugin/group_replication/rpcgen.cmake:93 (MESSAGE):
Could not find rpcgen
Call Stack (most recent call first):
## x86_64(amd64) & aarch64(arm64)
yum -yinstall rpcgen # 需要开启 UniontechOS-20-PowerTools 仓库## Loongarch64 可以尝试使用 `yum -y install rpcgen` 进行安装，如没有，可使用源码安装wget https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4.1/rpcsvc-proto-1.4.1.tar.xz
tar xf rpcsvc-proto-1.4.1.tar.xz
cd rpcsvc-proto-1.4.1/
./configure --build=loongarch64-unknown-linux-gnu
make&&makeinstall

复制代码

2、使用报错

mysql -uroot-p
Enter password:
...
段错误 (核心已转储)## 解决方法# 查找要修改的文件find / -name'terminal.c'
/root/mysql-5.7.27/cmd-line-utils/libedit/terminal.c
# 修改该文件vim /root/mysql-5.7.27/cmd-line-utils/libedit/terminal.c
866 terminal_set(EditLine *el, const char *term)867{868 int i;869 /*char buf[TC_BUFSIZE];*/ # 注释该行870 char *area;871 const struct termcapstr *t;872 sigset_t oset, nset;873 int lins, cols;874875(void) sigemptyset(&nset);876(void) sigaddset(&nset, SIGWINCH);877(void) sigprocmask(SIG_BLOCK, &nset, &oset);878879 area = NULL;# 将值修改为NULL# 修改完重新编译

复制代码

> show databases;
ERROR 1820(HY000): You must reset your password using ALTER USER statement before executing this statement
## 解决方法
alter user user() identified by 'xxxxx';

复制代码

[关于统信] 统信服务器操作系统-源码编译MySQL

站长推荐 /1