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
In this guide we will learn, how to install MySQL Server 5.7 on Ubuntu 14.04 LTS. We always recommend our readers to read release notes of every mysql. If you are specifically looking for MySQL Server 5.6 server installation , you can read our previous post. Our Environment Operating System : Ubuntu 14.04 LTS Arch: … Read more
Introduction The post will explain , how to change the tmpdir in MySQL Server on Ubuntu. In the temporary directory for MySQL, generally temporary tables are stored. We generally change its path to make our mysql server performance better. Practical Tested On : It will works for other MySQL and Ubuntu version also.Our testing inventory … 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