Add ability to set passwordless login (mysql_user)

This commit adds the ability to set a passwordless login. This
functionality requires a new keyword argument (allow_passwordless) be
True.

Fixes #5550.
punctuation fix
Merge pull request #6173 from terminalmage/issue5550

Add ability to set passwordless login (mysql_user)