How to use MySQL Command Line with special characters password

MySQLcommandLine.md

How to use MySQL command line with special characters password

You must do this if the password has any of the following characters:

* ? [ < > & ; ! | $ ( )

🟥 Important Note: Make sure there is no space after -p and MySQL password.

Method 1

Use quotes around the password:

mysql -u root -p'Special*Character?Password()'

Method 2

Use bash variables

P='Special*Character?Password()'
mysql -u root -p$P

Method 3

Backslash (\) those special chars.

mysql -u root -pSpecial\*Character\?Password\(\)