Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

The system failed to drop the MySQL user error

Discussion in 'Database Discussion' started by udee, Jul 14, 2018.

Tags:
  1. udee

    udee Registered

    Joined:
    Jul 14, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    indonesia
    cPanel Access Level:
    DataCenter Provider
    hi,

    after i downgrade from mariadb 10.2 to mysql 5.6
    i got this error when i delete user
    The system failed to drop the MySQL user “xxxx” because of an error: (XID bn962q) The system received an error from the “MySQL” database “mysql”: 1728 (Cannot load from mysql.procs_priv. The table is probably corrupted)

    and the db user that should be deleted is still exist in database mysql.user but not visible by cpanel user from web
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    Try repairing the MySQL tables:
    #mysqlcheck -r mysql
    Check what error you get when it checks the table.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,961
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @udee,

    There's no supported path to downgrade from MariaDB to MySQL on cPanel & WHM. Can you let us know the full steps you took to downgrade?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice