Install MySql On Linux

You can download MySQL package from http://dev.mysql.com/downloads/

Install Mysql On Linux: Please run below commands on linux terminal.

1-Yum installetion process

         yum install mysql

         yum install mysql-server

         yum install mysql-client

         yum install mysql-devel

2-RPM installetion process

         rpm -ivh mysql-FILENAME.rpm

         rpm -ivh mysql-server-FILENAME.rpm

         rpm -ivh mysql-client

         rpm -ivh mysql-devel

Start Mysql On & OFF Lnux

         chkconfig mysql on

         chkconfig mysql off

To See Mysql is installed or not on Linux machine

         rpm -q mysql (or) rpm -qa/grep

Uninstalle Mysql

         rpm -e mysql

After installation check once again whether the mysql server is installed or not by using  

    rpm –qa|grep mysql command

Start the service/database MySQL by any of the following two commands 

         /etc/rc.d/init.d/mysqld start 

              or

    service mysqld start

If you want your mysql server should be running at system start up then type the following command.

        chkconfig mysqld on

                

                        After Completion Of Installation You Can Check The Current Status Of MySql

The first task is to assign a password:

             mysqladmin -u root password 'new-password'

Note: the following SQL commands will also work:

Login to your mysql database by typing the following in the command prompt

             mysql –uroot

Once you get login in the mysql prompt type the following commands.

mysql> USE mysql;

mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE

user='root';

mysql> FLUSH PRIVILEGES;