# Rake migrate to Dreamhost mysql database

**URL:** <https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649>\
**Category:** Rails\
**Created:** [November 7, 2006, 10:51am UTC](https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649 "2006-11-07T10:51:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bjhess](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@bjhess](https://www.ruby-forum.com/u/bjhess)\
**Post date:** [November 7, 2006, 10:51am UTC](https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649/1 "2006-11-07T10:51:30Z")

</div>

Have you ever tried to do a rails migrate to a mysql DB on Dreamhost?  
I get an error saying "host not allowed to connect to this mysql  
server. The host specified is “##-##-##-##.dhcp.LOC.mn.charter.com”  
(Where the '#'s are numbers and LOC is a city code. I’m worried that  
I’ll have to grant acces to the db as “username@host” (ala  
[http://forums.mysql.com/read.php?86,23619,41248#msg-41248](http://forums.mysql.com/read.php?86,23619,41248#msg-41248)), but I don’t  
know if that strange host value above is really going to be the same  
day-to-day.

---

<div class="post-metadata">

**Author:** ![bjhess](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@bjhess](https://www.ruby-forum.com/u/bjhess)\
**Post date:** [November 7, 2006, 10:51am UTC](https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649/2 "2006-11-07T10:51:35Z")

</div>

Yes, I’ve done this. When you created the db you had to supply a host  
name.  
I typically use [mysql.domain.com](http://mysql.domain.com). Use this as the host in database.yml.

---

<div class="post-metadata">

**Author:** ![bjhess](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@bjhess](https://www.ruby-forum.com/u/bjhess)\
**Post date:** [November 7, 2006, 10:51am UTC](https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649/3 "2006-11-07T10:51:51Z")

</div>

Yes, this works for me.

You can specify remote access (including wildcards, which you’ll  
probably  
need) in the Goodies \> Manage MySQL \> (your user link) \> Remote Access  
field. You can use domains or IP addresses. It’s pretty straightforward.

-Paul

---

<div class="post-metadata">

**Author:** ![bjhess](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@bjhess](https://www.ruby-forum.com/u/bjhess)\
**Post date:** [November 7, 2006, 10:52am UTC](https://www.ruby-forum.com/t/rake-migrate-to-dreamhost-mysql-database/74649/4 "2006-11-07T10:52:23Z")

</div>

Thanks, Paul. That was it…I later figured it out. I just was not  
following the logic of clicking on the user in the goodies | mySQL area  
and specifying the user’s host.