Error on Installation Step 2 - SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied

[arpit85]

Hi, I am installing the Script on my Dedicated Server with cPanel, the installation is successful but on step 2 of installation screen i receive this error - SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation, when testing using admin dashboard - the database connection fails

 

[adam]

Hi,

What privileges does your DB user have? It should have all to enable the table creation on install.

Thanks,
Adam.