Re: MySQL and Ruby on Windows

[Z. K.]

I figured it out after many frustrating hours and a lot of time spent searching the Internet.

To install the gem I used this command

gem install --no-rdoc --no-ri mysql -- --with-mysql-dir="C:\Program Files\MySQL\MySQL Server 5.1\my.ini"

Then I getting a no access allowed for root with password = yes. So, I removed the password on root and now it seems to work though I have not yet tried to write to the database, but if I create a controller like

script/generate controller Hello index

and access localhost:3000/hello, the default page comes up as it should which it would not do when the mysql gem was not installed properly. Now if only I could figure out how to get rails to access my MySQL database when the root user has a password, I would be doing great. At least for now, I have it working somewhat.

Z.K.