dreamr user@host is the database username and host of the computer you are trying to connect from. This is NOT the ip address of the database you are trying to connect to. You need to (on the database server) run something like
GRANT ALL PRIVILEGES ON *.* TO 'dreamr'@'184.72.142.179' IDENTIFIED BY "*PASSWORD*"; This will tell mysql to accept connections from your heroku instance. On Wednesday, 24 November 2010 11:57:10 UTC, dreamr wrote: > > Ok, so I read the docs at: http://docs.heroku.com/config-vars > And I configured my ENV for DATABASE_URL > > When I log into 'heroku console' and I > > dbconfig = YAML.load(File.read('config/database.yml')) > ActiveRecord::Base.establish_connection dbconfig['production'] > > My connection comes back: > @config={:adapter=>"mysql", :username=>"dreamr", :port=>nil, :host=>" > SQL09.FREEMYSQL.NET", :password=>"*********", :database=>"rlmprod"} > > HOWEVER!!! When I push and try to start my app it is dead, a quick > check into 'heroku logs' give me: > > Mysql::Error (Access denied for user 'dreamr'@'184.72.142.179' (using > password: YES)): > > The IP address DOES NOT match what is set in my DATABASE_URL env var. > What am I missing here? > > Thanks in advance! I am really hoping to get into Heroku -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en
