mysqldump帐号分析

zhgc

create user 'dumper'@'%' IDENTIFIED BY 'dumper';
mysqldump: Couldn't execute 'FLUSH /*!40101 LOCAL */ TABLES': Access denied; you need the RELOAD privilege for this operation (1227)
grant reload on *.* to dumper@'%';
mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation (1227)
grant replication client on *.* to dumper@'%';
此时没有报错，得到的空数据

1. -- MySQL dump 10.13  Distrib 5.1.72, for Win64 (unknown)
   
2. --
   
3. -- Host: 127.0.0.1    Database:
   
4. -- ------------------------------------------------------
   
5. -- Server version        5.1.72-community-log
   
6. 
   
7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   
8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   
9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
   
10. /*!40101 SET NAMES utf8 */;
    
11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    
12. /*!40103 SET TIME_ZONE='+00:00' */;
    
13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    
14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    
15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    
16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    
17. 
    
18. --
    
19. -- Position to start replication or point-in-time recovery from
    
20. --
    
21. 
    
22. -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000034', MASTER_LOG_POS=106;
    
23. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    
24. 
    
25. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    
26. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    
27. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    
28. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    
29. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    
30. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    
31. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    
32. 
    
33. -- Dump completed on 2022-05-03 10:00:44

复制代码