Let's say that you're in a MySQL prompt and you are trying to create a user and grant a single database access to the user.
CREATE USER `ecommerce` IDENTIFIED BY `tH!s!SmYP@s$w0rDd0N0tUs3!T';
If I try to execute it, I will be stuck in > like this:
mysql> CREATE USER `ecommerce` IDENTIFIED BY `tH!s!SmYP@s$w0rDd0N0tUs3!T';
So how can I escape the exclamation mark?
"\!" wouldn't work because I'll get:
Unknown command '\!'.
Pardon me if this question have already been asked, but I've searched in Google for quite a while and I couldn't find what I'm looking for.
PS: If only I can create tags for exclamation mark and exclamation point. For someone searching in the Internet with the same problem that I have can find my thread a lot quickier with the two tags that I couldn't create.