Hi all. I have followed all the suggestions here, and it's still not working for me.
Here are some details of what I did:
First I wrote mysql -h myusername.mysql.pythonanywhere-services.com -u myusername 'myusername$default' -p --local-infile=1
It prompts me to enter my password, and I enter my Database password.
I then see this returned from the console, so everything appears to be working and my password seems to have been entered correctly and accepted by MySQL.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 131132612
Server version: 5.6.27-log MySQL Community Server (GPL)
LOAD DATA LOCAL INFILE "/home/foresight/free-zipcode-database.csv" INTO TABLE zipcode_census.zipcode_data
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
Note I entered the keyword 'LOCAL' as people have suggested. But, I still receive this following error.
ERROR 1142 (42000): INSERT command denied to user 'foresight'@'10.0.0.141' for table 'zipcode_data'
Any suggestions? It's a very frustrating problem so far.
[edit by admin: formatting]