load data infile ERROR 1045 (28000)
非root使用者在mysql server部署機器透過load data infile命令匯入資料時，
報錯：ERROR 1045 (28000): Access denied for user 'xxx'@'xxx' (using password: YES)
可能原因：這個一般是因為非root使用者沒有FILE Privilege，可以透過show grants檢視當前登陸使用者的許可權，也可以透過select mysql.user檢視某使用者的許可權，一般情況下，normal user是無FILE許可權的
解決辦法：
命令加local引數，用load data local infile 'filename' into table xxx.xxx來導資料
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20893244/viewspace-2151892/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ERROR 1045 (28000): ProxySQL Error: 報錯ErrorSQL
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)Errorlocalhost
- 使用 LOAD DATA LOCAL INFILE，sysbench 導數速度提升30%
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- mysql登入報錯提示：ERROR 1045 (28000)的解決方法MySqlError
- Linux錯誤 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxErrorlocalhost
- 解決Mysql:ERROR 1045 (28000):Access denied for user ‘root‘@‘localhost‘ (using password: NO)的方法MySqlErrorlocalhost
- MySQL 8.0.13 密碼問題 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)MySql密碼Errorlocalhost
- Mysql資料庫報ERROR 1045 (28000)報錯及MySQL忘記密碼找回MySql資料庫Error密碼
- mysqldump Got error: 1045MySqlGoError
- 使用Mysql登入時，ERREORE 1045(28000) 解決方法MySql
- MySQL load data載入資料MySql
- mysql登入遇到ERROR 1045問題解決方法MySqlError
- Ubuntu18.04：mysql：ERROR 1698 (28000): Access denied for user ‘root‘@‘localhost‘UbuntuMySqlErrorlocalhost
- load data是一個事務的
- MySQL的文字匯入之load data localMySql
- GreatSQL 並行Load Data加快資料匯入SQL並行
- Mysq-造數工具mysql_random_data_loadMySqlrandom
- ERROR：Failed to load resource: net::ERR_INCOMPLETE_CHUNKED_ENCODINGErrorAIEncoding
- Composer 提示 zlib_decode (): data errorError
- [20191129]OER 7451 in Load Indicator Error Code = OSD-04500.txtIndicatorError
- 【Jenkins】data stream error|Error cloning remote repo ‘origin‘ 錯誤解決JenkinsErrorREM
- MySQL使用普通使用者訪問返回ERROR 1698 (28000): Access denied for user 'root'@'localhost'MySqlErrorlocalhost
- Dynamics CRM CRM Reporting Error: Error occurred while fetching the data extension的解決方法ErrorWhile
- PS1045L-ASEMI超低Low VF肖特基PS1045L
- error: RPC failed； curl 18 transfer closed with outstanding read data remainingErrorRPCAIREM
- fatal: [192.168.65.128]: UNREACHABLE! => {"changed": false, "msg": "SSH Error: data could not be senFalseError
- MySQL 8.0.26 bug ERROR 1064(42000) -master-data is deprecated and will be removeMySqlErrorASTREM
- 5.7 與 8.0 對相同檔案的 LOAD DATA 語句結果不同
- Oracle OER 7451 in Load Indicator : Error Code = OSD-04500的問題處理OracleIndicatorError
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- caffe安裝問題26_error use of undeclared identifier CV_LOAD_IMAGE_COLORErrorIDE
- MySQL備份與恢復——基於OUTFILE /LOAD DATA 邏輯備份恢復MySql
- 故障分析 | MySQL 使用 load data 匯入資料錯誤的一個場景MySql
- ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sidesErrorclientServerIDE
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- kernel_data_inpage_error藍屏錯誤怎麼修復Error
- python匯入資料錯誤：ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError