Installing and Configuring MySql on Red hat Linux 5

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

A. 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