Bhavya Arora Bhavya Arora - 1 year ago 338
MySQL Question

Mariadb doesn't starts. Control process Exited

I am trying to start mariadb with

systemctl start mariadb
also tried using sudo along.

This is what it says

Job for mariadb.service failed because the control process exited with
error code. See "systemctl status mariadb.service" and "journalctl
-xe" for details.

I saw this at many places but nothing helped.

It fails, I removed, installed again, nothing happened.

This is a part of /var/log/messages

Jun 17 18:03:09 controller systemd: Starting MariaDB 10.1 database
server... Jun 17 18:03:09 controller mysqld: 2016-06-17 18:03:09
140477178509440 [Note] /usr/libexec/mysqld (mysqld 10.1.12-MariaDB)
starting as process 120408 ... Jun 17 18:03:12 controller systemd:
mariadb.service: main process exited, code=exited, status=1/FAILURE
Jun 17 18:04:13 controller systemd: mariadb.service: control process
exited, code=exited status=3 Jun 17 18:04:13 controller systemd:
Failed to start MariaDB 10.1 database server. Jun 17 18:04:13
controller systemd: Unit mariadb.service entered failed state. Jun 17
18:04:13 controller systemd: mariadb.service failed.

I am really new to CentOS and mariadb, so I don't know how to proceed.


The mariadb.log says

2016-06-17 19:24:39 140652810123392 [Note] Server socket created on IP: '::'.

2016-06-17 19:24:39 140652810123392 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use

2016-06-17 19:24:39 140652810123392 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2016-06-17 19:24:39 140652810123392 [ERROR] Aborting

This is my my.cnf

# This group is read both both by the client and the server
# use it for options that affect everything

# This group is read by the server
bind-address =
default-storage-engine = innodb
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

# Disabling symbolic-links is recommended to prevent assorted security risks

# include all files from the config directory
!includedir /etc/my.cnf.d

I tried adding a line in my.cnf


Didn't help, mariadb.log says the same thing as I have mentioned earlier.

Answer Source

fuser -k 3306/tcp will solve the probem. -k is to Kill processes accessing the file.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download