【全架构】统信服务器操作系统-源码编译MySQL

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

• 统信生态官网(ChinaUOS)
• 统信服务器操作系统(A、E)下载地址
• MySQL 官网(MySQL)

提示： 请先查看常见报错

1、安装MySQL

1.1 安装依赖软件包

yum -y install cmake git make 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 && make install 

-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

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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 -y install 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 && make install

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;
874 
875         (void) sigemptyset(&nset);
876         (void) sigaddset(&nset, SIGWINCH);
877         (void) sigprocmask(SIG_BLOCK, &nset, &oset);
878 
879         area = NULL;                       # 将值修改为NULL
# 修改完重新编译

参考文献：https://bbs.cnbugs.com/read-43-1.html，在此致谢大佬

> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement

## 解决方法
alter user user() identified by 'xxxxx';