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!

How do you restore database user manually from mysql.sql file?

Discussion in 'Database Discussion' started by JonathanLIVE, Feb 5, 2006.

  1. JonathanLIVE

    JonathanLIVE Well-Known Member

    Nov 1, 2003
    Likes Received:
    Trophy Points:
    I just had a really strange thing happen. Customer with 25 WP blogs.. suddenly all of his database user names are GONE... I downloaded the last backup and the file where this is normally stored is the file in the root that is mysql.sql.

    I went back a week and found all the names in there.. now I need to restore it but I haven't been able to find any way to do this. How can I take the mysql.sql file from the backup file and put back all the database user accounts... the databases are still there.. it's JUST the user names gone...

    Do any of you have any idea what would cause this? I know it's not user error. Please I need to get these sites back up quick!

  2. WestBend

    WestBend Well-Known Member

    Oct 12, 2003
    Likes Received:
    Trophy Points:
    slow method : just create the db users again and grant them the rights.
    Check the WP files for username and password required by each blog for each database.

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