服务器安装mysql5.7

阿里云服务器上安装mysql5.7

安装完了,打不开.
csdn上看了一圈基本没用.

[root@iZbp1fiaizyqldalicaybmZ ~]# 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@iZbp1fiaizyqldalicaybmZ ~]#  systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (auto-restart) (Result: exit-code) since Tue 2023-01-24 02:56:39 CST; 9ms ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 18871 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 18847 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Jan 24 02:56:39 iZbp1fiaizyqldalicaybmZ systemd[1]: mysqld.service: control process exited, code=exited status=1
Jan 24 02:56:39 iZbp1fiaizyqldalicaybmZ systemd[1]: Failed to start MySQL Server.
Jan 24 02:56:39 iZbp1fiaizyqldalicaybmZ systemd[1]: Unit mysqld.service entered failed state.
Jan 24 02:56:39 iZbp1fiaizyqldalicaybmZ systemd[1]: mysqld.service failed.

img

排查过程如下：

  1. 去检查mysql错误日志，默认是在 /var/log/mysqld.log 下可以直接使用命令：
cat /var/log/mysqld.log
  1. 打开你的 /etc/my.cnf 查看 data目录位置，一般默认data目录在 /var/lib/mysql/data 下
    确认是否有这个目录，并且这个目录权限全部给了mysql的user

另外非常建议你看一下我的这个文章，里面有详细的安装过程，跟着安装绝对不会报错

https://bluetata.blog.csdn.net/article/details/127393684

看起来是配置的问题，再仔细检查下