Mystery error in GRANT statement
James Moe <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <sig.0085d31830.c935f687-95c5-3b2f-735d-21113aba5a9c@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 iEYEARECAAYFAlfzCEoACgkQzTcr8Prq0ZMyeQCgpXXqWrs3xFxky5JBvEgtUesp TIQAniXf7Lg1T6QpU1gk5aXjy9qHTqhN =co4n -----END PGP SIGNATURE-----