This is quite alarming situation in infrastructure when we are not able to login as root in Database server. Database servers are very crucial and it should be very carefully managed. But sometimes there are unwanted situation when we can encounter such problems. Today, while working on my POC setup I also encountered this problem … Read more
Recently I got the system which has MySQL server version 5.1 was running. It was good chance for me to reproduce the issue and show practical answer on question asked on stackoverflow. Operating System: CentOS 6.5 Arch : x86_54 Symptom MySQL service failed to start after upgrading from MySQL 5.1 to 5.6 version. Given below … Read more
In this tutorial we will learn, how to install MySQL Server 5.6 on CentOS 7 / RHEL 7 . In our previous post, we have installed MySQL Server 5.6 on CentOS 6.x/RHEL 7.x. In CentOS 7/ RHEL 7 , now MariaDB is introduced as a defualt database. Still many Organisations/Company would like to continue with … Read more
It was time to take backup of mysql database of my server. I run the command mysqldump with some options and found the error, ” mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed and should be repaired when using LOCK TABLES ” I have seen this error before but not written on this … Read more
In this practical we will learn, how to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr ).At the time of writing this post, MySQL Server has 5.6 version as stable release (release date – 11 April 2014). MySQL is a open source relational database management system (RDBMS). It is popularly used in … Read more
In this post ,I am sharing the error message ” Another MySQL daemon already running with the same unix socket “. The error found in our own sharadchhetri.com blog while restarting the MySQL server.It is at 6:55 PM IST,I noticed the weird error message on blog,”Error establishing a database connection”.I log into the server and … Read more