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@nfsdb1 ~]# systemctl list-units | grep -i mysql mysql.service loaded active running LSB: start and stop MySQL
[root@nfsdb1 ~]# systemctl start mysql.service
[root@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@listmail.innovate.net
wrote:
------------ Original Message ------------
Date: Sunday, May 10, 2015 01:20:34 PM -0700 From: John R Pierce pierce@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@centos.org http://lists.centos.org/mailman/listinfo/centos