Installation MySQL v5.1.48 on CentOS release 5.5 (Final)

Before to start, install all the prerequisites for relative platform (to know the version use cat /etc/redhat-release) (you can find rpm on http://rpm.pbone.net/), namely (installation with rpm -ivh):

• cairomm-1.2.4-1.el5.kb.i386.rpm
• glibmm24-2.12.7-1.el5.kb.i386.rpm
• gtkmm24-2.10.8-1.el5.kb.i386.rpm
• libsigc++20-2.0.18-1.el5.kb.i386.rpm 

then (with rpm -ivh MySQL-*):

• MySQL-client-community-5.1.48-1.rhel5.i386.rpm
• MySQL-devel-community-5.1.48-1.rhel5.i386.rpm
• MySQL-embedded-community-5.1.48-1.rhel5.i386.rpm
• MySQL-server-community-5.1.48-1.rhel5.i386.rpm
• MySQL-shared-compat-5.1.48-1.rhel5.i386.rpm

Regarding the successive configuration, please follow steps below:

• cp /usr/share/mysql/my-small.cnf /etc/my.cnf
• vi /etc/my.cnf, and add:

[mysqld]
basedir         = /usr
datadir         = /var/lib/mysql

• uncomment bind-address ip
• give the grants:

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

• check firewall state (iptables on CentOS) executing follow instructions:

iptables -I RH-Firewall-1-INPUT -p tcp --dport 3306 -j ACCEPT