I created a mySQL database in cPanel called tstewart_tsunami, as well as a user tstewart_root, which I then gave access to the database and gave it full privileges. Additionally I used the '%' wildcard to allow remote access to any host. I log into the database using the command line: C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -h johnny.heliohost.org -u tstewart_root -p tstewart_tsunami and created a table in tstewart_tsunami called sourceEvents, and I want to load the data from a tab delimited file into this table. I tried to do this using this statement:
mysql> LOAD DATA INFILE 'C:\Documents and Settings\tstewart\WebSites\ExamplesSite\tsevent.txt' INTO TABLE sourceEvents;
but I get the error: I have not really done this before so perhaps I am missing something, but I thought that by adding the user to the database and allowing remote connections this should work. I should note that after connecting to my database in Visual Studio I could see the new table, and when I check the DB in cPanel I can see that the table was created. So apparently I can remotely create tables but for some reason I cannot load data into them.