我有一个文本文件,我想加载到MySQL数据库中。
当我执行命令时:
load data infile '/saurabh/chk1.txt'
into table chk1 fields terminated by 't' lines terminated by 'n';
我得到错误:
ERROR 1045 (28000): Access denied for user 'saurabh'@'localhost' (using password: YES)
由于我认为这是一个许可问题,我使用了show grants
命令,
GRANT USAGE ON *.* TO 'saurabh'@'localhost' IDENTIFIED BY PASSWORD '*40639DEF'
GRANT ALL PRIVILEGES ON `saurabh`.* TO 'saurabh'@'localhost' .
请参阅这篇文章,Mysql权限错误带有';加载数据';
尝试:grant file on *.* to saurabh@localhost identified by 'saurabh'
尝试将要加载的文件放在公用目录(C:UsersPublic
)中,然后再次尝试加载。这就是我解决问题的原因。