Bug #43250 mysqlaccess doesn't handle special characters in password
Submitted: 27 Feb 2009 7:58
Reporter: Mikiya Okuno Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.60 OS:Any
Assigned to: CPU Architecture:Any

[27 Feb 2009 7:58] Mikiya Okuno
Description:
If a password on the server includes special characters such as # or !, mysqlaccess cannot connect to the server.

How to repeat:
shell> mysql -uroot -p
Enter password: 

mysql> set password=password('aaa###');
Query OK, 0 rows affected (0.05 sec)

shell> mysqlaccess mikiya test -Uroot -P
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier@rug.ac.be)
Changes by Steve Harvey (sgh@vex.net)
This software comes with ABSOLUTELY NO WARRANTY.
Unknown option: Uroot
Password for MySQL superuser : 

Sorry,
An error occured when trying to connect to the database
with the grant-tables:
* Maybe YOU do not have READ-access to this database?
* If you used the -U option, you may have supplied an invalid username?
  for the superuser?
* If you used the -U option, it may be possible you have to supply
  a superuser-password to, with the -P option?
* If you used the -P option, you may have supplied an invalid password?

Suggested fix:
nada