# Rake displays Can't connect local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' **URL:** \ **Category:** Rails\ **Created:** [June 13, 2008, 10:28pm UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434 "2008-06-13T22:28:01Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 13, 2008, 10:28pm UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/1 "2008-06-13T22:28:01Z")
i have a small problem every time i run “rake db:migrate” it shows me an error Can’t connect local MySQL server through socket ‘/var/run/mysqld/ mysqld.sock’ (2)’ can somebody help me? ---
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 14, 2008, 12:43pm UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/2 "2008-06-14T12:43:23Z")
hi its possible that either the socket is already in use or the the path for the socket is false… these r the only 2 possiblities i guess thanks Dhaval P. Software Engineer > **[RailsHouse : Ruby on Rails Development & Consulting, Waterloo, Canada](https://railshouse.com)** > > RailsHouse is Waterloo, Ontario based Ruby on Rails Consultancy firm which provides RoR Development, Migration, Staffing, Maintenace and Support Services sales(AT)railshouse(DOT)com ---
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 15, 2008, 11:40am UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/3 "2008-06-15T11:40:32Z")
Thanks for replying, What you said is actually very usefull because i didn’t know why this could be happening, can you give me any tip of how i could solve the problem? On Jun 14, 3:43 am, Dhaval P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 15, 2008, 11:57am UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/4 "2008-06-15T11:57:02Z")
On Jun 15, 8:27 am, RoR\_Nb [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Do you have any idea how i can start soliving this problem? > > On Jun 13, 1:26 pm, RoR\_Nb [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > > i have a small problem every time i run “rake db:migrate” it shows me > > an error > > > Can’t connect local MySQL server through socket ‘/var/run/mysqld/ > > mysqld.sock’ (2)’ Assuming that mysql is actually installed and running, check that what you’ve got in database.yml (in the socket parameter) matches what’s in /etc/my.cnf If database.yml doesn’t specify the socket then it’s probably falling back on some default, so set it to whatever is in my.cnf Fred ---
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 15, 2008, 11:41am UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/5 "2008-06-15T11:41:43Z")
Do you have any idea how i can start soliving this problem? ---
**Author:** ![RoR\_Nb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@RoR\_Nb](https://www.ruby-forum.com/u/RoR_Nb)\ **Post date:** [June 15, 2008, 12:18pm UTC](https://www.ruby-forum.com/t/rake-displays-cant-connect-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/140434/6 "2008-06-15T12:18:11Z")
Awesome, thanks it’s working now, I specified the socket and it’s working fine On Jun 15, 2:56 am, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)