cancel
Showing results for 
Search instead for 
Did you mean: 

Database user does not have enough privileges..

Database user does not have enough privileges..

Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER privileges are granted to table 'database_name'

 

Why Magento 2.x doesn't work with Dreamhost? As we talked to dreamhost support, Magento 2.0's MySQL usage requires a TRIGGER privilege that they don't allow at this time due to security concerns.

 

my Question is, why magento released such type of version that some hosting companies don't allow? What's the use? What's the fix?

 

 

2 REPLIES

Re: Database user does not have enough privileges..

Same issue her.

But for it happened out of the blue.

Admin url says: 

Exception #0 (LogicException): Front controller reached 100 router match iterations

when i try to run

php bin/magento setup:upgrade

[Magento\Setup\Exception]                                                                                                                                                                             

  Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, View, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, S 

  HOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER privileges are granted to table 'dev'. 

 

relentless magento error 😕

 

Re: Database user does not have enough privileges..

Check into my.ini file in MySql config section and check whether skip-grant-tables is there below

# The MySQL server
[mysqld]

........

If it is there then delete it and restart the server. 

hope it will sort out the issue.