Steps which I am sharing with you has worked for me and I hope that would help you in connecting your mysql database to your ruby on rails application.
Step 1. Open terminal and execute this command : sudo apt-get install mysql-server libmysqlclient-dev libmysql-ruby
Done! Now create database using rake:db create and enjoy!
Step 1. Open terminal and execute this command : sudo apt-get install mysql-server libmysqlclient-dev libmysql-ruby
Step2. Change Directory to your application folder ,like cd /rails_projects/cg
Step3. Now ,install mysql gem : sudo gem install mysql
Step4. Configure your database.yml : sudo gedit configure/database.yml
Step5.Paste this code:
development: adapter: mysql encoding: utf8 database: yourdatabase_development pool: 5 username: root password: yourpassword test: adapter: mysql encoding: utf8 database: yourdatabase_test pool: 5 username: root password: yourpassword production: adapter: mysql encoding: utf8 database: yourdatabase_production pool: 5 username: root password: yourpasswod
Done! Now create database using rake:db create and enjoy!
