/ / / / MariaDB Troubleshooting KodeKloud

MariaDB Troubleshooting KodeKloud

, , Edit





Task: After digging the issue team found that mariadb is down on the database server. Fix the issue.

Solution:

Login to database server: ssh peter@stdb01

Login as root: sudo su

Install mysql: yum install mysql


Start mariadb and check status:
systemctl start mariadb
systemctl status mariadb



Download Coding Interview Book and Get More Tutorials for Coding and Interview Solution: Click Here

Download System Design Interview Book and Get More Tutorials and Interview Solution: Click Here

Do you need more Guidance or Help? Then Book 1:1 Quick Call with Me: Click Here
Share on Google Plus

About Ashadullah Shawon

I am Ashadullah Shawon. I am a Software Engineer. I studied Computer Science and Engineering (CSE) at RUET. I Like To Share Knowledge. Learn More: Click Here
    Blogger Comment
    Facebook Comment

12 comments:

  1. AnonymousAugust 2, 2020 at 7:34 AM

    It worked. But how to figure out the issue ? I mean how u know mysql is not installed?

    ReplyDelete
    Replies
    1. Ashadullah ShawonAugust 2, 2020 at 10:49 PM

      You can check the status at first by this command systemctl status mariadb. Then you can find the issue.

      Delete
  2. MarioAugust 27, 2020 at 1:39 PM

    Hi, thanks for the solution. I executed the command systemctl status mariadb, but I didn't find the problem with mysql. I searched how install mariadb, but the one reference that i am found was this:

    sudo mysql_secure_installation

    I tried with your steps by steps and it solutionated.
    This line "yum install mysql" why is necessary?
    Sorry I am not too experience in linux.

    ReplyDelete
    Replies
    1. Ashadullah ShawonSeptember 9, 2020 at 11:47 PM

      Because the existing mysql service is corrupted. That's why you need to re install or update it.

      Delete
  3. ZeeshanOctober 14, 2020 at 9:58 PM

    thanks @ASHADULLAH SHAWON

    ReplyDelete
  4. AnonymousDecember 25, 2020 at 4:52 AM

    No need to install anything
    Just locate mysql files, in /usr/bin/ & /etc/ & /var/lib . And then change the ownership of the files to chown mysql:mysql . And then start the service. service mariadb start. It will start successfully.

    ReplyDelete
  5. UnknownJanuary 9, 2021 at 11:18 PM

    journalctl -xe | grep mariadb
    Change ownership of mysql.
    chown -R mysql:mysql /var/lib/mysql
    systemctl enable mariadb
    sytemctl start mariadb
    systemctl status mariadb

    ReplyDelete
    Replies
    1. craftsmanFebruary 28, 2021 at 7:10 AM

      Thanks a lot. I did everything but Icouldnt be success."chown -R mysql:mysql /var/lib/mysql"this command provided success for me..

      Delete
  6. UnknownJune 2, 2021 at 7:10 AM

    Interesting you guys. Thanks for all the contributions

    ReplyDelete
  7. UnknownJune 2, 2021 at 9:36 AM

    I just installed mysql using yum.
    Started and enabled the mariadb service and it worked for me. Thanks Shawonruet

    ReplyDelete
  8. zikozeeJune 17, 2021 at 12:42 PM

    the answer varies.
    for some the below works

    mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
    sudo systemctl start mariadb.servic

    ReplyDelete

Subscribe to: Post Comments ( Atom )