MySQL5.7报错mysql 配置文件目录：/etc/my.cnfroot 密码为空的时候配置文件中下面这句：skip-grant-tablesGRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '123' WITH GRANT OPTION;执行这句

解决mysqldump: Got error: 1290以及secure-file-priv option简解今天有个网友问，在用mysqldump备份时候遇到1290的错误下面是是我模拟他的报错信息
[root@potato Desktop]# mysqldump -uroot -proot -S /tmp/mysql.sock --tab=/data/mysql/

MySQL 报错 ERROR 1290 (HY000): running with the --secure-file-privmysql> show variables like '%secure%';+--------------------------+-----------------------+| Variable_name| Value|+--------------------------+-----------

ERROR 1290 (HY000) 解决办法select * into outfile '/home/update_testdbtest.txt' from update_test;ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option

MySQL关于ERROR 1290 (HY000)报错解决方法一个问题纠结很久，反复确认语法问题。但是后来网上搜了一下，茅塞顿开。特此总结一下。mysql> grant select,insert,update,delete on *.* to 'root'@'%';ERROR 1290 (HY000):