Rails make database mysql

Question

I'm using Rails 3, and Ubuntu. I want to change the default Rails SQLite3 into a mysql database. I ran these commands:

sudo apt-get install mysql-server mysql-client libmysqlclient15-dev
sudo apt-get install libmysql-ruby1.8

These were successful. Then I did this in the gemfile

#gem 'sqlite3'
gem 'mysql'

This worked, now, what else should I do to complete the MySQL setup. I know for one the database.yml needs to change, but how does it need to look for Ubuntu and how do I fill in the parameters?

Mathieu Mahé · Accepted Answer · 2011-11-13 16:00:46Z

2

Your config/database.yml must look like :

base: &base
  adapter: mysql
  username: YourUserName
  password: YourPassword
  host: localhost
  encoding: utf8
  pool: 5
  timeout: 5000
development:
  database: YourApp_dev
  <<: *base
test:
  database: YourApp_test
  <<: *base
production:
  database: YourApp_prod
  <<: *base

answered Nov 13, 2011 at 16:00

Mathieu Mahé

2,7443 gold badges37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

jack Over a year ago

is user, my username for my ubuntu machine when im logging on? Is password my password that i chose when i installed the mysql server?

Mathieu Mahé Over a year ago

The username and the password must be the ones you use to log to your mysql server

Michael Durrant Over a year ago

No, they are your mysql user credentials. not OS specific

Michael Durrant Over a year ago

there are options to set them and have them match your login, please see the mysql site to read up on the info for this

jack Over a year ago

I was never prompted to make a username, but i was for a password when installing the server. How do i retrieve the user

|

Jeff Ancel · Accepted Answer · 2011-11-13 16:03:23Z

0

Is the database on the same host?

You need to log into mysql, set a user, create a database. If the database is on a database server, outside of the application server, then you will need to make accessible from the net.

http://www.slac.stanford.edu/BFROOT/www/Computing/Online/Databases/CfgDB/CfgDB-MySQL-Setup.html

After you're done setting up the database (not just installing it), then you're database.yml files need to be modified per the above.

answered Nov 13, 2011 at 16:03

Jeff Ancel

3,1113 gold badges34 silver badges39 bronze badges

Collectives™ on Stack Overflow

Rails make database mysql

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related