Socket for mysql


#1

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.


#2

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


#3

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


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


#4

What OS/version are you using?