Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)

by

Assuming by full dump you also mean the VIEWs and the EVENTs, you would need:

GRANT USAGE ON *.* TO 'dump'@'%' IDENTIFIED BY ...;
GRANT SELECT, LOCK TABLES ON `mysql`.* TO 'dump'@'%';
GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON `myschema`.* TO 'dump'@'%';

and if you have VIEWs that execute a function, then unfortunately you also need EXECUTE.

My own problem is: why do I need SELECT if I only want to make a no-data dump?

More Related Contents:

  1. Mysql service won’t start, InnoDB init function error
  2. MyISAM versus InnoDB [closed]
  3. PDO get the last ID inserted
  4. Compare two MySQL databases [closed]
  5. In MySQL queries, why use join instead of where?
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. Storing image in database directly or as base64 data?
  8. Implementation of Levenshtein distance for mysql/fuzzy search?
  9. Primary keys with Apache Spark
  10. SQLite – ORDER BY RAND()
  11. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  12. Partial Dependency (Databases)
  13. Can I rollback a transaction I’ve already committed? (data loss)
  14. How to backup sqlite database?
  15. Microservices with shared database? using multiple ORM’s? [closed]
  16. MySQL grant all privileges to database except one table
  17. What’s the best strategy for unit-testing database-driven applications?
  18. How to increase MySQL connections(max_connections)?
  19. MySql views performance [closed]
  20. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  21. How does MySQL Auto Increment work?
  22. com.mysql.jdbc.PacketTooBigException
  23. Create MySQL database from Java
  24. Normal forms – 2nd vs 3rd – is the difference just composite keys? non trivial dependency?
  25. How to think in data stores instead of databases?
  26. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  27. Is it a good idea to use an integer column for storing US ZIP codes in a database?
  28. How to grant remote access to MySQL for a whole subnet?
  29. MySQL: Check if the user exists and drop it
  30. Pros/cons of document-based databases vs. relational databases

Leave a Comment