mysql

MySQL

sudo aptitude -y install mysql mysql-server libmysqlclient16-dev libmysqlclient16
mysql_secure_installation

Note that you will be prompted to enter a password for the mysql root user, which will be needed to access the database using the mysql client during later installations.

Add and grant privileges for the rails app user

mysql -u root -p
create user 'rails-app-user'@'%' IDENTIFIED BY 'some-password';
grant all on snort.* to 'rails-app-user' identified by 'some-password';
flush privileges;

To find the unix socket (usually it's /var/run/mysqld/mysqld.sock), or make other configuration changes:

sudo nano /etc/mysql/my.cnf

The value for socket is used in the rails app config/database.yml file to connect to MySQL.

---