Re: Mystery error in GRANT statement

2016-10-04 Thread Richard
> Date: Monday, October 03, 2016 23:18:14 -0700 > From: James Moe > > On 10/03/2016 08:16 PM, Richard wrote: >> If you want/need to use it I believe you need to use the >> "backtick" to quote the name >> > Yes, that worked. Thank you. > Is there an easy way to rename a

Re: Mystery error in GRANT statement

2016-10-04 Thread James Moe
On 10/03/2016 08:16 PM, Richard wrote: > If > you want/need to use it I believe you need to use the "backtick" to > quote the name > Yes, that worked. Thank you. Is there an easy way to rename a database? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc

Re: Mystery error in GRANT statement

2016-10-03 Thread Richard
> Date: Monday, October 03, 2016 18:39:22 -0700 > From: James Moe > > 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

Re: Mystery error in GRANT statement

2016-10-03 Thread Michael Munger
Nothing. But you opened your quote 27th a " and tried to close it with a ' Quote mismatch. Get Outlook for Android On Mon, Oct 3, 2016 at 9:45 PM -0400, "James Moe" > wrote: opensuse v42.1 linux 4.1.31-30-default

Mystery error in GRANT statement

2016-10-03 Thread James Moe
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 ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an

Mystery error in GRANT statement

2016-10-03 Thread James Moe
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 ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an