3.2 MySql User Accounts Password

This section provides the procedure to check for the presence of any forbidden special characters in the mysql passwords for awadmin and root user accounts.

Mysql password can contain the following:

• Upper case alphabets (A-Z)
• Lower case alphabets (a-z)
• Digits (0-9)
• 21 allowed special characters

Allowed Special Characters

There are a total of 32 special characters on the standard qwerty keyboard. Out of these 32 special characters, 21 characters are supported in the MySql passwords.

The following table provides the list of these 21 allowed special characters.

Table 3-4 Allowed Special Characters

Allowed Special Characters	Name
#	Octothorpe or hash or pound sign
!	Exclamation point
~	Tilde
%	Percent
^	Caret or circumflex
*	Asterisk
_	Underscore
-	Hyphen or dash
+	Plus
=	Equal
?	Question Mark
{	Open Braces
}	Close Braces
(	Open Parenthesis
)	Close Parenthesis
<	Open angle bracket or less than
>	Close angle bracket or greater than
|	Pipe or Vertical bar
.	Dot
,	Comma
;	Semi Colon

Forbidden Special Characters

There are a total of 32 special characters on the standard qwerty keyboard. Out of these 32 special characters, 11 characters are currently not supported in the MySql passwords. Usage of these forbidden special characters in the password will set the incorrect password in the database of MySql Server.

The following table provides the list of these 11 forbidden special characters.

Table 3-5 Forbidden Special Characters

Forbidden Special Characters	Name
@	Ampersat
$	Dollar
&	Ampersand
`	Backtick or backquote or grave accent
\	Backslash
/	Forward slash
[	Open Square Bracket
]	Close Square Bracket
‘	Single quotation mark or apostrophe
“	Double quotation mark
:	Colon