MySQL loses password?

2011-06-12 Thread Tim Thorburn
Hi all, I came across something strange today on my dev machine and thought I'd see if anyone here has run into a similar problem. To begin, my dev machine is Win7 Ultimate 64-bit, running MySQL 5.5.11 (also 64-bit). Today when I tried to log into the server using the old MySQL GUI tools

Re: MySQL loses password?

2011-06-12 Thread Johan De Meersman
If it's recently been upgraded or had an old pre-upgrade backup restored, that's not a major surprise; and surely you won't have ben running mysql on a win7 for several years :-) In brief, mysql changed password encryptions between 4.1 and 5.0, for various reasons. The old password scheme is

Re: MySQL loses password?

2011-06-12 Thread Tim Thorburn
There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years, as it is the same password I've used on my dev machines throughout the years. This machine started off as a fresh install of the OS several months ago. The only version of MySQL ever on this

Re: MySQL loses password?

2011-06-12 Thread Claudio Nanni
This happens when you use an old client / library. Can you try from command line? Also issue: mysql --version Claudio On Jun 12, 2011 3:09 PM, Tim Thorburn webmas...@athydro.com wrote: There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years, as it is the