On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote:
> On 7/21/2011 22:45, Tim Thorburn wrote:
>> Hello,
>>
>> For those keeping score, this will be the second time in the past few
>> months I've come upon this problem. To recap, this is happening on a
>> development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This
>> morning, all was working well. This evening, I launched MySQL Workbench
>> 5.2.34 CE to work on a table. When I attempt to access the server from
>> within Workbench, I'm now prompted with a window asking for my password.
>> Of course, my password is not accepted when I enter it - I'm presented
>> with error #2000.
>>
>> Just to confirm, mysql --version returns:
>> mysql Ver 14.14 Distrib 5.5.13, for Win64 (x86)
>>
>> This is not an upgrade, after my last mishap, I once again formatted the
>> laptop with a fresh install of Windows 7 Ultimate 64-bit as well as
>> MySQL 5.5.13. I've begun digging through bugs.mysql.com, but I'm not
>> seeing any standing out. I should point out that this problem also
>> breaks any sites running on this dev laptop as all passwords are no
>> longer accepted.
>>
>> Any thoughts on what may be causing this? It seems to be happening every
>> month or so at this point.
>>
>> Thanks in advance,
>> -Tim Thorburn
>>
>
> * Check your binary logs, someone may actually be changing your
> passwords.
> http://dev.mysql.com/doc/refman/5.5/en/mysqlbinlog.html
>
> * Be careful with what you backup/restore. You may accidentally revert
> your tables to a condition before you set the password.
>
> * mysql.exe is the command-line client. While it would be unusual to
> have a client utility that is of a different version than your server,
> the actual command to determine the version of the MySQL database
> server would be
>
> mysqld --version
>
> * did you attempt to login using mysql to see if the passwords really
> were different? Remember, the account 'root' for a new installation is
> not created without a password. If you had restored a very old copy
> of that table, that might have been your situation.
>
> * are you aware of the "lost password reset" instructions in the manual?
> http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
>
>
Hi Shawn,
Thanks for the reply. As this has happened before, and because I'm on a
deadline, I ended up stopping the MySQL service with NET STOP MYSQL,
then started MySQL with the skip-grant-tables option so that I could log
in as root and make a backup via mysqldump. After this, I uninstalled
MySQL from Control Panel, then proceeded to delete C:\Program
Files\MySQL and C:\ProgramData\MySQL directories before rebooting to do
a clean install of MySQL 5.5.14.
Before this, I did try to simply reset the root password by once again
stopping the MySQL service, starting it with --skip-grant-tables;
however regardless of what I changed the password to, I received the
same error. This error was present for each login I had on the MySQL
server.
Unfortunately, now that I've uninstalled and deleted the previous MySQL
directories, it seems unlikely that I'll have access to the previous set
of logs. I do, however, have a complete backup of --all-databases from
mysqldump. Would there be anything in here that might shed some light
on the issue?
I'm at a loss here. The only "different" things I had done between when
MySQL was working and when it decided to no longer accept my passwords
was to launch Chrome instead of Firefox to load a specific Google page
and to allow Bonjour to update iTunes and Safari on this laptop. Though
I can't see how either of those would have any impact on MySQL.
Thanks again,
-Tim Thorburn
