# Socket for mysql

**URL:** <https://www.ruby-forum.com/t/socket-for-mysql/90106>\
**Category:** Rails\
**Created:** [March 29, 2006, 6:29pm UTC](https://www.ruby-forum.com/t/socket-for-mysql/90106 "2006-03-29T18:29:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![19roby83](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/b9e5f3/32.png) [@19roby83](https://www.ruby-forum.com/u/19roby83)\
**Post date:** [March 29, 2006, 6:29pm UTC](https://www.ruby-forum.com/t/socket-for-mysql/90106/1 "2006-03-29T18:29:12Z")

</div>

I have mysql running on a different machine. I’ve editted database.yml,  
here’s the entry

development:  
adapter: mysql  
database: cookbook  
username: root  
password: mypassword  
host: posta.rmasonfamily.info

test:  
adapter: mysql  
database: cookbook  
username: root  
password: mypassword  
host: posta.rmasonfamily.info

production:  
adapter: mysql  
database: cookbook  
username: root  
password: mypassword  
host: posta.rmasonfamily.info

problem seems to be that I’m missing the socket entry, This is the  
message I get

Can’t connect to local MySQL server through socket  
'/path/to/your/mysql.sock

but I don’thave a mysql.sock. I do have an empty  
directory /var/lib/mysql.

do I have anything to install?

–  
This message has been scanned for viruses and  
dangerous content by MailScanner, and is  
believed to be clean.

---

<div class="post-metadata">

**Author:** ![19roby83](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/b9e5f3/32.png) [@19roby83](https://www.ruby-forum.com/u/19roby83)\
**Post date:** [March 29, 2006, 6:38pm UTC](https://www.ruby-forum.com/t/socket-for-mysql/90106/2 "2006-03-29T18:38:17Z")

</div>

On Wed, 2006-03-29 at 11:20 -0500, Roberto M. wrote:

> test:  
> password: mypassword
> 
> do I have anything to install?

* * *

assuming that you did ‘gem install mysql’ - no, nothing more to install

you need to specify

server: IP\_OR\_FQDN\_OF\_MYSQL\_SERVER  
port: 3306 # or other port if using non-standard

socket is for localhost (same computer) connections only.

Craig

---

<div class="post-metadata">

**Author:** ![19roby83](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/b9e5f3/32.png) [@19roby83](https://www.ruby-forum.com/u/19roby83)\
**Post date:** [March 29, 2006, 7:08pm UTC](https://www.ruby-forum.com/t/socket-for-mysql/90106/3 "2006-03-29T19:08:32Z")

</div>

No I didn’t do gem install mysql, since I’m running mysql on separate  
server. With that in mind, do I have to do any changes?

On Wed, 2006-03-29 at 09:34 -0700, Craig W. wrote:

> > username: root  
> > directory /var/lib/mysql.  
> > socket is for localhost (same computer) connections only.
> 
> Craig
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

–  
This message has been scanned for viruses and  
dangerous content by MailScanner, and is  
believed to be clean.

---

<div class="post-metadata">

**Author:** ![19roby83](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/b9e5f3/32.png) [@19roby83](https://www.ruby-forum.com/u/19roby83)\
**Post date:** [March 30, 2006, 3:52pm UTC](https://www.ruby-forum.com/t/socket-for-mysql/90106/4 "2006-03-30T15:52:22Z")

</div>

What OS/version are you using?