Ripping my hair out: MySQL5.5, Rails3, Win7

Page 1 of 1

8 Replies - 1528 Views - Last Post: 20 June 2012 - 02:37 PM

#1 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 09:42 AM

I don't even know how to begin. I've literally spent over 20 hours trying to figure this out, and im on the edge of just using sqlite3 instead.

Now, I'm new to RoR and MySQL, but I swear I've looked in every single nook and cranny to find a solution to this problem, and I have a feeling it's solution is going to be something either very simple, or no one will know what to do.

What I'm doing is following an example in a book, where I am supposed to issue the command 
rake db:migrate


I have MySQL, with a created database called 
myblog_dev


MySQL service IS running.
I CAN access it through the root with my password.
But every time I issue that rake command it tells me:

C:\Sites\myblog>rake db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
[b]** Execute db:migrate
rake aborted!
Can't connect to MySQL server on 'localhost' (10061)[/b]
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/l
ib/mysql2/client.rb:44:in `connect'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/l
ib/mysql2/client.rb:44:in `initialize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/mysql2_adapter.rb:16:in `new'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/mysql2_adapter.rb:16:in `mysql2_connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:277:in `new_connection
'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:287:in `checkout_new_c
onnection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:235:in `block (2 level
s) in checkout'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:230:in `loop'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:230:in `block in check
out'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:229:in `checkout'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:95:in `connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:374:in `retrieve_conne
ction'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_specification.rb:168:in `retri
eve_connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_specification.rb:142:in `conne
ction'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:646:in `initialize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:554:in `new'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:554:in `up'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:535:in `migrate'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/railties/databases.rake:153:in `block (2 levels) in <top (required)>'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:205:in `call'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:205:in `block in execute'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:200:in `each'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:200:in `execute'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:158:in `block in invoke_with_call_chain'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:151:in `invoke_with_call_chain'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:144:in `invoke'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:116:in `invoke_task'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `block (2 levels) in top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `each'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `block in top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:133:in `standard_exception_handling'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:88:in `top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:66:in `block in run'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:133:in `standard_exception_handling'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:63:in `run'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/bin/rake:33:in
 `<top (required)>'
C:/RailsInstaller/Ruby1.9.3/bin/rake:19:in `load'
C:/RailsInstaller/Ruby1.9.3/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate


Since it passes through config, that makes me think my database.yml file is fine. But if it can't connect to localhost then I guess it's not? Here it is:

development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: myblog_dev
  pool: 5
  username: root
  password: 128dh47db7
  host: localhost
  port: 3306

test:
  adapter: mysql
  encoding: utf8
  reconnect: false
  database: myblog_dev
  pool: 5
  username: root
  password: 128dh47db7
  host: localhost
  port: 3306

production:
  adapter: mysql
  encoding: utf8
  reconnect: false
  database: myblog_dev
  pool: 5
  username: root
  password: 128dh47db7
  host: localhost
  port: 3306


MySQL is by default, set to port 3306, and I made sure that it was set to that port when I installed it for a second time. That was before these codes though, so these codes are accurate for what's going on right now.

I have all the gems for rails, and mysql installed. And my Gemfile for the project 
myblog
looks like this:

source 'https://rubygems.org'

gem 'rails', '3.2.1'

# Bundle edge Rails instead:
# gem 'rails', :git => 'git://github.com/rails/rails.git'

gem 'sqlite3'
gem 'mysql2'
gem 'eventmachine', '> 1.0.0.beta.4.1'
gem 'thin'


# Gems used only for assets and not required
# in production environments by default.
group :assets do
  gem 'sass-rails',   '~> 3.2.3'
  gem 'coffee-rails', '~> 3.2.1'

  # See https://github.com/sstephenson/execjs#readme for more supported runtimes
  # gem 'therubyracer'

  gem 'uglifier', '>= 1.0.3'
end

gem 'jquery-rails'


Is there a Gemfile I'm supposed to edit thats not my project 'myblogs's Gemfile?

It's not MySQL because I can connect to my database just fine.

mysql> connect myblog_dev
Connection id:    8
Current database: myblog_dev


I've also looked over countless forums of people who have had the same problem, but none of their fixes worked for me, or they werent defined because once the person figured it out they didnt detail how they fixed it.

This is extremely frustrating. I know I can just use sqlite3 for dev purposes, but i really wanted to learn how to set up MySQL as soon as I could, so I could get it out of the way.

I havent even been able to write any of my own code yet.

Can anyone please help me? I would be so extremely grateful.

Oh, and i have Ruby 1.9.3

Is This A Good Question/Topic? 0
  • +

Replies To: Ripping my hair out: MySQL5.5, Rails3, Win7

#2 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 5675
  • View blog
  • Posts: 22,537
  • Joined: 23-August 08

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 09:51 AM

Quote

MySQL is by default, set to port 3306, and I made sure that it was set to that port when I installed it for a second time. That was before these codes though, so these codes are accurate for what's going on right now.


Not terribly up on running servers in Windows 7, but is the Windows Firewall configured to allow incoming traffic on 3306?
Was This Post Helpful? 1
  • +
  • -

#3 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 10:04 AM

View PostJackOfAllTrades, on 20 June 2012 - 09:51 AM, said:

Quote

MySQL is by default, set to port 3306, and I made sure that it was set to that port when I installed it for a second time. That was before these codes though, so these codes are accurate for what's going on right now.


Not terribly up on running servers in Windows 7, but is the Windows Firewall configured to allow incoming traffic on 3306?


The first time I went through this, firewall wasnt even up at -all-.

It's up this time though, so I put an inbound rule (exception) into the advanced settings of windows firewall that allows port 3306 through these instructions:

http://maximumpcguid...ws-7s-firewall/


But I still get the same error when trying to do 
rake db:migrate



rake aborted!
Can't connect to MySQL server on 'localhost'

Was This Post Helpful? 0
  • +
  • -

#4 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 10:33 AM

EDIT: I should also mention, I followed instructions here:
http://thirdeye.ibtg...ysql-windows-7/

And put the libmysql.dll in my ruby directory, which fixed an earlier error; but has no affect on this one, obviously.
My rake db:migrate command of course gives me an error.
Was This Post Helpful? 0
  • +
  • -

#5 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 5675
  • View blog
  • Posts: 22,537
  • Joined: 23-August 08

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 10:35 AM

If you open up a command prompt and type "telnet localhost 3306" does MySQL respond?

Another possibility is this: setting up localhost to point to 127.0.0.1
Was This Post Helpful? 1
  • +
  • -

#6 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 11:16 AM

View PostJackOfAllTrades, on 20 June 2012 - 10:35 AM, said:

If you open up a command prompt and type "telnet localhost 3306" does MySQL respond?

Another possibility is this: setting up localhost to point to 127.0.0.1


telnet isnt a command recognized on any command prompt, apparently.
C:\Users\tkk>telnet localhost 3306
'telnet' is not recognized as an internal or external command,
operable program or batch file.



netstat displays some interesting connections though.


C:\Sites\myblog>netstat

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    127.0.0.1:3306         tkk-PC:50025           ESTABLISHED
  TCP    127.0.0.1:50025        tkk-PC:3306            ESTABLISHED
  TCP    127.0.0.1:51408        tkk-PC:51409           ESTABLISHED
  TCP    127.0.0.1:51409        tkk-PC:51408           ESTABLISHED
  TCP    192.168.1.2:1902       cpe-174-107-149-169:1847  ESTABLISHED
  TCP    192.168.1.2:49618      111.221.74.34:40010    ESTABLISHED
  TCP    192.168.1.2:49621      193.120.199.12:12350   ESTABLISHED
  TCP    192.168.1.2:49624      baymsg1020227:https    ESTABLISHED
  TCP    192.168.1.2:49981      channel-hr-12-01-snc7:http  ESTABLISHED
  TCP    192.168.1.2:51058      stackoverflow:http     ESTABLISHED
  TCP    192.168.1.2:51353      ip72-204-6-70:64839    ESTABLISHED
  TCP    192.168.1.2:51741      a23-13-154-37:http     TIME_WAIT
  TCP    192.168.1.2:51749      a184-84-79-139:http    TIME_WAIT
  TCP    192.168.1.2:51750      iad23s05-in-f1:http    TIME_WAIT
  TCP    192.168.1.2:51751      iad23s05-in-f1:http    TIME_WAIT
  TCP    192.168.1.2:51752      a23-13-154-37:http     TIME_WAIT
  TCP    192.168.1.2:51754      www-slb-10-01-prn1:http  TIME_WAIT
  TCP    192.168.1.2:51760      vb-in-f147:https       ESTABLISHED
  TCP    192.168.1.2:51766      vb-in-f147:http        ESTABLISHED
  TCP    192.168.1.2:51767      qa-in-f95:https        ESTABLISHED
  TCP    192.168.1.2:51774      iad23s05-in-f26:http   ESTABLISHED
  TCP    192.168.1.2:51775      iad23s05-in-f25:http   ESTABLISHED
  TCP    192.168.1.2:51778      iad23s05-in-f9:http    ESTABLISHED
  TCP    192.168.1.2:51781      iad23s05-in-f27:http   ESTABLISHED
  TCP    192.168.1.2:51783      a23-66-230-64:http     ESTABLISHED
  TCP    192.168.1.2:51786      iad23s07-in-f26:http   ESTABLISHED
  TCP    192.168.1.2:51788      iad23s07-in-f13:http   ESTABLISHED
  TCP    192.168.1.2:51789      iad23s07-in-f13:http   ESTABLISHED
  TCP    192.168.1.2:51790      iad23s07-in-f13:http   ESTABLISHED
  TCP    192.168.1.2:51791      www-slb-11-08-prn1:http  ESTABLISHED
  TCP    192.168.1.2:51792      iad23s07-in-f3:https   ESTABLISHED
  TCP    192.168.1.2:51793      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51794      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51795      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51796      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51797      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51798      a23-66-230-121:http    ESTABLISHED
  TCP    192.168.1.2:51804      iad23s07-in-f15:https  ESTABLISHED
  TCP    192.168.1.2:51806      iad23s07-in-f4:http    ESTABLISHED
  TCP    192.168.1.2:51807      a23-66-230-19:http     ESTABLISHED
  TCP    192.168.1.2:51808      a23-66-230-177:http    ESTABLISHED
  TCP    192.168.1.2:51813      beacon:http            ESTABLISHED
  TCP    192.168.1.2:51821      a23-66-230-146:http    ESTABLISHED
  TCP    192.168.1.2:51823      a23-66-230-146:http    ESTABLISHED
  TCP    192.168.1.2:51826      a23-66-230-178:http    ESTABLISHED
  TCP    192.168.1.2:51827      a23-66-230-146:http    ESTABLISHED
  TCP    192.168.1.2:51828      a23-66-230-178:http    ESTABLISHED
  TCP    192.168.1.2:51829      a23-66-230-146:http    ESTABLISHED
  TCP    192.168.1.2:51831      178.236.7.13:http      ESTABLISHED
  TCP    192.168.1.2:51832      a23-66-230-185:http    ESTABLISHED
  TCP    192.168.1.2:51833      server-216-137-33-229:http  ESTABLISHED
  TCP    192.168.1.2:51835      server-216-137-33-229:http  ESTABLISHED
  TCP    192.168.1.2:51836      72.21.211.176:http     ESTABLISHED
  TCP    192.168.1.2:51838      www:http               ESTABLISHED
  TCP    192.168.1.2:51839      server-216-137-33-144:http  ESTABLISHED



I couldnt edit the file through the command line like suggested in your link. So I just looked for the file by going through the path it was in.
I opened it with wordpad just to read it (not edit), and the line:
127.0.0.1       localhost


is already there.
Was This Post Helpful? 0
  • +
  • -

#7 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 01:56 PM

UPDATE

With the help of my husband I was able to find this:

http://www.victor-ra...on-windows.aspx

So, I changed the Hosts file. Took out the comment (#) part of the SECOND listing of 127.0.0.1

So there is progress; I now get a different error.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\tkk>edit c:\windows\system32\driver\etc\hosts
'edit' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\tkk>pin localhost
'pin' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\tkk>
C:\Users\tkk>ping localhost

Pinging tkk-PC [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\tkk>


Instead of getting a reply from ::1:, it now correctly replies from 127.0.0.1
AWESOME.
Now the new error in rails:

C:\Sites\myblog>rake db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:migrate
rake aborted!
Access denied for user 'root'@'localhost' (using password: YES)
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/l
ib/mysql2/client.rb:44:in `connect'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/l
ib/mysql2/client.rb:44:in `initialize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/mysql2_adapter.rb:16:in `new'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/mysql2_adapter.rb:16:in `mysql2_connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:277:in `new_connection
'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:287:in `checkout_new_c
onnection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:235:in `block (2 level
s) in checkout'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:230:in `loop'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:230:in `block in check
out'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:229:in `checkout'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:95:in `connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_pool.rb:374:in `retrieve_conne
ction'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_specification.rb:168:in `retri
eve_connection'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/connection_adapters/abstract/connection_specification.rb:142:in `conne
ction'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:646:in `initialize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:554:in `new'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:554:in `up'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/migration.rb:535:in `migrate'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.1/lib/acti
ve_record/railties/databases.rake:153:in `block (2 levels) in <top (required)>'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:205:in `call'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:205:in `block in execute'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:200:in `each'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:200:in `execute'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:158:in `block in invoke_with_call_chain'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:151:in `invoke_with_call_chain'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/task.
rb:144:in `invoke'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:116:in `invoke_task'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `block (2 levels) in top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `each'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:94:in `block in top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:133:in `standard_exception_handling'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:88:in `top_level'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:66:in `block in run'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:133:in `standard_exception_handling'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/lib/rake/appli
cation.rb:63:in `run'
C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/rake-0.9.2.2/bin/rake:33:in
 `<top (required)>'
C:/RailsInstaller/Ruby1.9.3/bin/rake:19:in `load'
C:/RailsInstaller/Ruby1.9.3/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate

C:\Sites\myblog>

Was This Post Helpful? 0
  • +
  • -

#8 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 745
  • View blog
  • Posts: 1,525
  • Joined: 30-January 09

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 02:14 PM

Looks like an authentication problem now. AFAIK, the 'root' username has no password, or more specifically, the password field is an empty string. Is that how you have your connection credentials set up?

Alternately, have you changed the password for 'root' and not updated your code?

The third thing I can think of is perhaps you have deleted the 'root' user, and need to connect through different credentials.
Was This Post Helpful? 1
  • +
  • -

#9 LittleSoul  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-May 12

Re: Ripping my hair out: MySQL5.5, Rails3, Win7

Posted 20 June 2012 - 02:37 PM

I fixed it by redoing the password in the database.yml

I must have typed it wrong all the while! hahaha.

Thanks a lot for your help everyone.

And good luck to anyone reading this thats having the same problems. I hope this helped you.
I wish I had a post like this to go off of.

THANK YOU DIC!
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1