Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Tom Rossi
Connecting to MySQL server from Windows [ reply ]  
2006-07-29 19:59
Has anyone written a DEFINITIVE method for connecting your Ruby on Rails
application in a Windows environment to a REMOTE MySQL database?

I keep receiving the error:
"Lost connection to MySQL server during query".

I've seen a lot of discussion about this, but nothing that seems definitive. I've installed a fresh copy of Ruby 1.8.4 and Rails 1.1.4, but cannot get Ruby to connect.

I have confirmed this is related to authentication. If I remove the
password from the MySQL account, I do not receive the error. If I set
the password with either OLD_PASSWORD(' ') or PASSWORD(' ') however, I
receive the error.