Fix 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 get this error:

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

Is there something obvious I'm doing wrong?

Answer 1

You must separate the host from the port number. You might have something like:

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

Answer 2

You can also do the following:

 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 

Answer 3

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

 $ cat config/database.yml $ echo $DATABASE_URL mysql://root:my_password@127.0.0.1:3306/my_db_name 

for Heroku: heroku config: set DATABASE_URL='mysql://root:[e-mail]/my_db_name'

Answer 4

If you have multiple databases for testing and development, this can 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 

Answer 5

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

Getting "Unable to connect to local MySQL server via socket '/var/run/mysqld/mysqld.sock'” error while setting up mysql database for Ruby on Rails application