I have created a database, named LoginData and I am invoking mysql from the bash console as follows:
$ mysql -h davesedar.mysql.eu.pythonanywhere-services.com -u davesedar -p 'davesedar$LoginData'
this correctly opens mysql>
I have created table Logins using (which appeared to work):
CREATE TABLE logins (id INT NOT NULL AUTO_INCREMENT, mydate DATE NOT NULL, mytime TIME NOT NULL, user_id VARCHAR(50) NOT NULL, user_name VARCHAR(50) NOT NULL, project VARCHAR(50) NOT NULL, PRIMARY KEY (id));
However when I try to load data from a CSV file:
LOAD DATA INFILE "/home/davesedar/Apr-23.csv" INTO TABLE logins FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS (id, mydate, mytime, user_id, user_name) SET project = 'Admin';
MySQL does not request a password, but rather fails:
ERROR 1045 (28000): Access denied for user 'davesedar'@'%' (using password: YES)
I have read numerous similar posts, with answers, but none help