From: Nitin Mehta
Date: October 25 2012 6:45am
Subject: RE: MySQL password issue
List-Archive: http://lists.mysql.com/mysql/228481
Message-Id: <96d7133a-7254-4de6-a5c4-014d6dd5cf9a@default>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi Tim,

It looks like your '.sql backup file' has changed the password for root use=
r and why it is persisting is perhaps you have data directory outside the i=
nstall directory.

How you correct the problem:

Stop the service, start the service with option '--skip-grant-tables', logi=
n with root user and change the password from inside mysql.

Hope that helps.



-----Original Message-----
From: Tim Thorburn [mailto:webmaster@stripped]=20
Sent: Thursday, October 25, 2012 12:08 PM
To: mysql@stripped
Subject: MySQL password issue

Hi All,

Today I ran into an interesting problem with my MySQL installation. =20
I'll start off with the usual suspects: this is my development laptop runni=
ng Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Wi=
ndows Update.  I downloaded the Windows Installer version of MySQL which is=
 MySQL 5.5.28 Community Server.  I ran the setup choosing Developer install=
, made a root password, then created two users for Backup and Replication.

The install completed successfully, and I was able to start MySQL Workbench=
 logging in as root once.  I made a user in Server Administration and then =
imported a .sql backup file.  I then went to SQL Development to review the =
result of the restore.  I wasn't able to view the imported tables, Workbenc=
h seemed stuck on Retrieving Tables.  This database is driving a website I'=
m working on, and I was able to load the site in a browser on my laptop - a=
gain once.

Next, I went to add another user, and then tried to import another .sql bac=
kup file.  This time, when I clicked Start Import, Workbench prompted me to=
 enter my root password again.  Odd I thought, as I'd originally told Workb=
ench to save the password in its vault.  Unfortunately, Workbench won't acc=
ept the root password.  I receive the following message in a popup window:

Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at =
localhost:3306:
Access denied for user 'root'@'localhost' (using password: YES)

The MySQL Service is still running, I've tried stopping, starting, and just=
 restarting the service.  I've tried rebooting.  All with the same result. =
 What could have happened to this install to make MySQL no longer accept my=
 password?  I have already tried uninstalling via the MySQL Installer, conf=
irming that C:\ProgramData\MySQL was removed, and then shutting Windows dow=
n completely before trying to re-install.  The same result happens - I'm ab=
le to log in once, then several minutes later it will no longer accept a pa=
ssword.  This is a fresh install again, so there's not a lot of pain in uni=
nstalling and reinstalling.

Any thoughts on why this is happening, or more importantly, how to correct =
the problem?

TIA,
-Tim