USE VERSION 5.5, Download locations for MySQL 5.5

wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-shared-compat-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-client-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-server-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-devel-5.5.13-1.rhel5.x86_64.rpm

rpm -ivvh MySQL-shared-compat-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-devel-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-client-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-server-5.5.13-1.rhel5.x86_64.rpm

Note: Run the ln command below (on app servers), else deploy:cold (initial deploy task) will fail to install mysql gem

ln -s /usr/lib64/mysql/libmysqlclient.a /usr/lib64/libmysqlclient.a

/usr/bin/mysqladmin -u root password newpasswd

Run the below as mysql root to create required database, user and privileges, adjust values as required:

create database cb_production DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
grant all on cb_production.* to produser@'localhost' identified by 'prodpswd';
grant all on cb_production.* to produser@'websrvr_IP_or_NAME' identified by 'prodpswd';