6

Restore ALL USER privileges etc. MySQL

view full story
linux-howto

http://forums.cpanel.net – Situation: Somehow the mysql.user table got emptied. No more root access, all websites that used the database (shared hosting) were down. Reason unknown. I restored root password and access. So far so good. Now I need to restore the users' accounts and privileges. <- BAHM problem!! WHM is configured to backup, and to backup account data, whatever that means because I could not find a backup of the mysql system data. (only users' databases were tar.gz-backuped). So I dropped the user table completely, and restoring it from the files in the "full backup". (these are no sql-dumps (HowTos)