I''m new to Rails and trying to get it working on my home machine for test purposes. I have already installed it successfully on my hosting provider''s server (a BSD machine, I think) and set up a simple test app. My home machine is running Mac OS X 10.4.1 with ruby 1.8.2. I installed rails with no problems, then copied the test app over from the remote server. After some tweaking I got it to work...mostly. When I try to run the app I get the following error: Mysql::Error in Category#index Access denied for user: ''<my username>@<IP of my router>'' (Using password: YES) I''ve propagated the database information from the first section of database.yml to the other two just to be safe but it shouldn''t matter: The app is the same on both machines, and accesses the same database. I can access the database from the Mac with the same credentials, either from the CocoaMySQL administration tool or from a PHP-based site that uses it. The best I''ve been able to come up with is that it might have something to do with having a slightly newer (by a few weeks) version of rails on the Mac, or a somewhat different collection of other software installed (I don''t know what rails accesses). But I''m just stabbing in the dark here. Any idea what''s going on? Thanks.
try: gem install mysql -- --with-mysql-config ...more info here if you need it: http://www.pjhyett.com/articles/2005/06/04/setting-up-ror-in-tiger -PJ On 6/15/05, David Feldman <mailing-lists-fDpYTK8McCwok6x7qy236gC/G2K4zDHf@public.gmane.org> wrote:> I''m new to Rails and trying to get it working on my home machine for > test purposes. I have already installed it successfully on my hosting > provider''s server (a BSD machine, I think) and set up a simple test > app. My home machine is running Mac OS X 10.4.1 with ruby 1.8.2. I > installed rails with no problems, then copied the test app over from > the remote server. After some tweaking I got it to work...mostly. > When I try to run the app I get the following error: > > Mysql::Error in Category#index > Access denied for user: ''<my username>@<IP of my router>'' (Using > password: YES) > > I''ve propagated the database information from the first section of > database.yml to the other two just to be safe but it shouldn''t > matter: The app is the same on both machines, and accesses the same > database. I can access the database from the Mac with the same > credentials, either from the CocoaMySQL administration tool or from a > PHP-based site that uses it. The best I''ve been able to come up with > is that it might have something to do with having a slightly newer > (by a few weeks) version of rails on the Mac, or a somewhat different > collection of other software installed (I don''t know what rails > accesses). But I''m just stabbing in the dark here. Any idea what''s > going on? > > Thanks. > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Wooohoo! Thanks! It actually took the whole process on your site rather than just the gem install mysql command, but it works now! Any way to get this added to the instructions on the main RoR download page? --Dave On Jun 16, 2005, at 1:07 AM, PJ Hyett wrote:> try: gem install mysql -- --with-mysql-config > > ...more info here if you need it: > http://www.pjhyett.com/articles/2005/06/04/setting-up-ror-in-tiger > > -PJ > > On 6/15/05, David Feldman <mailing-lists-fDpYTK8McCwok6x7qy236gC/G2K4zDHf@public.gmane.org> wrote: > >> I''m new to Rails and trying to get it working on my home machine for >> test purposes. I have already installed it successfully on my hosting >> provider''s server (a BSD machine, I think) and set up a simple test >> app. My home machine is running Mac OS X 10.4.1 with ruby 1.8.2. I >> installed rails with no problems, then copied the test app over from >> the remote server. After some tweaking I got it to work...mostly. >> When I try to run the app I get the following error: >> >> Mysql::Error in Category#index >> Access denied for user: ''<my username>@<IP of my router>'' (Using >> password: YES) >> >> I''ve propagated the database information from the first section of >> database.yml to the other two just to be safe but it shouldn''t >> matter: The app is the same on both machines, and accesses the same >> database. I can access the database from the Mac with the same >> credentials, either from the CocoaMySQL administration tool or from a >> PHP-based site that uses it. The best I''ve been able to come up with >> is that it might have something to do with having a slightly newer >> (by a few weeks) version of rails on the Mac, or a somewhat different >> collection of other software installed (I don''t know what rails >> accesses). But I''m just stabbing in the dark here. Any idea what''s >> going on? >> >> Thanks. >> >> _______________________________________________ >> Rails mailing list >> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> >> > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >