Copying permissions from one mysql database to another

I would like to replicate the permissions from one database to another. Could that be done by simply copying the mysql t开发者_如何学运维able over?

---

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

---

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