Okay, I got spanked a little for having a bad attitude, and rightfully
so... but we get this question on a regular basis, and the answer is in
the group archives I don't know how many time at this point. In an
ideal world, people would search the archives first. I should probably
just get over it, but I'm a bit of a curmudgeon when it comes to basic
newsgroup etiquitte...
I stand by the RTFM comment. The error message is explicitly listed IN
the manual, and available in the plaintext search.
Had he been a little more thoughtful in the original post ("This version
of MySQL is a pain in the ass..."), I wouldn't have ripped on him. I
got the feeling that he didn't want to take the time, as some people who
abuse the list do from time to time.
That being said, the comment about windows wasn't a "my platform is
better than yours" crack. There are a lot of things that Microsoft does
really well, and there are definitely places for Windows boxes in a
production environment. Reporting Server and many Enterprise
applications are great examples. I can't make the argument for using
IIS over FreeBSD/Apache 2.0, but my point is that it's about using the
best tool for the job. I try to not be too religious about it.
The windows comment was in response to Bob's suggestion to recompile PHP
using the latest MySQL client libraries -- which you *can't* do on
Windows. That is definitely one of the nice things about running in a
*nix environment -- you can compile apps to run optimally in your
specific environment, and you can also re-compile apps to update things
like client libraries.
>I can only say to add "old_passwords=1" to your "my.cnf" file in the
>"[mysqld]" section.
>
>
That's definitely one approach. 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.
The manual pages I provided spell it out clearly.
Snotty tone aside, I also think it's important to impart to novice users
that blindly upgrading can royally screw you. Hopefully I can spare
someone the pain of learning that lesson the hard way.
-Jeromie
------------------------ 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/
