Copying permissions from one mysql database to another

Question

I would like to replicate the permissions from one database to another. Could that be done by simply copying the mysql table over?

score 5 · Accepted Answer · edited Apr 13 '17 at 12:13

5

You should take a look at this question on Server Fault.

edited Apr 13 '17 at 12:13

Community

1
1

answered Nov 01 '10 at 23:10

RobertPitt

56,863
21
114
161

score 1 · Answer 2 · answered Nov 01 '10 at 23:07

1

Not really.

I think your best bet is to query information_schema tables (SCHEMA_PRIVILEGES, TABLE_PRIVILEGES, USER_PRIVILEGES) and use this data to create GRANT queries

See more here: http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html

answered Nov 01 '10 at 23:07

Mchl

61,444
9
118
120

Copying permissions from one mysql database to another

2 Answers2