# Cannot logon to mysql

**URL:** <https://www.ruby-forum.com/t/cannot-logon-to-mysql/50769>\
**Category:** Rails\
**Created:** [December 21, 2005, 12:46am UTC](https://www.ruby-forum.com/t/cannot-logon-to-mysql/50769 "2005-12-21T00:46:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Zitowsky](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b5ac83/32.png) [@Robert\_Zitowsky](https://www.ruby-forum.com/u/Robert_Zitowsky)\
**Post date:** [December 21, 2005, 12:46am UTC](https://www.ruby-forum.com/t/cannot-logon-to-mysql/50769/1 "2005-12-21T00:46:34Z")

</div>

I was trying to work through this tutorial last night at home using  
rails 1.0.0.  
[Radar – O’Reilly](http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html?page=2). I got  
up to creating the cookbook database and I needed to log into mysql. On  
the connection tab, I did not know what to put for server. I tried  
127.0.0.1, port 3306, direct connection, username = root, no password.  
Here is my database.yml file. Thanks.

Robert Zitowsky

---

<div class="post-metadata">

**Author:** ![Robert\_Zitowsky](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b5ac83/32.png) [@Robert\_Zitowsky](https://www.ruby-forum.com/u/Robert_Zitowsky)\
**Post date:** [December 21, 2005, 2:49am UTC](https://www.ruby-forum.com/t/cannot-logon-to-mysql/50769/2 "2005-12-21T02:49:56Z")

</div>

Sorry, the later example should be:

development:  
adapter: mysql  
database: rails\_development  
username: root  
password:  
socket: /tmp/mysql.sock

---

<div class="post-metadata">

**Author:** ![Robert\_Zitowsky](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b5ac83/32.png) [@Robert\_Zitowsky](https://www.ruby-forum.com/u/Robert_Zitowsky)\
**Post date:** [December 21, 2005, 2:46am UTC](https://www.ruby-forum.com/t/cannot-logon-to-mysql/50769/3 "2005-12-21T02:46:55Z")

</div>

You probably want something like socket: /tmp/mysql.sock or host:  
localhost to connect to mysql running on your local machine in your  
database.yml file:

development:  
adapter: mysql  
database: rails\_development  
host: localhost  
username: root  
password:

- or -

development:  
adapter: mysql  
database: rails\_development  
username: root  
password:  
socket: /path/to/your/mysql.sock