RHEL install and configure MySQL database

How do I install MySQL database server under Redhat Enterprise Linux 5?

You have two choices:
a) Install MySQL package using RHN
b) Install MySQL rpm from CD/DVD

Red hat Enterprise Install Mysql Database server

The best way to install mysql package is to use RHN (Red Hat Network):

Redhat Enterprise Linux - RHEL 5 MySQL installation

Type the following command as root user:
# yum install mysql-server mysql
Note above yum command works with Fedora core and Cent OS Linux.

Redhat Enterprise Linux - RHEL 4/3 MySQL installation

Type the following command as root user:
# up2date mysql-server mysql

Start MySQL Service

To start mysql server type the following command:
# chkconfig mysqld on
# /etc/init.d/mysqld start

Setup mysql root password

Type the following command to setup a password for root user:
# mysqladmin -u root password NEWPASSWORD

Test mysql connectivity

Type the following command to connect to MySQL server:
$ mysql -u root -p