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)

Songlist's picture
Submitted by Songlist on 06/20/2012 – Made popular on 06/20/2012

Stories similar to Restore ALL USER privileges etc. MySQL

This MySQL Database Backup 1.2.1 is a free and open source software that will help us to automatically or manually backup the MySQL Database. I often confused on how to backup my existing MySQL database stored in my Windows XP box.

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'.

Tried changing the max_allowed_packet_size to 1 GB and also getting the issue.

Hi everyone.

I recently setup a Ubuntu 12.04 LAMP Server at home that I use to develop websites in corporation with clients. I've been using Ubuntu and other Linux distros for a few years, but I am new to servers and have been learning a lot.

How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be used to restore to a new database anywhere, on any MySQL server (same version of course).

NOTE: I know how to import data from a flat file via MySQL.

I have configured my MySQL Database to require passwords on all users, even root from the machine itself.

Now I discovered that there are empty Users in my Database

Reproduce: mysql -u root -p and then use mysql; & select * from user;

it gives me 2 entries, one with "localhost" and user and one with the machine's hostname and .

now i tried to access the account with mysql -u ' ' (yes it's

Here is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup...

Long story short: I have many accounts in WHM, many domains. However, most of the MySQL databases were created under one user, "admin" (let's say it's admin.com). I recently moved the admin.com account to another web server , and now I need to move it back. I would like to restore this account from a backup made by that web server.

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full Database

Here is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup files.  The backup script handles innodb and myisam tables separately.