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.

Create global mysql user

Discussion in 'General Discussion' started by veronicabend, Dec 24, 2008.

  1. veronicabend

    veronicabend Well-Known Member

    Joined:
    Feb 25, 2005
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    How can I create a global mysql user? I want this user for the automysqlbackup script. The user needs select and lock tables privileges for all databases to be able to do mysqldump.

    Thanks.
     
  2. verdon

    verdon Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    836
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Northern Ontario, Canada
    cPanel Access Level:
    Root Administrator
    wouldn't you use the (mysql) root user?
     
  3. sirotex

    sirotex Well-Known Member

    Joined:
    Jul 10, 2008
    Messages:
    121
    Likes Received:
    0
    Trophy Points:
    16
    Um, the WHM backup feature backsup all mysql db's etc.
     
Loading...

Share This Page