The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How To Reset All Mysql Permissions

Discussion in 'General Discussion' started by techv, Apr 11, 2004.

  1. techv

    techv Member

    Joined:
    Jul 23, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    One of my people was playing around in a PHPADMIN session and deleted all permissions for mysql LOCALHOST

    I would like to restore all Myql LOcalhost permissions to what they were when Cpanel was first installed.

    Can someone tell me how to do this.

    Thanks

    Howard
     
  2. Planet_Master

    Planet_Master Well-Known Member

    Joined:
    Apr 18, 2002
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    New Yorker
    Reset your MySql password in WHM, this should generate the correct permissions.
     
  3. techv

    techv Member

    Joined:
    Jul 23, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Tried to reset mysql permissions

    Did what you suggested and set new Mysql password in WHM, and then clicked on Phpmyadmin and then clicked on Databases and clicked on MYSQL in the drop down of all databases.....then I clicked on USER and got the following error.

    Users and global privileges

    Error

    SQL-query :

    SHOW KEYS FROM `user`

    MySQL said:


    #1142 - select command denied to user: 'root@localhost' for table 'user'

    [Documentation] · [Back]
     
  4. techv

    techv Member

    Joined:
    Jul 23, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    ALSO PROBLEM FINDING USERS IN CPANEL

    Also, I noted when entering the CPANEL control panels for all clients using a mysql database that the database names appeared, but there were NO USERS displayed???

    HELP.
     
  5. Planet_Master

    Planet_Master Well-Known Member

    Joined:
    Apr 18, 2002
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    New Yorker
    Just try to restart mysql with --skip-grant-tables option
    And recreate your root user


    This should reset permissions.
     
    #5 Planet_Master, Apr 12, 2004
    Last edited: Apr 12, 2004
  6. techv

    techv Member

    Joined:
    Jul 23, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Re: Restarting Mysql with skip-grant-tables option

    Dear Planet_Master:

    In WMH there is only an option to restart mysql, and nothing there that Ican see than allows me to restart mysql with --skip-grant-tables option, and recreate a root user

    We are novices.

    Can you let me know exactly what to type in an SSH session at the root that will enable me to:

    1 - restart mysql with --skip-grant-tables option
    2- recreate my root user

    How will I know who the root user is?

    I think it's root@localhost.com?

    Howard
     
Loading...

Share This Page