MYSSQL on amazon ec2

yum install mysql mysql-server mysql-libs 
service mysqld start
chkconfig --levels 235 mysqld on
mysql_secure_installation

setting to load on boot (as service):

$> chkconfig --level 235 mysqld on

Create the database and user:

mysql -u root -p

create database smifr_prod

grant all privileges on smifr_prod.* to 'smifr'@'localhost' identified by 'thepass';

Gem for mysql : mysql2 , support utf8 , install :

gem install mysql2 -- --with-mysql-dir=/usr/bin --with-mysql-include=/usr/include/mysql --with-mysql-lib=/usr/lib64/mysql --with-mysql-config=/usr/bin/mysql_config