Tom Dell''Aringa
2005-Oct-13 13:09 UTC
Re: mySQL command line within rails - access denied? [solved]
--- Alex Young <alex-qV/boFbD8Meu8LGVeLuP/g@public.gmane.org> wrote:><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Have you installed MySQL on top of an old installation? There was a > change in password formats between version 4.0 and 4.1 that could cause > that. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>Ah, yes I have - I used to have 4 installed on here. Then I saw I had 2 instances of 4.1 running as well (I had some installation issues). I removed both of them and now things are screwy, not surprisingly. I will remove all and reinstall.><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > mysql -u dave depot_development < db/create.sql > > If I''ve read what you''ve done correctly, that should do it. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>I tried that before uninstalling old installs of mysql and it worked perfectly :). Thanks so much for the help Alex, I think once I re-install 4.1 I''ll be able to get this running correctly! Tom http://www.pixelmech.com/ A man spoke frantically into the phone: "My wife is pregnant and her contractions are only two minutes apart"! "Is this her first child?" the doctor asked. "No, you idiot!" the man shouted. "This is her husband!" Q: What do you call a muddy chicken who crossed the road two times? A: A dirty double crosser...
Stephen Caudill
2005-Oct-13 13:37 UTC
Re: mySQL command line within rails - access denied? [solved]
Tom Dell''Aringa wrote:> I tried that before uninstalling old installs of mysql and it worked perfectly :). Thanks so much > for the help Alex, I think once I re-install 4.1 I''ll be able to get this running correctly!Tom, Nice to see one of the old-school Evolters on the Rails list :) Your issue sounds like the mysql old_password incompatibility with pre 4.1 clients. You can try running this for the user you''re trying to connect with: SET PASSWORD FOR ''my_user''@''localhost'' = OLD_PASSWORD(''my_pass''); Now that I think about it, I haven''t run into that problem since I''ve been developing in rails. Not sure if it''s connected or not, but that''s solved the same problem for me numerous times doing PHP dev. Cheers, Stephen
Tom Dell''Aringa
2005-Oct-13 14:03 UTC
Connection being refused from Rails/mySQL (related to previous)
--- Stephen Caudill <vox-rUtwbJCiuDxWk0Htik3J/w@public.gmane.org> wrote:><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Nice to see one of the old-school Evolters on the Rails list :) Your > issue sounds like the mysql old_password incompatibility with pre 4.1 > clients. You can try running this for the user you''re trying to connect > with: > > SET PASSWORD FOR ''my_user''@''localhost'' = OLD_PASSWORD(''my_pass''); ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>Hey Stephen :) It truly is a small world sometimes! You and Alex both mention this, and I wonder if this is part of my new problem or something else. I uninstalled ALL mySQL''s from my machine. Restarted. Re-installed 4.1. I had to run it on port 3307 since something is already running on 3306, but I think I was already doing that. In order to get mySQL to execute and run as a service, I had to change the name of the service from the default ''mySQL'' to something else.[1] I re-did the grant statements and successfully ran the create.sql script. When I hit the server I get the following message: "No connection could be made because the target machine actively refused it. - connect(2)" The server log shows: 127.0.0.1 - - [13/Oct/2005:08:59:41 Central Daylight Time] "GET /admin HTTP/1.1" 500 5184 - -> /admin I also got this when I tried to redo my scaffolding Other errors on the admin page are: /app/controllers/admin_controller.rb:8:in `list'' /app/controllers/admin_controller.rb:3:in `index'' script/server:49 So, something got ''disconnected'' or something during the reinstall..I''m wondering if it has something to do with the mysql service name? I''ve dug around, tried to redo as much of the process as possible (I think I''ve basically redone it all...) but can''t seem to resolve this. All in all though..loving rails! [1] http://www.faqts.com/knowledge_base/view.phtml/aid/33006/fid/185 http://www.pixelmech.com/ A man spoke frantically into the phone: "My wife is pregnant and her contractions are only two minutes apart"! "Is this her first child?" the doctor asked. "No, you idiot!" the man shouted. "This is her husband!" Q: What do you call a muddy chicken who crossed the road two times? A: A dirty double crosser...
Possibly Parallel Threads
- Re: mySQL command line within rails - access denied?
- echo password into bash script
- Ruby and Flash?
- how to use ruby debugger instead of irb from script/breakpointer
- 'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?