LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-06-2014, 12:09 AM   #1
cyberdome
Member
 
Registered: Mar 2014
Distribution: Fedora 23 - MariaDB 10.1 -
Posts: 130
Blog Entries: 2

Rep: Reputation: 8
MariaDB database is broken or not working correctly? corrupted maybe?


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.

Last edited by cyberdome; 04-06-2014 at 12:17 AM.
 
Old 04-06-2014, 01:30 AM   #2
cin_
Member
 
Registered: Dec 2010
Posts: 277

Rep: Reputation: 24
root?

are you root?

what is the output of running id with the result of whoami?
Code:
# id $(whoami)
 
Old 04-06-2014, 01:46 AM   #3
cyberdome
Member
 
Registered: Mar 2014
Distribution: Fedora 23 - MariaDB 10.1 -
Posts: 130
Blog Entries: 2

Original Poster
Rep: Reputation: 8
Quote:
Originally Posted by cin_ View Post
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)
 
Old 04-07-2014, 12:04 PM   #4
cin_
Member
 
Registered: Dec 2010
Posts: 277

Rep: Reputation: 24
mysql dislikes root

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

Last edited by cin_; 04-07-2014 at 12:06 PM. Reason: gramm`err
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Red Hat Enterprise Linux 7 beta arrives with MariaDB as its default database LXer Syndicated Linux News 0 12-11-2013 11:12 PM
LXer: Slackware switching to the MariaDB database LXer Syndicated Linux News 0 03-24-2013 10:42 PM
Synaptic Package manager database corrupted mohit052 Linux - Software 5 08-17-2009 11:55 PM
rpm database corrupted? h725 Red Hat 3 07-11-2008 11:18 AM
How to fix corrupted RPM database? Cygnus78 Linux - General 2 05-19-2004 08:26 PM


All times are GMT -5. The time now is 08:15 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration