统信服务器操作系统-源码编译MySQL
本文以统信服务器操作系统A、E版 + MySQL 5.7.27作为演示！！统信生态官网(ChinaUOS) 统信服务器操作系统(A、E)下载地址 MySQL 官网(MySQL)
提示： 请先查看常见报错
1、安装MySQL
1.1 安装依赖软件包
yum -yinstall cmake gitmake gcc gcc-c++ vim1.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_01.4 编译安装
make-j16&&makeinstall-j 指定参与编译时所用到的核，根据实际情况指定
2、配置MySQL
2.1 创建MySQL程序用户
useradd-M-s /sbin/nologin mysql2.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 mysqld2.4 配置环境变量
echo'export PATH=$PATH:/usr/local/mysql/bin'>> /etc/profile
source /etc/profile3、初始化数据库
3.1 创建数据文件夹
cd /usr/local/mysql/
mkdir data &&chown mysql:mysql data/ -R3.2 初始化
./bin/mysqld--initialize--basedir=/usr/local/mysql\--datadir=/usr/local/mysql/data --user=mysql初始化完成后结尾处会有默认密码，请自行保留
3.1 编辑配置文件
vim /etc/my.cnf
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
symbolic-links=0
log-error=/var/log/mysql.log4、启动/停止MySQL
systemctl start mysqld # 启动MySQL
systemctl stopmysqld # 停止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-develChecking 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-develCMake 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&&makeinstall2、使用报错
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;*/ # 注释该行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';
页:
[1]