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), but I don''t know if that strange host value above is really going to be the same day-to-day. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Yes, I''ve done this. When you created the db you had to supply a host name. I typically use mysql.domain.com. Use this as the host in database.yml. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
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 On 11/1/06 7:35 AM, "bjhess" <bjhess-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > 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), but I don''t > know if that strange host value above is really going to be the same > day-to-day. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---