[CentOS] mariadb fails to start under C7

Sun May 10 21:27:01 UTC 2015
Tim Dunphy <bluethundr at gmail.com>

Actually, the systemctl command is:

   systemctl start mysql.service

from the "systemctl show" output it looks like this actually calls
the /etc/rc.d/init.d/mysql file for start/stop/reload, which seems
backwards.

It appears that mariadb is trying to be a total drop-in replacement
to mysql, so all the paths/files, etc., e.g., in the ps output, are
"mysql" not "mariadb" -- so it's tricky to have them both installed.

By the way, you can use things like:

   systemctl list-units

(and likely more efficient approaches) to find the systemctl command

> naming.





By gum! That seems to have done it!! Thank you very much for those tips!

[root at nfsdb1 ~]# systemctl list-units | grep -i mysql
mysql.service
loaded active running   LSB: start and stop MySQL

[root at nfsdb1 ~]#  systemctl start mysql.service

[root at nfsdb1 ~]# lsof -i :3306
COMMAND PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld  839 mysql   16u  IPv6  15270      0t0  TCP *:mysql (LISTEN)

And then I just ran mysql_secure_install and now I can log into the DB!

Thanks so much for the help! The CentOS list rocks!!

Tim


On Sun, May 10, 2015 at 5:11 PM, Richard <lists-centos at listmail.innovate.net
> wrote:

>
>
> ------------ Original Message ------------
> > Date: Sunday, May 10, 2015 01:20:34 PM -0700
> > From: John R Pierce <pierce at hogranch.com>
> >
> > On 5/10/2015 1:04 PM, Earl A Ramirez wrote:
> >> Did a little Googling [0] and I saw that they recommend starting
> >> it as follows:
> >>
> >> /etc/init.d/mysql start
> >
> > which is old school sysVinit style.
> >
> > my guess is, you'll need to fix up a systemd service description
> > file, like /usr/lib/systemd/system/mariadb.service
>
> Actually, the systemctl command is:
>
>    systemctl start mysql.service
>
> from the "systemctl show" output it looks like this actually calls
> the /etc/rc.d/init.d/mysql file for start/stop/reload, which seems
> backwards.
>
> It appears that mariadb is trying to be a total drop-in replacement
> to mysql, so all the paths/files, etc., e.g., in the ps output, are
> "mysql" not "mariadb" -- so it's tricky to have them both installed.
>
> By the way, you can use things like:
>
>    systemctl list-units
>
> (and likely more efficient approaches) to find the systemctl command
> naming.
>
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>



-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B