SQLSTATE42000: Syntax error or access violation: 1227 Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

Issue

If during the installation you facing the error below:

SQLSTATE42000: Syntax error or access violation: 1227 Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

... this means that the database user doesn't have all privileges to manage the database on the database server's host.

Solution

Please make sure to give super privileges (full access) to the database's user on the database host.

If the problem persists kindly contact your hosting provider for more information and get a suitable help about that.

Resources

• https://stackoverflow.com/questions/11946012/how-to-add-super-privileges-to-mysql-database

• http://kanyakonil.com/2015/08/26/resolving-access-denied-you-need-at-least-one-of-the-process-privileges-for-this-operation/

• https://stackoverflow.com/questions/21485303/grant-privileges-to-user-in-mysql

• https://stackoverflow.com/questions/45610155/mysql-root-user-cant-create-table-or-other-super-user-tasks

• https://dba.stackexchange.com/questions/63404/how-to-grant-super-privilege-to-the-user