Differences in database.yml in rails application,host vs socket

Question

What is the difference between following code in accessing mysql by host,socket ?

                    adapter: mysql2  
                    database: chart_development  
                    username: root
                    password: root                      
                    socket: /var/lib/mysql/mysql.sock  
                           vs
                    adapter: mysql2  
                    database: chart_development  
                    username: root
                    password: root                      
                    host: localhost

How to make the rails to work for both things? "host: localhost" is not working for me.Earlier it work fine.so,I am using "socket: /var/lib/mysql/mysql.sock" right now.

score 2 · Accepted Answer · answered Oct 03 '12 at 12:04

2

Change

host: localhost

to

host: 127.0.0.1

answered Oct 03 '12 at 12:04

Salil

46,566
21
122
156

In which file you mean to say,sql configurations? or in rails(database.yml)? – kanna Oct 03 '12 at 12:06

Differences in database.yml in rails application,host vs socket

1 Answers1