Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpMyAdmin/MySQL export users/priviledges for later import

Is there a way to export priviledges/users out of phpMyAdmin version 3.3.9? And yes, in such format that later those could be imported into a new installation.

It would be good if database relations would be kept and so on.

If phpMyAdmin cannot handle it, MySQL command line solution will work too.

Thanks in advance!

like image 648
tomsseisums Avatar asked May 23 '11 18:05

tomsseisums


1 Answers

Basically you want to dump some tables from mysql database, like columns_priv,db,tables_priv and user

As far as I remember phpmyadmin have configuration option to hide some databases, but you can access it by typing ?db=mysql in url.

like image 76
dev-null-dweller Avatar answered Oct 08 '22 19:10

dev-null-dweller