How to setup mysql on Linux

As mysql is widely used database since its open source ,most reliable & user friendly also. So that’s why I am included this topic about “How to setup mysql on Linux”.

1. Firstly to check whether mysql is installed or not on your system give command mysql. If the system responds with below error then mysql is not installed!!!!

[root@kalwa1 tmp]# mysql -bash: /usr/bin/mysql: No such file or directory
 [root@kalwa1 tmp]# 

If not proceed to step 2.

2. Now install mysql using yum. (Note you need to setup yum repository to work below command. )

[root@kalwa1 tmp]# yum install mysql*
Below is the snippet from the command output.
Running Transaction
Installing : mysql-libs-5.1.52-1.el6_0.1.x86_64 1/9
Installing : mysql-5.1.52-1.el6_0.1.x86_64 2/9
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 3/9
Installing : mysql-server-5.1.52-1.el6_0.1.x86_64 4/9
Installing : mysql-test-5.1.52-1.el6_0.1.x86_64 5/9
Installing : mysql-bench-5.1.52-1.el6_0.1.x86_64 6/9
Installing : mysql-devel-5.1.52-1.el6_0.1.x86_64 7/9
Installing : mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 8/9
Installing : 1:mysql-connector-java-5.1.12-2.el6.x86_64 9/9
Installed products updated.
Installed:
mysql.x86_64 0:5.1.52-1.el6_0.1
mysql-bench.x86_64 0:5.1.52-1.el6_0.1
mysql-connector-java.x86_64 1:5.1.12-2.el6 
mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6
mysql-devel.x86_64 0:5.1.52-1.el6_0.1 
mysql-libs.x86_64 0:5.1.52-1.el6_0.1 
mysql-server.x86_64 0:5.1.52-1.el6_0.1 
mysql-test.x86_64 0:5.1.52-1.el6_0.1
Dependency Installed:
 perl-DBD-MySQL.x86_64 0:4.013-3.el6
Complete!