Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on linux

First, to find your socket file:

mysqladmin variables | grep socket

        

          
        
        
        

          

          AI 代码解读
        
      
      

For me, this gives:

| socket                                            | /tmp/mysql.sock                                                                                                        |

        

          
        
        
        

          

          AI 代码解读
        
      
      

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

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

        

          
        
        
        

          

          AI 代码解读