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

arpit85

New Member
Nov 18, 2021
1
0
1
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

Administrator
Staff member
Dec 5, 2009
2,033
105
63
Hi,

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

Thanks,
Adam.