Xtreme Network Solutions

Install MySQL
yum install mysql-server mysql php-mysql

How to configure MySQL
Set the MySQL service to start on boot
chkconfig --levels 235 mysqld on

Start the MySQL service
service mysqld start

Log into MySQL
mysql -u root

Set the root user password for all local domains
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');

Drop the Any user
DROP USER ''@'localhost';
DROP USER ''@'localhost.localdomain';

Exit MySQL
exit

To uninstall Mysql from CentOs.

yum remove mysql-server mysql php-mysql -y

Then remove the mysql folder.
cd /var/lib
rm -rf mysql

Red Hat / RHEL / CentOS / Fedora Linux Instructions

Copy etc/sysconfig/network-scripts/ifcfg-eth0 file as /etc/sysconfig/network-scripts/ifcfg-eth0:0

Open file /etc/sysconfig/network-scripts/ifcfg-eth0:0 using vi text editor:

# vi /etc/sysconfig/network-scripts/ifcfg-eth0:0

Find entry that read as follows:

DEVICE=eth0

Replace with:

DEVICE=eth0:0

Find entry that read as follows:
IPADDR=xxx.xxx.xxx.xxx

Replace it with your actual IP address:
IPADDR=192.168.1.7

At the end your file should like as follows:
DEVICE=eth0:0
IPADDR=192.168.1.7
NETMASK=255.255.255.0
NETWORK=192.168.1.0
ONBOOT=yes
NAME=eth0:0

Open file /etc/sysconfig/network-scripts/ifcfg-eth0 and make sure file does not have a GATEWAY= entry:

# vi /etc/sysconfig/network-scripts/ifcfg-eth0

Find the entry that read as follows:
GATEWAY=your-ip

Remove or comment it out by prefixing # (hash) :
# GATEWAY=192.168.1.254

Save the file. Add the GATEWAY= to your /etc/sysconfig/network:
# vi /etc/sysconfig/network

Append or modify GATEWAY entry:
GATEWAY=192.168.1.254

Save the file. Reboot the system or run the following command:
# ifup eth0:0

OR
# service network restart

Red Hat / CentOS / Fedora Multiple IP address range

You can assign multiple ip address range as follows to eth0:

vi /etc/sysconfig/network-scripts/ifcfg-eth0-range0

Append following code from 202.54.112.120 to 202.54.112.140:
IPADDR_START=202.54.112.120
IPADDR_END=202.54.112.140
CLONENUM_START=0
NETMASK=255.255.255.0

Save and close the file.

/etc/init.d/mysqld start
/etc/init.d/mysqld stop
/etc/init.d/mysqld restart