我已经安装了第三方框架fate,mysql已经安装在这个框架中,路径如下:/data/projects/fate/common/mysql/mysql-8.0.28。
我已将/data/projects/fate/common/mysql/mysql-8.0.28/conf/my.conf复制到/etc/my.cnf,其内容如下:
[mysqld]
port=3306
basedir=/data/projects/fate/common/mysql/mysql-8.0.28
datadir=/data/projects/fate/data/mysql
socket=/data/projects/fate/common/mysql/mysql-8.0.28/run/mysql.sock
max_connections=10000
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
mysqlx=0
[mysql]
default-character-set=utf8
[client]
port=3306
default-character-set=utf8
socket=/data/projects/fate/common/mysql/mysql-8.0.28/run/mysql.sock
[mysqld_safe]
log-error=/data/projects/fate/common/mysql/mysql-8.0.28/logs/mysqld.log
pid-file=/data/projects/fate/common/mysql/mysql-8.0.28/run/mysqld.pid但是,当我尝试用systemctl start mysqld开头mysqld时,我得到:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.systemctl status mysqld.service后
● mysqld.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
Active: failed (Result: exit-code) since Sat 2022-05-14 16:27:43 CST; 13s ago
Docs: man:systemd-sysv-generator(8)
Process: 20483 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)
May 14 16:27:41 vm-0-1-centos systemd[1]: Starting LSB: start and stop MySQL...
May 14 16:27:43 vm-0-1-centos mysqld[20483]: Starting MySQL..The server quit without updating PID file (/data/projects/fate/data/mysql/vm-0-1-centos.pid).[FAILED]
May 14 16:27:43 vm-0-1-centos systemd[1]: mysqld.service: control process exited, code=exited status=1
May 14 16:27:43 vm-0-1-centos systemd[1]: Failed to start LSB: start and stop MySQL.
May 14 16:27:43 vm-0-1-centos systemd[1]: Unit mysqld.service entered failed state.
May 14 16:27:43 vm-0-1-centos systemd[1]: mysqld.service failed.或者当使用service mysqld start时,问题是
Starting MySQL.The server quit without updating PID file (/data/projects/fate/data/mysql/vm-0-1-centos.pid).[FAILED]我已经尝试了很多其他问题的解决方案,现在我陷入困境,心烦意乱。我不想再次重新安装mysql,因为我担心另一个mysql可能会影响第三方框架fate的工作。
发布于 2022-05-14 14:19:19
你可以试着检查:
file
https://stackoverflow.com/questions/72238575
复制相似问题