Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found.
Trying to use command line produces the error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
The same Access denied for user 'root'@'localhost' (using password: YES)
happens when trying to use MySQL Workbench 5.2.33 CE. phpMyAdmin gives
an error #2000 Cannot log in to the MySQL server.
mysql --version returns:
mysql Ver 14.14 Distrib 5.5.11, for Win64 (x86)
I'm guessing I'll be uninstalling/removing MySQL completely tomorrow and
doing a clean install of 5.5.13. Although it would be handy to know
what caused this problem in the first place. It's more than a little
concerning when Friday everything works, shutdown computer for the
night, log in again Saturday to find MySQL doesn't so much like my
passwords anymore.
On 6/12/2011 3:33 PM, Claudio Nanni wrote:
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
<mailto: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 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 particular machine is
> 5.5.11. My confusion is mostly centered around the "it worked fine on
> Friday, then Saturday happened" issue. I've run a complete virus scan
> and found nothing, as well as several spyware/malware scans - it's in
> the process of running a scan from a rescue disc, so I'll know if
> there's anything else afterward.
>
> Seems odd anyone would bother hacking into this dev machine that's
> barely connected to the Internet.
>
> On 6/12/2011 8:59 AM, Johan De Meersman wrote:
>> 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 still supported, but
iird the default setting for that in newer versions is off, yielding
you the error you are reporting.
>>
>> Of course, if none of that is the case, you may have been hacked;
but it seems somehow strange that a hacker would bother to install
oldstyle passwords.
>>
>> The error message you provide also mentions the oldpasswd flag for
PHP< 5.2 - also worth looking at.
>>
>>
>> ----- Original Message -----
>>> From: "Tim Thorburn"<webmas...@athydro.com
<mailto:webmas...@athydro.com>>
>>> To: mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>
>>> Sent: Sunday, 12 June, 2011 2:50:22 PM
>>> Subject: MySQL loses password?
>>>
>>> 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
>>> as root, I got an error number 1045 Access denied for user
>>> 'root'@'localhost' (using password: YES). This is odd because I've
>>> not
>>> changed the root password on my dev machine in years. When I tried
>>> to
>>> goto a site on this same machine, Apache throws the following
>>> message:
>>>
>>> mysqlnd cannot connect to MySQL 4.1+ using the old insecure
>>> authentication. Please use an administration tool to reset your
>>> password with the command SET PASSWORD =
>>> PASSWORD('your_existing_password'). This will store a new, and more
>>> secure, hash value in mysql.user. If this user is used in other
>>> scripts
>>> executed by PHP 5.2 or earlier you might need to remove the
>>> old-passwords flag from your my.cnf file
>>>
>>> This is the first time I've seen such a message, or had MySQL
>>> randomly
>>> stop accepting my root password. I'll likely be doing a complete
>>> uninstall and reinstall in a few hours on this machine, but thought
>>> I'd
>>> ask here to see if anyone had any thoughts as to why this happened,
>>> and
>>> how I might correct it? If at all possible, I'd prefer to not have
>>> to
>>> do an uninstall/reinstall as I wisely hadn't backed up a few tables I
>>> was working on over the last couple days.
>>>
>>> Any thoughts?
>>>
>>> Thanks in advance,
>>> -Tim
>>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
>
