# How to change rails mysql socket PATH from /var/run to /var/

**URL:** <https://www.ruby-forum.com/t/how-to-change-rails-mysql-socket-path-from-var-run-to-var/101140>\
**Category:** Rails\
**Created:** [August 3, 2006, 1:18pm UTC](https://www.ruby-forum.com/t/how-to-change-rails-mysql-socket-path-from-var-run-to-var/101140 "2006-08-03T13:18:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jz176](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/eb9ed0/32.png) [@jz176](https://www.ruby-forum.com/u/jz176)\
**Post date:** [August 3, 2006, 1:18pm UTC](https://www.ruby-forum.com/t/how-to-change-rails-mysql-socket-path-from-var-run-to-var/101140/1 "2006-08-03T13:18:12Z")

</div>

i have an app im installing that tries look for mysqld.sock in  
/var/run/mysqld/mysqld.sock and mysql puts it at  
/var/lib/mysql/mysql.sock.  
if i point mysql at /var/run the app works i.e mysqld  
-socket=/var/run/mysqld/mysqld.sock; if i don’t i get an error that goes  
"  
Showing app/views/articles/index.rhtml where line #35 raised:

## No such file or directory - /var/run/mysqld/mysqld.sock". like i said i can get around this “manually” but i’d rather have them looking in the same place by default. so, anyone know where i change that?

View this message in context:  
[http://www.nabble.com/how-to-change-rails-mysql-socket-PATH-from--var-run-to--var-lib--tf2042031.html#a5621414](http://www.nabble.com/how-to-change-rails-mysql-socket-PATH-from--var-run-to--var-lib--tf2042031.html#a5621414)  
Sent from the RubyOnRails Users forum at [Nabble.com](http://Nabble.com).

---

<div class="post-metadata">

**Author:** ![jz176](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/eb9ed0/32.png) [@jz176](https://www.ruby-forum.com/u/jz176)\
**Post date:** [August 3, 2006, 1:20pm UTC](https://www.ruby-forum.com/t/how-to-change-rails-mysql-socket-path-from-var-run-to-var/101140/2 "2006-08-03T13:20:41Z")

</div>

On 8/2/06, jz176 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> i have an app im installing that tries look for mysqld.sock in  
> /var/run/mysqld/mysqld.sock and mysql puts it at /var/lib/mysql/mysql.sock.  
> if i point mysql at /var/run the app works i.e mysqld  
> -socket=/var/run/mysqld/mysqld.sock; if i don’t i get an error that goes "  
> Showing app/views/articles/index.rhtml where line #35 raised:
> 
> No such file or directory - /var/run/mysqld/mysqld.sock". like i said i can  
> get around this “manually” but i’d rather have them looking in the same  
> place by default. so, anyone know where i change that?

In your database.yml file you can add something like this:

socket: \<%= [“/tmp/mysqld.sock”,  
“/tmp/mysql.sock”,  
“/var/run/mysqld/mysqld.sock”,  
“/var/lib/mysql/mysql.sock”].detect{|socket|  
File.exist?(socket)  
} %\>