华为云服务器安装mysqlb for mysqld.service failed because the control process exited with error code.See “sys

最近租了个华为云服务器，就是因为是贪图新用户折扣大，不贵，但是不太好用

一、

找到所有关于linux系统中关于mysql的文件

# find / -name '*mysql'

 

通过下面这个一个一个删除掉

rm -rf /usr/local/mysql

# 因为华为云上有可能默认用的是 maradb  先卸载服务器上的 mariadb 依赖
yum remove mariadb-libs
 

安装mysql的时候是从下面这两个地方去获得安装包

下载页面：https://downloads.mysql.com/archives/community/
下载地址：https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar
 

然后下载下来

解压

tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

得到

 执行如下

# 2.依次安装mysql rpm
rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm;
rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm;
rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm;
rpm -ivh mysql-community-server-5.7.36-1.el7.x86_64.rpm --force --nodeps;

启动 systemctl start mysqld

报错

Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
[root@ecs-155923 system]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2022-06-28 15:12:01 CST; 18s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 21786 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=127)
  Process: 21763 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

更多错误信息

 

 处理办法

vi /etc/my.cnf

将datadir =  /var/lib/mysql 改成

 

之后，还需要在/var/lib/mysql下执行mkdir data 如果该目录存在data文件夹则删除重新创建即可