Skip to Content

ERROR granting access for DB user: Access denied for user 'root'@'%' to database during upgrade

312  admin July 19, 2021  Common Errors & Troubleshooting

Getting the error ERROR granting access for DB user: Access denied for user 'root'@'%' to database 'ezlogin_sdzeh' while upgrading Ezeelogin installation to the latest version.

 

After you enter as the root user check your privileges: 

mysql> show grants for 'root'@'localhost';


After checking your privileges you can try to give another user all the privileges, or you can try to give the root user all privileges again:

mysql> grant all privileges on *.* to 'root'@'localhost';


If your root user doesn't have privileges you can try to restore them, so

Stop the mysqld server, restart the server this way mysqld_safe --skip-grant-table and restore root privileges with:

mysql> flush privileges;
mysql> grant all privileges on *.* to 'root'@'localhost' with grant option;