Description:
Acording to:
http://dev.mysql.com/doc/refman/5.5/en/user-names.html
MySQL usernames should be 16 characters long or less.
GUI Installer and console installers allow the user to input names longer than the limit.
How to repeat:
GUI side
Run the GUI Installer.
Select Server only Type installation.
When on the screen MySQL Server Configuration 2/3, click add a user.
On the popup, type a username longer than 16 characters long, type a password and click ok.
The GUI should not allow to click ok if the username is longer than the limit.
CLI side
Open the Intaller console
(Win7x64:
C:\Program Files (x86)\MySQL\MySQL Installer\MySQLInstallerConsole.exe)
Install server and create users like:
MySQLInstallerConsole.exe --action=install --product=mysql-server-5.5-win32 --config=mysql-server-5.5-win32:passwd=root --user=mysql-server-5.5-win32:name=bob01234567890123456789;host=localhost;role=DBA;password=P4$$w0rdExampl3
No error message will be shown, but the user account won't exist.
(you can verify installing WB and searching the previously supplied credentials at the CLI, they won't exist).
Suggested fix:
GUI:
Make sure the user types usernames of valid length before allowing him to click OK.
CLI:
Detect invalid username, before processing any further.
Maybe add a validation of username length and display user help when exceeded.
