MariaDB GRANT command fails with syntax error

Asked Sep 01 '23 at 08:39

Active Sep 01 '23 at 08:39

Viewed 13 times

I'm trying to execute:

GRANT SYSTEM VARIABLES ADMIN on *.* TO thomas;

on MariaDB 10.5, but it fails with:

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 'VARIABLES ADMIN ON . to thomas' at line 1

Looking at the docs seems to validate it looks correct: https://mariadb.com/docs/skysql-dbaas/ref/xpand/privileges/SYSTEM_VARIABLES_ADMIN/

Testing on local MariaDB and remote cloud hosted.

asked Sep 01 '23 at 08:39

Thomas Larsen

this would only work on skysql, not in an "normal" Mariadb installation – nbk Sep 01 '23 at 08:46
How do you do it on a normal MariaDB? – Thomas Larsen Sep 01 '23 at 08:48
1

[various ADMIN](https://mariadb.com/kb/en/grant/) grants exist all of which control some global system variables, however unlike SkySQL there is no `SYSTEM VARIABLES` grant available. – danblack Sep 01 '23 at 09:10

MariaDB GRANT command fails with syntax error

0 Answers0