Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Question

I am trying to perform a migration in Ruby on Rails 4, and I am running into the following error:

********-C02MGBVJFD57:myapp michaelsutyak$ bundle exec rake db:migrate
rake aborted!
Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Any ideas why this is happening?

CGDS · Accepted Answer · 2014-08-06 23:00:41Z

22

First verify that you have indeed run mysql.server start, as tmp/mysql.sock is generated on startup (as is tradition). If you are still encountering difficulties, run mysqladmin variables | grep socket and update the information in your database.yml accordingly

answered Aug 6, 2014 at 23:00

CGDS

2211 silver badge2 bronze badges

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

2 Comments

BD Tinsley Over a year ago

ah the ol' "make sure the server is running" trick, eh? worked like a charm!

Ivor Scott Over a year ago

To find the socket path that is actually in use you may need to do it like this: mysqladmin -u root variables | grep socket

Collectives™ on Stack Overflow

Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related