Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX

by

First, to find your socket file:

mysqladmin variables | grep socket

For me, this gives:

| socket                                            | /tmp/mysql.sock                                                                                                        |

Then, add a line to your config/database.yml:

development:
  adapter: mysql2
  host: localhost
  username: root
  password: xxxx
  database: xxxx
  socket: /tmp/mysql.sock

More Related Contents:

  1. Location of my.cnf file on macOS
  2. brew install mysql on macOS
  3. Setting the MySQL root user password on OS X
  4. MySQL user DB does not have password columns – Installing MySQL on OSX
  5. Rails 3 ActiveRecord: Order by count on association
  6. How do you uninstall MySQL from Mac OS X?
  7. Restoring deleted ‘root’ user and password for MySQL
  8. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  9. MySQL Install: ERROR: Failed to build gem native extension
  10. libmysqlclient15-dev on macs?
  11. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  12. Connect to Docker MySQL container from localhost?
  13. How do you stop MySQL on a Mac OS install?
  14. Reset MySQL root password using ALTER USER statement after install on Mac
  15. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  16. PID error on mysql.server start?
  17. How to start MySQL server from command line on Mac OS Lion?
  18. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  19. OSX ld: library not found for -lssl
  20. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  21. MySQL data directory location
  22. MySQL – Get row number on select
  23. How to use GROUP_CONCAT in a CONCAT in MySQL
  24. MySQL query / clause execution order
  25. Operand Should Contain 1 Column – MySQL NOT IN
  26. On duplicate key ignore? [duplicate]
  27. Implementing a hierarchical data structure in a database
  28. MySQL date format
  29. MySQL Group By Hours
  30. RMySQL dbWriteTable with field.types

Leave a Comment