mysql - 错误 1064 (42000) : You have an error in your SQL syntax in Ruby on Rails

Question

尝试在 RUBY ON RAILS 中使用 devise-pundit 示例应用程序时出现语法错误

mysql> grant all privileges on rails-devise-pundit_development to 'pavuluri'@'localhost' identified by '';

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 '-devise-pundit_development to 'pavuluri'@'localhost' identified by ''' at line 1

Database Name : rails-devise-pundit_development(default).

数据库名称中不允许使用rails吗？ (保留字)

请提出建议

不知道信息是否足够。

Answer 1

这应该有效:

GRANT ALL PRIVILEGES ON `rails-devise-pundit_development`.* TO pavuluri@localhost  IDENTIFIED BY 'PASSWORD';

或者:

GRANT ALL PRIVILEGES ON `rails-devise-pundit_development`.* TO pavuluri@'%' IDENTIFIED BY 'PASSWORD';