MySQL Bugs: #10774: Password failure when calling Query Browser from Tool Menu

Bug #10774	Password failure when calling Query Browser from Tool Menu
Submitted:	20 May 2005 19:12	Modified:	12 Oct 2005 12:11
Reporter:	Eric Reiss	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.20	OS:	Windows (Windows 2000 Server)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
I created a root account when installing MySQL and used a double quote in the password.

I can login using the Administrator tool and using the Query Browser using this root account adn password but when I am in the Administrator tool and try to start the Query Browser from the Tools Menu, I get an error.

The first line is the dialog title:
MYSQL Query Browser Error

Could not connect to the specified host.
MySQL Error Number 1045
Access Denied for the user 'root@localhost' (using password: YES)

The rest of the password's characters are simlpe and I set this up on another machine with no problems so I guess it was the double quote.  I removed the double quote and the problem goes away.

Definitely the double quote.

This is a minor inconvenience.

How to repeat:
Put a double quote in password and try to connect to to Query Browser from Tools menu in Administrator tool.

You should get error.

Remove double quote adn it will go away.

Suggested fix:
I just looked at the help on passwords and see it recommends not using special characters.  So this might not be a real problem but perhaps there should be some note or way to remind users when creating users that special characters are not advisable.

the same error message pops up if you use an account with an empty password while starting the Query Browser from the Tools menu within Mysql Administrator

MySQL Administrator 1.1.0rc

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html