> From: Jeromie Clark <[EMAIL PROTECTED]> > > Okay, I got spanked a little for having a bad attitude...
Hey, those who ask for help with attitude get exactly that -- help with attitude! :-) >> I can only say to add "old_passwords=1" to your "my.cnf" file in >> the "[mysqld]" section. >> > It defeats the stronger authentication > scheme that they implemented, which is definitely not cool in a > production environment. I'd much rather see the guy do it the > right way > by temporarily gaining access to the database, then actually > correct the > problem by resetting the passwords using the stronger hashing method. Correct me if I'm wrong, but doesn't "doing it the right way" involve changing all your PHP "mysql*" library calls to "mysqli*"? I know phpMyAdmin (for example) will work either way, but you have to tell it which mysql calls to make in its configuration. The quick one-liner is less secure than the new password hashing, but certainly, it's no worse than the old one, no? And you get stored procedures, triggers, more... while slowly migrating your code to use the new "mysqli" interface. Brian was interested in "migration, and simplicity," so it seemed to me making this change got him back on the air in the short term. But I guess we all know of the short-term solutions that turned into long-term problems, like all the COBOL code written in the '60's that had two-character dates... :::: We will see in some subsequent charts that we probably have reached peak oil. -- US Congressman Roscoe Bartlett, in presentation to the US Congress, 15 March 2005 :::: Jan Steinman "http://www.IslandSeeds.org"; ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
