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.

WHM MySQL query for adding multiple CPanel MySQL users at once

Discussion in 'General Discussion' started by jamesbond, Jun 30, 2011.

  1. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    After restoring backups to a new server the cpanel mysql users are not showing up in WHM's PHPMyAdmin

    I have a list of all the usernames/passwords, but recreating them one by one through each site's CPanel will take a long time.

    If there is a way to just execute the SQL queries directly in WHM's PHPMyAdmin that would save my lot of time.

    Does anyone know what the query would like look for creating a new cpanel user and giving them ALL PRIVILEGES to a database?
     
  2. ravindradhainwa

    ravindradhainwa Well-Known Member

    Joined:
    Jan 24, 2008
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    You can try to restore following DB Table from old server to new server.

    /var/lib/mysql/mysql/user*
     
Loading...

Share This Page