开发者

phpMyAdmin/MySQL export users/priviledges for later import

开发者 https://www.devze.com 2023-03-07 16:51 出处:网络
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.

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 re开发者_JAVA技巧lations would be kept and so on.

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

Thanks in advance!


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号