root账户下导入csv提示错误
- #1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
复制代码
根据网上教程修改secure_file_priv后
- show variables like '%secure%'
- require_secure_transport OFF
- secure_auth ON
- secure_file_priv
复制代码
修改配置后,再次导入又有新的问题
- #29 - File '/tmp/php5SEegs' not found (Errcode: 13 - Permission denied)
复制代码
环境
php 7.4
phpmyadmin 5.0/4.9
mysql 5.7
|
|