Database

Steps Before Shutting Down MySQL Server

MySQL shutdown/restart is required when you applying non dynamic config changes, database maintenance, upgrade database etc. In this tutorial I am going to describe some basic steps before shutting down MySQL server.

Read More

How To Reinstall MySQL Server v5.x On Linux

Question: I would like to delete my old MySQL server because its database has been corrupted due to which I want to reinstall MySQL database server. How can I reinstall fresh full

Read More

Automated Installation and Configurations – Apache/Nginx, MySQL ,PHP or PHP-FPM on Linux/UNIX

In this tutorial I am going to explain how we can install Apache/Nginx, MySQL , PHP or PHP-FPM automatically on Linux system. To do this we will use a script. This script will ask about

Read More

How to Find Table & Database Size in MySQL

As a database administrator you need to know the size of each MySQL table to optimise them. To make some free space in your disk. You can do this checking the manually

Read More

How to Install Only MySQL Client on CentOS, Redhat, Fedora and Ubuntu

Question:- I have MySQL database server running on CentOS and I would like to install only MySQL Client without installing MySQL server on the server. Do you have any idea how  I

Read More

Change MySQL default Data Directory to New Location in Linux

When we install MySQL on Linux the default MySQL database created under /var/lib/mysql directory. If your database is small this might be OK because it does not take much space. But for

Read More

Check and Update max_connections value to fix MySQL Error: Too many connections

As a database administrator some time I have noticed on issue MySQL Error: Too many connections on database server. Which indicates that all available connections are in use by other clients. It

Read More

Why you should upgrade your open source database software?

As a database administrator, one should know the importance of upgrade of open source database software.Today we are using various open source database software like MySQL, Maria-db, Nosql, Mongodb. Among all MySQL

Read More

MySQL Basic Commands For Database Administrator

As a database administrator and system admin one should know some specifics commands. So, I am sharing some of basic commands.These commands will also helpful for beginners as well as who are

Read More

Adding Multiple MySQL Database Server In Single PhpMyAdmin Installation

Hi Friends, In my previous article I explained How to configure and install PhpMyAdmin. In previous post we saw PhpMyAdmin allows only to connect to localhost MySQL server because of it’s default

Read More