MySQL installation problems

[Dean Richardson]

After numerous problems getting rake spec to work after upgrading to Rails 3.2 (including a mysql2 related-error and the dreaded 193: %1 is not a valid win32 command") I decided to delete my entire RailsInstaller installation and reinstall. Now I can't get mysql to work.

Details:

Windows 7

Ruby 1.9.3-p392

Rails 3.2.13

I've tried following the recommended blog post: http://blog.mmediasys.com/2011/07/07/installing-mysql-on-windows-7-x64-and-using-ruby-with-it/ to install the mysql2 gem  -v 0.3.11 with the parameters pointing to the headers and libraries listed in the  blog post. But attempting to get mysql to work led to either a "can't connect to localhost" error or something else that I've frankly forgotten (that was about six hours ago now :)

Given these problems, decided to eliminate my existing mysql installation and follow the clean install directions in the blog post. I first tried this with the latest version of mysql 5.6, but I got the same "can't connect" errors as before. I've since tried the exact mysql version mentioned in the blog post (5.5.13) and a later 5.5 version, all with no success. Either the installation can't start mysql during the config phase, or something else fails. I'm using the default installation directories so that my.ini is pointed to the right places.

Oh, also, I have the host set to 127.0.0.1 in database.yml, since that seems to have been mentioned frequently in other related posts in this group's archives.

I'd be grateful for any assistance you might be able to offer.

Thanks very much,

Dean Richardson

[Luis Lavena]

Hello Dean,

Sorry for the late response, but just saw your post.

Have you tried using the MySQL console? (it is part of the MySQL installation) as shown in the installation instructions of the blog page

Does it work?

If so, that means mysql does work, and we need now to determine if username/password are correct.

Can you verify config/database.yml for the username and password?

--
You received this message because you are subscribed to the Google Groups "RailsInstaller" group.
To unsubscribe from this group and stop receiving emails from it, send an email to railsinstalle...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Luis Lavena
AREA 17
-
Perfection in design is achieved not when there is nothing more to add,
but rather when there is nothing more to take away.
Antoine de Saint-Exupéry