# Rake db:migrate and mysql

**URL:** <https://www.ruby-forum.com/t/rake-db-migrate-and-mysql/158236>\
**Category:** Rails\
**Created:** [January 21, 2009, 12:13am UTC](https://www.ruby-forum.com/t/rake-db-migrate-and-mysql/158236 "2009-01-21T00:13:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rst](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e8c25b/32.png) [@rst](https://www.ruby-forum.com/u/rst)\
**Post date:** [January 21, 2009, 12:13am UTC](https://www.ruby-forum.com/t/rake-db-migrate-and-mysql/158236/1 "2009-01-21T00:13:25Z")

</div>

Hi, when I run this it aborts with an access denied message and  
usepassword = NO

How do I change this to either not require a password, or allow me to  
set the password in the rake command line execution (it’s set in the  
database.yml file, but rake isn’t using it)

---

<div class="post-metadata">

**Author:** ![rst](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e8c25b/32.png) [@rst](https://www.ruby-forum.com/u/rst)\
**Post date:** [January 21, 2009, 10:20am UTC](https://www.ruby-forum.com/t/rake-db-migrate-and-mysql/158236/2 "2009-01-21T10:20:58Z")

</div>

I’m not sure about setting the password at the execution, but I would  
double check the password in the yml file first. Also check with your  
database and make sure the username/password combination you’re using  
matches the database’s. Seems simple but its happened to me before.

---

<div class="post-metadata">

**Author:** ![rst](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e8c25b/32.png) [@rst](https://www.ruby-forum.com/u/rst)\
**Post date:** [January 21, 2009, 6:04pm UTC](https://www.ruby-forum.com/t/rake-db-migrate-and-mysql/158236/3 "2009-01-21T18:04:51Z")

</div>

jthompson wrote:

> I’m not sure about setting the password at the execution, but I would  
> double check the password in the yml file first. Also check with your  
> database and make sure the username/password combination you’re using  
> matches the database’s. Seems simple but its happened to me before.

Thanks for the reply. I had typoed the word password parameter in the  
.yml file