Category Archives: MySQL

MySQL

Mysql useful production query script

How to start MySQL # service mysqld start # /etc/init.d/mysqld start How to set root password in MySQL # mysqladmin password “redhat” How to Login in Mysql # mysql -u root -predhat mysql> How to change root and Users password mysql> UPDATE mysql.user SET Password=PASSWORD(‘redhat123′) WHERE User=’root’; How to Create database mysql> create database DB-NAME; How to Check… Read More »

MYSQL installation step on Linux using RPM packages

MySQL is one of the best RDBMS being used for developing web-based software applications. It’s very easy to learn and maintained. The purpose of writing this tutorials will help you to quick start with Mysql Download Mysql tar file from valid sources. The recommended way to install MySQL on a Linux system is via RPM Now, follow the… Read More »

Find the top 2 Candidate who have the highest vote

Try this query for getting the highest two records.