mysql使用mysqldump.exe导出为sql脚本，进行导入时出现ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation。
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.
Warning: A dump from a server that has GTIDs enabled will by default include the GTIDs of all transactions, even those that were executed during its extraction and might not be represented in the dumped data. This might result in an inconsistent data dump.
In order to ensure a consistent backup of the database, pass --single-transaction or --lock-all-tables or --source-data.
这段错误的内容其实包含着答案；将--set-gtid-purged=OFF包含在mysqldump.exe命令的参数中即可。
标签：1227,exe,dump,--,Access,mysqldump,ERROR,GTIDs From： https://www.cnblogs.com/XingXiaoMeng/p/18089691