Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    168
    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:
    1
    Trophy Points:
    56
    Hi,

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

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

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice