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.
Right after using sudo to get to the command line for mariadb and logging in.
(I cannot cut-and-paste, so I am typing this in.)
sudo mysql -u root -p [sudo] password for ubuntu: {I type in the sudo password} Enter password: {I type in the mariadb root password} Welcome to the MariaDB monitor...... ...Server version: 10.0.25-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04 ... MariaDB [(none)]> SET PASSWORD FOR 'nextclouduser'@'localhost' = PASSWORD('35KMMeiibw#=');
that line generates the error.
It is as if you cannot use the "#" symbol in your password. :... right syntax to use near '"35KMMeiibw"' ..." it truncates at the # symbol.
Is that true?
Thank you for taking the time to read and respond.
chuck
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