mo926983的博客

mysql8.0.19 系统 windows10MySQL 报错[Code: 1290, SQL State: HY000] The MySQL server is running with the –secure-file-priv option so it cannot execute this statement通过show variables like ‘%secure_file_priv%’;secure_file_priv参数说明这个参数用来限制数据导入和导出操作的效果，例如执行LOA

一、卸载停止mysql服务net stop mysql卸载mysql服务cd C:\Program Files\mysql\binmysqld -remove删除文件删除mysql安装目录整个文件夹删除注册表启动cmd->输入regedit->搜索mySQL，右键全部删除（或者依据以下路径找到MySQL，右键删除）HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQLHKEY_