Mystery error in GRANT statement

James Moe <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <sig.10855faebf.ae71445f-1fd9-290a-ff20-3abb0d1cc306@sohnen-moe.com>
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.
signature.asc (application/pgp-signature, 181 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlfzBx0ACgkQzTcr8Prq0ZPBmACfZN7r2I1QuhTZH05DuETbU7Wc
RJIAnjxfD3zJD2jw+pfdfXfSYfdrJcDS
=mCx+
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.