'Mysql2::Error: INDEX command denied to user 'rails'@'localhost' for table 'users'

I am install device in my rails 5 app while doing so I have encountered this error. Has anyone faced similer issue before? **Mysql2::Error: INDEX command denied to user 'rails'@'localhost' for table 'users': CREATE UNIQUE INDEX index_users_on_email ON users (email) **

Here is my what I am getting on my terminal Mysql2::Error: INDEX command denied to user 'rails'@'localhost' for table 'users': CREATE UNIQUE INDEX index_users_on_email ONusers (email) ActiveRecord::StatementInvalid: Mysql2::Error: INDEX command denied to user 'rails'@'localhost' for table 'users': CREATE UNIQUE INDEX index_users_on_email ONusers (email)

Would be gald to have some help.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source