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 MySQL server again? Answer: If your database has been corrupted and want to reinstall mysql server, you can easily do this, just follow […]
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 virtual host domain name during installation and during MySQL database installation it will ask about MySQL root password, New database name, new username […]
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 the size of each table and database in the MySQL data directory, by default you can find it on “/var/lib/mysql/” location. But using […]
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 can install only MySQL Client on CentOS and Linux based system. Answer :- Yes, It is very easy to install only MySQL client […]
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 larger database I will suggest to change the default data directory of MySQL to different locations or you can also use separate hard […]
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 happens when server reach the limit of max_connections. Most of time I have noticed this happens when either bugs in applications not closing […]
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 is most popular open source database software.So, here i am explaining five importance of upgrade. Top Five Reasons To Upgrade Open Source Database […]
Basic Mysql 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 early DBA’s in his carrier.
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 configuration. Suppose if we have multiple database so it is very time consuming and difficult task to install phpMyAdmin and manage it. It […]
Hello Friends, In this article I am going to explain how we can install MySQL 5.6 server in Centos 6.X and Redhat 6.x using yum command. System Server : CentOS release 6.7 (Final) Architecture : i686 i386 GNU/Linux Follow the below steps to install MySQL 5.6 server using yum command.