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.

Error on "mysqldump'

Discussion in 'Database Discussions' started by Astral God, Feb 1, 2012.

  1. Astral God

    Astral God Well-Known Member

    Joined:
    Sep 27, 2010
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Hi.

    When i try to dump all my bases, i have this error:

    Code:
    mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
  3. manokiss

    manokiss Well-Known Member

    Joined:
    Mar 31, 2002
    Messages:
    571
    Likes Received:
    0
    Trophy Points:
    16
    Hi Tristan, in fact this looks like a cpanel issue in the mysql version update process.....we have upgraded from 5.0 to 5.1 recentrly and we have a mysql backup script doing mysqldump every day, did start erroring with that message....wasnt happening with 5.0. Looks like after the update root do not have the right to lock tables. so basically you have turn on unprivileged mode grant to root the permission and then turn off unprivileged mode. Wondering if you have any fix for this, dealing with mysql permissions by hand is a bit risky. Thanx!
     
Loading...

Share This Page