Bug #10383 Command line client doesn't accept extended characters in password when logging
Submitted: 5 May 2005 12:39 Modified: 12 May 2005 20:23
Reporter: Disha Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.4 Beta OS:Windows (Windows 2003)
Assigned to: Jani Tolonen CPU Architecture:Any

[5 May 2005 12:39] Disha
Description:
If a user has extended characters in the password, the user cannot log in to the command line client as the client does not accept these characters.

How to repeat:
1. Start the MySQL client and connect to the database with valid user and password.
2. Set the delimiter to //
3. Create a user as j1 with password containing extended character (can be achieved as ALT + 1185 key combination):

   create user j1 identified as <password containing extended characters>

4. Once the user is created open another command line client and try to login with that user as follows:

   mysql -u j1 -p

5. When asked for the password, try to enter the password with extended characters.

Expected Results: 
1. Either mysql should not accept extended characters in user passwords or the client should accept extended characters for password when the user try to login.

Actual Results: 
1. The command line client does not accept extended characters for password.
[12 May 2005 20:23] Sergei Golubchik
Most probably a charset is set incorrectly or windows terminal garbles the input