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 and two queries and using one resultset result in another query. Here is data of Employee table. I want max salary role based..users Employee table Data: Name …
Continue reading “Avoid subquery get records with max value for each group of grouped mySQL results”
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 to do is, without loosing any data we want to upgrade mysql version.
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 becoming more popular these day. Many people are using LAMP for server solutions. Add EPEL-7 to your linux os with latest phpMyadmin. rpm -ivh http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm Now install …
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 can take mysql database backup using cron job and mysqldump command.
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 related php and mysql modules.
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 like big pain. There will be many types of issues with restoring mysql dump to mysql server.
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.
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
[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 running and that the socket: ‘/var/lib/mysql/mysql.sock’ exists! Solved issue: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock Using following command I checked the mysql directory. [root@localhost …
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 db
