CODEWITHSUNDEEP
mysqlruby-on-railsrubysql-serverruby-on-rails-4
user3505901
user3505901

Reputation: 408

I can not get access to my own MySQL server via RoR?

Okay, so I'm new to ruby and today I spent all day installing it and necessary gems...then uninstalled it and installed everything using RubyInstaller.

Anyway, everything is fine with my installation I think...

I also installed MySQL, and when start WEBrick like this rails server But when I load up localhost:3000

I get this message: Access denied for user 'root'@'localhost' (using password: NO)

Upvotes: 0

Views: 102

Answers (1)

BvuRVKyUVlViVIc7
BvuRVKyUVlViVIc7

Reputation: 11811

If your root user doesnt have a password in your sql server, you should add a blank in your database.yml file:

development:
  ...
  username: root
  password: ""

If your root user in the sql server has a password (probably yes), you should specify it in your database.yml

development:
  ...
  username: root
  password: pa$$word

EDIT:

For creating the database run

bundle exec rake db:create
bundle exec rake db:migrate

Upvotes: 2

Related Questions