MariaDB database is broken or not working correctly? corrupted maybe?

cyberdome · 04-05-2014, 11:09 PM

I am running Fedora 20 with MariaDB 10.0

when I run the command.

systemctl start mariadb.service <-- this command does not work. it was working my mariadb 5.5 version.

I am now running mariadb 10.0 , i just recently upgraded the mariadb database using yum.

and now that command does not work. but systemctl start mysql.service command works.

when I run systemctl status mysql.service -l

Code:

Code:
mysql.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysql)
   Active: active (running) since Sat 2014-04-05 22:49:03 CDT; 7s ago
  Process: 30341 ExecStop=/etc/rc.d/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 30592 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysql.service
           ├─30598 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/user.pid
           └─30691 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/user.err --pid-file=/var/lib/mysql/user.pid

Apr 05 22:49:02 systemd[1]: Starting LSB: start and stop MySQL...
 mysql[30592]: Starting MySQL.[  OK  ]
Apr 05 22:49:03 systemd[1]: Started LSB: start and stop MySQL.

I think the mariadb-server and mariadb have become corrupt or something.

I do not know what to do next can someone help.

cin_ · 04-06-2014, 12:30 AM

are you root?

what is the output of running id with the result of whoami?

Code:

# id $(whoami)

cyberdome · 04-06-2014, 12:46 AM

Quote:

Originally Posted by cin_

are you root?

what is the output of running id with the result of whoami?

Code:

# id $(whoami)

yes, ROOT

output of the command, whoami,

Code:

uid=0(root) gid=0(root) groups=0(root)

cin_ · 04-07-2014, 11:04 AM

might be your problem..

mysql, and subsequently mariadb, dislikes being run as root

with some effort:
http://dev.mysql.com/doc/mysql-secur...st-attack.html
; you can run as root, but it's usually easier and more secure to create a user specifically for running your db:

Code:

# useradd mysql
# sudo chown mysql:mysql /var/log/mariadb -chR
login as mysql
# sudo systemctl restart mariadb.service && sudo systemctl status mariadb.service

.. if the problem persists we can look elsewhere, but this is a common hangup