Ken's solution worked like a charm and I'm back to work! For those interested, I did some research on the background of this problem, and the explanation is provided in the MySQL online manual, starting here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html With explanation of the workarounds here: http://dev.mysql.com/doc/mysql/en/old-client.html One potential problem pointed out is that OLD_PASSWORD() may one day be deprecated. Hopefully by then most affected third-party clients, like Rev, will have upgraded to a client library that supports the new authentication protocol. Alan Golub Golub & Isabel, P.C. On 8/1/05 10:25 PM, "Ken Ray" <[EMAIL PROTECTED]> wrote: > On 8/1/05 3:25 PM, "Alan Golub" <[EMAIL PROTECTED]> wrote: > >> On 8/1/05 4:00 PM, "Ken Ray" <[EMAIL PROTECTED]> wrote: >> >>> Yes, we ran into this just recently. You need to change the password that is >>> stored in the DB to the "old" (pre-4.1) format for compatiblity with >>> everybody. This is the syntax at the mysql prompt (using "tempUser" as the >>> user name, "localhost" as the host, and "mypass" for the password): >>> >>> set password for "tempUser"@"localhost"=OLD_PASSWORD("mypass"); >> >> I'll need to wait until tonight to run this solution from home, but I just >> want to make sure I 'get it.' >> >> Ok, so for each user accessing the 4.1 or later database, changing/setting >> the password via the OLD_PASSWORD() function stores the password in a manner >> compliant with post-4.0 versions of the server, thus allowing seamless >> (hopefully) access to the db from Rev? > > Yup! You got it! > >> Thanks, Ken! > > No problem... > > > Ken Ray > Sons of Thunder Software > Web site: http://www.sonsothunder.com/ > Email: [EMAIL PROTECTED] > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
