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

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;

    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    what port should i open on my server firewall to fetch ezeelogin license?
    Viewed 2882 times since Wed, Aug 16, 2017
    502 on login with nginx
    Viewed 2558 times since Wed, Jun 14, 2017
    Unable to open ssh session
    Viewed 2446 times since Thu, Jun 15, 2017
    Could not download binary package. Please manually download it from downloads.ezeelogin.com
    Viewed 567 times since Thu, Apr 4, 2019
    Blank page when clicking add server
    Viewed 1957 times since Wed, Aug 16, 2017
    F1 - F4 keys not working in ezsh when using PuTTY
    Viewed 20589 times since Wed, Jun 14, 2017
    reCaptcha images not loading
    Viewed 2957 times since Wed, Jun 14, 2017
    "Error: LDAP extension is not installed".
    Viewed 2627 times since Fri, Sep 8, 2017
    Disable two factor authentication (2FA Google, Yubikey , Access Keyword, DUO)
    Viewed 9607 times since Thu, Jun 15, 2017
    strange characters in the SSH logs recordings
    Viewed 2330 times since Thu, Jun 15, 2017