Correct MySQL configuration for Ruby on Rails Database.yml file

Question

I have this configuration:

development:
  adapter: mysql2
  encoding: utf8
  database: my_db_name
  username: root
  password: my_password
  host: mysql://127.0.0.1:3306

And I am getting this error:

Unknown MySQL server host 'mysql://127.0.0.1:3306' (1)

Is there something obvious that I am doing incorrectly?

Amokrane Chentir · Accepted Answer · 2011-05-03 16:05:32Z

211

You should separate the host from the port number. You could have something, like:

development:
  adapter: mysql2
  encoding: utf8
  database: my_db_name
  username: root
  password: my_password
  host: 127.0.0.1
  port: 3306

edited May 3, 2011 at 16:05

answered May 3, 2011 at 15:59

Amokrane Chentir

30.5k38 gold badges117 silver badges159 bronze badges

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

3 Comments

Adrian C. Over a year ago

and host can't be host: localhost

Feliks Montez Over a year ago

For security reasons, it's generally considered bad practice to use root as the production database user. To set up a dedicated user for your rails app, see the MySQL docs about user creation.

Feliks Montez Over a year ago

Also for security reasons (if you're using version control) you should not store your database password in database.yml. Instead, do what user3118220 did and get it from your environment: password: ENV['MY_RAILS_APP_DB_PASSWORD'].

pangpang · Accepted Answer · 2016-01-08 07:29:04Z

23

You also can do like this:

default: &default
  adapter: mysql2
  encoding: utf8
  username: root
  password:
  host: 127.0.0.1
  port: 3306

development:
  <<: *default
  database: development_db_name

test:
  <<: *default
  database: test_db_name

production:
  <<: *default
  database: production_db_name

edited Jan 8, 2016 at 7:29

answered Jan 8, 2016 at 6:25

pangpang

8,86915 gold badges67 silver badges99 bronze badges

Comments

Stephen Rauch · Accepted Answer · 2018-03-28 01:00:03Z

4

Use 'utf8mb4' as encoding to cover all unicode (including emojis)

default: &default
  adapter: mysql2
  encoding: utf8mb4
  collation: utf8mb4_bin
  username: <%= ENV.fetch("MYSQL_USERNAME") %>
  password: <%= ENV.fetch("MYSQL_PASSWORD") %>
  host:     <%= ENV.fetch("MYSQL_HOST") %>

(Reference1) (Reference2)

edited Mar 28, 2018 at 1:00

Stephen Rauch♦

50.1k32 gold badges119 silver badges143 bronze badges

answered Mar 28, 2018 at 0:40

botibs

813 bronze badges

Comments

user3118220 · Accepted Answer · 2015-03-24 04:30:22Z

2

If you can have an empty config/database.yml file then define ENV['DATABASE_URL'] variable, then It will work

$ cat config/database.yml
 
$ echo $DATABASE_URL
mysql://root:[email protected]:3306/my_db_name

for Heroku: heroku config:set DATABASE_URL='mysql://root:[email protected]/my_db_name'

answered Mar 24, 2015 at 4:30

user3118220

1,46812 silver badges16 bronze badges

Comments

Rick · Accepted Answer · 2015-08-26 23:47:25Z

0

If you have multiple databases for testing and development this might help

development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: DBNAME
  pool: 5
  username: usr
  password: paswd
  shost: localhost
test:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: DBNAME
  pool: 5
  username: usr
  password: paswd
  shost: localhost
production:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: DBNAME
  pool: 5
  username: usr
  password: paswd
  shost: localhost

edited Aug 26, 2015 at 23:47

answered Oct 30, 2014 at 6:33

Rick

13.6k3 gold badges46 silver badges42 bronze badges

1 Comment

konyak Over a year ago

how is shost different than host?

Community · Accepted Answer · 2017-05-23 12:18:04Z

0

None of these anwers worked for me, I found Werner Bihl's answer that fixed the problem.

Getting "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" error when setting up mysql database for Ruby on Rails app

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Nov 2, 2016 at 17:26

s_p

4,6788 gold badges60 silver badges95 bronze badges

Collectives™ on Stack Overflow

Correct MySQL configuration for Ruby on Rails Database.yml file

6 Answers 6

3 Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related