Convert Rails SQLlite to use MySQL

  1. In Gemfile: Replace gem 'sqllite3' to gem 'mysql2'

  2. Change the database configuration config/database.yml:

``` default: &default adapter: mysql2 encoding: utf8 pool: 5 timeout: 5000 username: password: socket: /var/run/mysqld/mysqld.sock

development: «: *default database: apiflysaa_dev ```

Check Socket

mysqladmin -u root -p variables | grep socket

Giving Permissions

GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';

Source: * Check Mysql Socket * MySQL Permissions * Convert Rails to use SQLLite to MySQL