Skip to main content
cPanel Technical Support has been heavily impacted by hurricane Beryl and our ability to respond to tickets has been hindered as a result. We appreciate your understanding and patience as we address these delays.

How to grant root user all privileges while skip-grant-table is enabled

Comments

3 comments

  • cPanelAnthony
    Hello! The
    0
  • Inna
    No, the issue is when skip-grant-tables is enabled, I cannot run queries like SET, UPDATE, INSERT, DELETE. But I only can run SELECT. When skip-grant-tables is disabled, I cannot login to mysql. When I see mysql table with skip-grants enabled, I see all _priv rows' values are Y. What I mean is when you click on root under user column which opens a new tab. There, root@localhost does not have any privileges and cannot manipulate other users (including itself).
    0
  • HostNoc
    HI Can you please run following commands and then test GRANT ALL PRIVILEGES ON . TO 'root'@'%'WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; Regards HostNoc
    0

Please sign in to leave a comment.