Matthew Berman Matthew Berman - 1 year ago 83
MySQL Question

Can't connect to MySQL server on ''

I am trying to clone a repo and run it on my local machine. I don't have a DB created and I am trying to manually create my database.yml file (my first time doing this). I am not quite sure what i'm doing and keep getting errors about connecting to the MySql server. Here's my database.yml file:

adapter: mysql
database: db/app_development
username: root

I also tried localhost instead of, both give me errors when trying to create the db by doing 'bundle exec rake db:create' ...i get this error:

Can't connect to MySQL server on '' (61)
Couldn't create database for {"username"=>"root", "adapter"=>"mysql", "database"=>"db/app_development", "host"=>"", "password"=>nil}, charset: utf8, collation: utf8_unicode_ci

I know i'm doing something wrong but I can't quite figure out what it is. Do I need to start the mysql server or something?

This is the output when I run mysqld_safe:

120111 20:35:39 mysqld_safe Logging to '/usr/local/var/mysql/Matthew-Bermans-MacBook-Air.local.err'.
120111 20:35:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
120111 20:35:41 mysqld_safe mysqld from pid file /usr/local/var/mysql/ ended

Answer Source


  adapter: mysql
  database: app_development
  username: root
  socket: /var/lib/mysql/mysql.sock

Then do your rake db:create to create it from rails.
in mysql do create database db_name
and then the above code for :development will let you use it.

Update: Matthew first needs to get mySQL installed on his (Mac) machine.
I directed him to

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download