Bug #42017 Cannot connect using localhost
Submitted: 10 Jan 2009 16:29 Modified: 10 Feb 2009 19:39
Reporter: Robert Mundy Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any

[10 Jan 2009 16:29] Robert Mundy
I cannot connect to MySql Server using localhost.  I have uninstalled and reinstalled mysql several times and I get the same answer.  None of the tips in the FAQ for this problem has helped at all.  

When mysql I was following a mysql tutorial that had me enter the following command:

DELETE FROM mysql.user WHERE Host <> 'localhost'

mysql has not worked since.

How to repeat:
Login and run this command:

DELETE FROM mysql.user WHERE Host <> 'localhost'
[10 Jan 2009 19:39] MySQL Verification Team
Thank you for the bug report. Which exactly server version have you installed?. Anyway if you don't have data to preserve before to re-install you can delete manually the whole data directory which the installer left on your machine, see Documents and Settings->All users->Applications Data->MySQL->MySQL Server xxx.
[11 Feb 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".