Comments - Why does this update (or create) user statement fail?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
No, the '#' character is fine to use in a password, and the statement you supply above also works fine if pasted into the command line on Ubuntu, just like the others. I am not sure why you are experiencing problems, perhaps a shell setting. You can test for yourself if the '#' character is causing a problem in your environment by removing it, but there is no reason I know of from MariaDB's side for this.
Thank you for taking the time to reply.
I was sure it was the "#" character in the password. I just could not find a list of "unapproved" characters.
I will check my shell. I wonder if the # is for some comment indication.
Again, thank you for your assistance.
chuck