Copying permissions from one mysql database to another

mysql database-permissions
ming yeow picture ming yeow · Nov 2, 2010 · Viewed 7.8k times · Source

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

Answer

RobertPitt picture RobertPitt · Nov 2, 2010

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

Related questions

Grant a user permission to only view a MySQL view and nothing else

This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too. Let's say I have a table with records inserted by different users of my application. How can I give a specific user access to only see his/her …

Read More
Why does PHP PDO get "SQLSTATE[42000] [1044] Access denied for user" when mysql command line works?

My head is bloody from how hard I've been banging it against this wall for the past several hours. :( As the title suggests, I've created a MySQL user that can access the database fine from the mysql command prompt on …

Read More
Grant privileges on several tables with specific prefix

I'm using the table prefix method for having several clients use the same database. The number of tables created per client will be ~55. Instead of doing all of the granting by manually listing out the tables, can I do something …

Read More