MySQL password contains special characters & operation of logging in from command line

On the server, in order to quickly log in to the database, we usually use mysql -hhost -uusername -ppassword db to log in to the database. If there is no special character & in the password, it will directly enter the database sql command line. If there is a special character &, the following prompt will appear:

-bash: syntax error near unexpected token `&'

Generally, we can use the command mysql -hhost -uusername -p db and then manually enter the password according to the prompts.

In addition, passwords with special characters can be processed here.

1. Simply enclose the password in single quotes.

2. Add '\' before the special character & to log in.

Supplement: MySQL sets a complex password containing $ special symbols, which makes it impossible to log in with the command

For security reasons, the $ special symbol was added when setting the MYSQL password, resulting in the following error when running the script:

After some trouble, I found out that it was $

Change the password to remove $

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM. If there are any mistakes or incomplete considerations, please feel free to correct me.