Job for mariadb.service failed because the control process exited with error code.

关注

原创最新推荐文章于 2025-05-18 16:31:34 发布 4.6k 阅读 AI 写同款· GEO 优化 ›

启动mariadb/mysql报错Job for mariadb.service failed because the control process exited with error code解决报错：Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. 分析：导致这类错误cocntrol process exited的原因有多种，我... 阅读详情

使用yum安装mariadb，在启动服务的时候报错：Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

在这里插入图片描述

解决方法：

可以找一下my-huge.cnf文件，然后直接cp到/etc/my.cnf
如果没有my-huge.cnf这个文件，可以直接复制以下内容到my.cnf中：
[client]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
[mysqld]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
log-bin=mysql-bin
server-id	= 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout