1
I'm trying to connect my rails app running on my Mac to MySQL running on my Windows 7 machine. They are both on the same network at my house, and I can ping my Windows machine from my Mac.
Trying to execute rake db:create
I get this error:
Host 'MACMINI-459400' is not allowed to connect to this MySQL server
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "reconnect"=>false, "database"=>"MySite_development", "pool"=>5, "username"=>"root", "password"=>"password", "host"=>"10.0.0.33"}, charset: utf8, collation: utf8_unicode_ci
(if you set the charset manually, make sure you have a matching collation)
This is my current database.yml
contents
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: MySite_development
pool: 5
username: root
password: password
host: 10.0.0.33
I've tried turning off Windows firewall but didn't work. How can I get these two to connect?
Somebody was able to answer this for me: http://stackoverflow.com/questions/18456590/connect-from-mac-rails-app-to-mysql-running-on-windows-7-machine
– sbonkosky – 2013-08-28T02:42:27.937