Mysql授权用户 库名带横线的方法

mysql> GRANT ALL PRIVILEGES ON g-xxx.* TO 'test'@'%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-iam.* TO 'g-dev'@'%'' at line 1

 

把库名反引用出来   ``
GRANT ALL PRIVILEGES ON `g-xxx`.* TO 'test'@'%';