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

艾哥

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

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

提示： 请先查看常见报错


1、安装MySQL

1.1 安装依赖软件包

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

复制代码

1.2 下载MySQL源码并解压

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

复制代码

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

1. 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 编译安装

1. make-j16&&makeinstall

复制代码

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

2、配置MySQL

2.1 创建MySQL程序用户

1. useradd-M-s /sbin/nologin mysql

复制代码

2.2 修改程序目录的所有者

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

复制代码

2.3 将MySQL添加到系统服务

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

复制代码

2.4 配置环境变量

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

复制代码

3、初始化数据库

3.1 创建数据文件夹

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

复制代码

3.2 初始化

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

复制代码

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

3.1 编辑配置文件

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

复制代码

4、启动/停止MySQL

1. systemctl start mysqld               # 启动MySQL
   
2. systemctl stop  mysqld               # 停止MySQL
   
3. systemctl restart mysqld             # 重启MySQL
   
4. systemctl status mysqld              # 查看状态

复制代码

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

1. mysql -uroot-p
   
2. Enter password:
   
3. Welcome to the MySQL monitor.  Commands end with ; or \g.
   
4. Your MySQL connection id is 7
   
5. Server version: 5.7.27
   
6. 
   
7. Copyright (c)2000, 2019, Oracle and/or its affiliates. All rights reserved.
   
8. 
   
9. Oracle is a registered trademark of Oracle Corporation and/or its
   
10. affiliates. Other names may be trademarks of their respective
    
11. owners.
    
12. 
    
13. 段错误 (核心已转储)# 参考使用报错^_^

复制代码

常见问题

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

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

复制代码

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

复制代码

1. CMake Error at rapid/plugin/group_replication/rpcgen.cmake:93 (MESSAGE):
   
2.   Could not find rpcgen
   
3. Call Stack (most recent call first):
   
4. 
   
5. ## x86_64(amd64) & aarch64(arm64)
   
6. 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
   
7. tar xf rpcsvc-proto-1.4.1.tar.xz
   
8. cd rpcsvc-proto-1.4.1/
   
9. ./configure  --build=loongarch64-unknown-linux-gnu
   
10. make&&makeinstall

复制代码

2、使用报错

1. mysql -uroot-p
   
2. Enter password:
   
3. ...
   
4. 段错误 (核心已转储)## 解决方法# 查找要修改的文件find / -name'terminal.c'
   
5. /root/mysql-5.7.27/cmd-line-utils/libedit/terminal.c
   
6. # 修改该文件vim /root/mysql-5.7.27/cmd-line-utils/libedit/terminal.c
   
7. 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# 修改完重新编译

复制代码

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

复制代码