MySQL Bugs: #66006: Unable to "connect" to DB after using mysql-installer-5.5.25a.0 on Win 7

Bug #66006	Unable to "connect" to DB after using mysql-installer-5.5.25a.0 on Win 7
Submitted:	25 Jul 2012 5:24	Modified:	3 Nov 2012 13:17
Reporter:	7 reeds	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.5.25a.0	OS:	Windows (Qin 7)
Assigned to:		CPU Architecture:	Any
Tags:	Connection, MySQL, Win 7, workbench

Description:
Hi,

In the last week I have downloaded the mysql-installer-5.5.25a.0.msi installer for windows a couple of times. I have gone through the install process many times. Each time some oddity in the installation process failed. I used the installer to then do a complete removal. I did reboots between installs.

The most recent install seemed to give the best result. I did a developer install with TCP access, though I will only connect over "localhost". The database started and I was able to start Workbench.

WB had default entries for Connection and Administration. I can enter the Admin tab and see server status, users, etc by logging in with the root user and password. The password was "saved".

If I try to open a "Connection" though I get a pop-up dialogue with the message:
00:20:33 [ERR][ WBContext]: Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Could not open database

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

... well, to be honest that comes from the WB log file but the text is the same.

I did some googling and saw a suggestion to delete the WB password file -- that did nothing.

I have asked about this in the mysql forums and it was suggested that i file a bug report so here I am

Thanks in advance
Seven

How to repeat:
On Win 5 use the mysql-installer-5.5.25a.0.msi installer and hope it works at all

Please:
1 Check that mysql is running on server 127.0.0.1

Yes.

2 Check that mysql is running on port 3306 (note: 3306 is the default,
but this can be changed)

Yes.

3 Check the root has rights to connect to 127.0.0.1 from your address
(mysql rights define what clients can connect to the server and from
which machines) 

Yes.

4 Make sure you are both providing a password if needed and using the
correct password for 127.0.0.1 connecting from the host address you're
connecting from

Yes.

I can go to "Manage Connections" and test the connection.  It reports that the parameters are correct.

I can use the command line mysql client and connect a la:

#############

c:\Program Files\MySQL\MySQL Server 5.5\bin>mysql -u root -p -h 127.0.0.1 -P3306
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.25a MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

c:\Program Files\MySQL\MySQL Server 5.5\bin>mysql -u root -p -h localhost -P3306
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.25a MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

#############

Are you sure that you had provided the same root password for this connection as you use in the mysql command line client?

Yes, there is only one "user" and that is "root".  The root account is identified as being able to connect as root@localhost and root@127.0.0.1, both have ports of 3306 defined

I have "cleared" and resent the passwords in the Edit Connection section and i have reset the passwords using the Admin section.

I may do another uninstall and re-install later tonight.

Did you type something in the Schema field of the connection dialog? If so, try connecting after clearing it

Hi Again,

The schema field is currently blank.  I did put something in there at some point but i don't remember if it was during the current installation.  It didn't work either way.

Hi,

I just removed the last MySQL install.  I re-installed using 

    mysql-installer-community-5.5.25a.1.msi

I have exactly the same issues.  I am hoping the install log may have a clue

This is a 64bit machine... yeah, I *just* noticed that this is a 32bit installer.  I may try downloading the individual bits and pieces

Cheers

Hello.
Can you please try to deleting the "connections.xml" from: "%AppData%\Roaming\MySQL\Workbench".
Thanks.

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".