connecting with mysql

I created new project with rails mysql -d <pname> but now I am creating controller I am getting error I also installed mysql with gem install mysql Access denied for user 'root'@'localhost' (using password: NO) what is the solution?

Make the username and password in your database.yml correspond to users with access to your database.

Fred

Does the root account in mysql need a password? If so, have you added that password to <<app root>>/config/database.yml?

Roy Pardee wrote:

Does the root account in mysql need a password? If so, have you added that password to <<app root>>/config/database.yml?

now tell mehow to create a database in sqlite with ruby on rails.and connect with it .I m noot getting