All geek questions in one place

Copy permissions from one mysql database to another

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

+3
source share
2 answers

You should take a look at the question on Server Error .

+5
source

Not really.

I think it is best to query tables information_schema( SCHEMA_PRIVILEGES, TABLE_PRIVILEGES, USER_PRIVILEGES) and use this data to create GRANTqueries

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

+1
source

Source: https://habr.com/ru/post/1772567/

More articles:


All Articles