How do you get the rows that contain the max value for each grouped set. I faced issue many times but I ended with following solution of subquery Read More
In this tutorial we will show steps to upgrade to mysql 5.7 in linux. We have many server which are running on old mysql versions. What we want Read More
In this tutorial we are going to tell you how to install php mysql apache on centos 7 with very easy and simple steps and guide. LAMP is Read More
Taking backups is like day to day task for every system admins. In this turotials we will tell you to take mysqldump and send email through linux system. We Read More
In the article we will tell you to install apache 2.4, php 5.5 and mysql on centos 6/7 with this we will guide you about installing phpmyadmin and Read More
I am taking daily mysqldump on my servers. I am always tring to speed up MySQL restore and backup using some tricks. Many times restoring mysql backup is Read More
One day I faced issue with mysql.sock file. I found Can't connect to local MySQL error. I solved the issue with following commands. Read More
Mysql tutorial for, mysql create user and grant all privileges on database. When we do fresh installation of Mysql we got the root user without any password Read More
[root@localhost ~]# mysqladmin -u root shutdown mysqladmin: connect to server at ‘localhost’ failed error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)’ Check that mysqld is Read More
Some time back I accidentally deleted mysql root user. Then when checked mysql then mysql is not accessible to me from root user. I have trick to restore Read More