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
    vi editor not working , insert and delete not working in ssh
    Viewed 3341 times since Wed, Jun 14, 2017
    Trying to install or update a seondary as primary. Use -as_primary option to force it.
    Viewed 445 times since Tue, Oct 27, 2020
    No Two-factor Authentication configured. Contact Administrator
    Viewed 69 times since Tue, Feb 2, 2021
    error: User modify failed Cannot modify user on this node: OS=FreeBSD: Command not found. OS: Undefined
    Viewed 2366 times since Wed, Jun 14, 2017
    unable to start mysql in ubuntu 14 " logger command not found"
    Viewed 3310 times since Thu, Jun 15, 2017
    How to install node in Ezeelogin gateway server?
    Viewed 188 times since Mon, Dec 7, 2020
    Backup Ezeelogin failed during Ezeelogin version upgrade
    Viewed 445 times since Tue, Jul 28, 2020
    NODE_RDP_PROTOCOL_X224_NEG_FAILURE()
    Viewed 6034 times since Fri, Feb 2, 2018
    Can’t connect to local MySQL server through socket ’3306 ’ in ezsh.log
    Viewed 2469 times since Thu, Jun 15, 2017
    Error opening terminal: xterm-256color.
    Viewed 1408 times since Wed, Jul 31, 2019