本文以统信服务器操作系统A、E版 + MySQL 5.7.27作为演示!!
提示: 请先查看常见报错
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';