# Rake Migrate e MySql: access denied?

**URL:** <https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114>\
**Category:** Rails\
**Created:** [March 8, 2007, 9:51am UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114 "2007-03-08T09:51:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/e9bcb4/32.png) [@kena](https://www.ruby-forum.com/u/kena)\
**Post date:** [March 8, 2007, 9:51am UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114/1 "2007-03-08T09:51:01Z")

</div>

Hello. I have set a rails app, set the database.yml file, generated a  
simple model, created the migration class file for this model and then  
i´m trying to run the cmd: rake migrate, but i receive the following  
msg:

1. C:\Documents and Settings\Ken\My Documents\RoR  
Projects\railslist\>rake migrate
2. (in C:/Documents and Settings/Ken/My Documents/RoR  
Projects/railslist)
3. rake aborted!
4. #28000Access denied for user ‘root’@‘localhost’ (using password:  
YES)

What´s probably happening is that MySql is denying access to Rails …  
but i can´t figure out how to fix it. Any ideas?

---

<div class="post-metadata">

**Author:** ![kena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/e9bcb4/32.png) [@kena](https://www.ruby-forum.com/u/kena)\
**Post date:** [March 8, 2007, 1:23pm UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114/2 "2007-03-08T13:23:51Z")

</div>

> What´s probably happening is that MySql is denying access to Rails …  
> but i can´t figure out how to fix it. Any ideas?

if you’re database.yml has something like:  
username: root  
password:  
i.e. no password

Try connecting to mysql:  
mysql -u root

If you can’t connect, you’ll need to set up a user ‘root’ without a  
password.  
Something like from within mysql:  
GRANT ALL PRIVILEGES ON _._ TO ‘root’@‘localhost’ WITH GRANT OPTION;

MySQL docs:  
[http://dev.mysql.com/doc/refman/5.0/en/adding-users.html](http://dev.mysql.com/doc/refman/5.0/en/adding-users.html)

---

<div class="post-metadata">

**Author:** ![kena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/e9bcb4/32.png) [@kena](https://www.ruby-forum.com/u/kena)\
**Post date:** [March 8, 2007, 1:24pm UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114/3 "2007-03-08T13:24:51Z")

</div>

> 1. C:\Documents and Settings\Ken\My Documents\RoR  
> Projects\railslist\>rake migrate

oops. rake migrate is deprecated, instead use:  
rake db:migrate

---

<div class="post-metadata">

**Author:** ![kena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/e9bcb4/32.png) [@kena](https://www.ruby-forum.com/u/kena)\
**Post date:** [March 9, 2007, 9:36am UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114/4 "2007-03-09T09:36:20Z")

</div>

I am also having the same problem now. if u find a soln. please let me  
know.

Mohan

---

<div class="post-metadata">

**Author:** ![kena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/e9bcb4/32.png) [@kena](https://www.ruby-forum.com/u/kena)\
**Post date:** [March 10, 2007, 7:01pm UTC](https://www.ruby-forum.com/t/rake-migrate-e-mysql-access-denied/88114/5 "2007-03-10T19:01:00Z")

</div>

Hi all … I created a new user and set the proper permissions to this  
new user and now everything works fine!