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 so it cannot execute this statement
mysql> select * from update_test;
+------+-------+
| id | name |
+------+-------+
| 1 | hello |
| 2 | world |
+------+-------+
2 rows in set (0.00 sec)
mysql> show variables like '%secure%'
-> ;
+--------------------------+-----------------------+
| Variable_name | Value |
+--------------------------+-----------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | /var/lib/mysql-files/ |
+--------------------------+-----------------------+
3 rows in set (0.01 sec)
mysql> select * into outfile '/var/lib/mysql-files/update_testdbtest.txt' from update_test;
Query OK, 2 rows affected (0.00 sec)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28282660/viewspace-2212396/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- 遠端連線MySQL資料庫提示:ERROR 1130 (HY000)的解決辦法MySql資料庫Error
- FTP Connection refused error 解決辦法FTPError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- Vue 下 ESLint 的 error 解決辦法VueEsLintError
- Openstack的error殭屍例項的解決辦法Error
- Myeclipse 錯誤An internal error has occurred 解決辦法EclipseError
- mysqldump Got error 1290MySqlGoError
- Linux:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- mysqldump error1066 錯誤的解決辦法MySqlError
- RuntimeError: cuDNN error: CUDNN_STATUS_EXECUTION_FAILED解決辦法ErrorDNNAI
- VS 2017 Git failed with a fatal error的解決辦法GitAIError
- iOS Error Domain=NSURLErrorDomain Code=-999 “cancelled” 解決辦法iOSErrorAI
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- Navicat tnt版本提示“failed to save password error code”的解決辦法AIError
- 安裝VMware出現“Error 1406”的解決辦法Error
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- ERROR2002(HY000):CantconnecttolocalMySQLserverthroughsocket的解決方法ErrorMySqlServer
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- Cargo invocation has failed: Error: exit code: 101.解決辦法CargoAIError
- 使用 Sublime 工具時報Decode error - output not utf-8解決辦法Error
- 安裝MySql出現Error Nr.1045的解決辦法MySqlError
- Proguard returned with error code 1. See console解決辦法”Error
- oracle 啟動不了 ora-12514 error 解決辦法OracleError
- ERROR 1114 (HY000): The table 'test1' is full 的解決Error
- MySQL ERROR 1366(HY000):Incorrect string value:''for column''at row 1解決方案MySqlError
- MySQL 亂碼實戰解決ERROR 1366 (HY000): Incorrect string value: 'MySqlError
- github慢解決辦法Github
- Grub Rescue解決辦法
- /dev/null解決辦法devNull
- MSBuild Tools解決辦法UI
- 在Linux Mint中安裝Clion遇到CMake Error的解決辦法LinuxError
- Error:/etc/fstab:Read-only file system錯誤的解決辦法Error
- 檔案無法粉碎解決辦法
- 【Error】AttributeError: module ‘scipy.misc‘ has no attribute ‘logsumexp‘ 的解決辦法Error
- mongodb錯誤解決辦法-bash: ./mongod: cannot execute binary file: Exec format errorMongoDBORMError