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.
Oct 03
James Moe Mystery error in GRANT statement
Oct 03, 2016; 18:39
James Moe
Mystery error in GRANT statement
Oct 04
Michael Munger Re: Mystery error in GRANT statement
Oct 04, 2016; 02:05
Michael Munger
Re: Mystery error in GRANT statement
Oct 04
Richard Re: Mystery error in GRANT statement
Oct 04, 2016; 03:16
Richard
Re: Mystery error in GRANT statement
Oct 03
James Moe Re: Mystery error in GRANT statement
Oct 03, 2016; 23:18
James Moe
Re: Mystery error in GRANT statement
Oct 04
Richard Re: Mystery error in GRANT statement
Oct 04, 2016; 11:24
Richard
Re: Mystery error in GRANT statement
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!