Web lists-archives.com

Re: Mystery error in GRANT statement




Nothing. But you opened your quote 27th a " and tried to close it with a '

Quote mismatch.

Get Outlook for Android<https://aka.ms/ghei36>



On Mon, Oct 3, 2016 at 9:45 PM -0400, "James Moe" <jimoe@xxxxxxxxxxxxxx<mailto:jimoe@xxxxxxxxxxxxxx>> wrote:

opensuse v42.1
linux 4.1.31-30-default x86_64
10.0.26-MariaDB

I have a database named "sma-v4-01". The GRANT statement does not like
that database name:

MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO
'xxxxxxxx'@'sma-station14l' IDENTIFIED BY 'xxxxxxxxxxxxxx';

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near ''sma-v4-01'.* TO 'xxxxxxxxx'@'sma-station14l'
IDENTIFIED BY 'xxxxxxxxxxxxxx'' at line 1

If I replace 'sma-v4-01' with 'sma_joomla', the statement is accepted.

What is wrong with 'sma-v4-01'?

--
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
Think.