topshelfbleu Posted October 13, 2010 Share Posted October 13, 2010 Having trouble with this- Basically have created an excel csv and converted into notepad. Clicking Import in phpmyadmin - choosing CSV with Load Data and changed the ; to a comma. Clicking go I'm getting the following error : SQL query: LOAD DATA INFILE '/tmp/phpXqCUTK' INTO TABLE `tblquestions` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' MySQL said: Documentation #1045 - Access denied for user 'myusername'@'%' (using password: YES) - This doesn't make any sense to me as phpmyadmin is doing everything else okay (with user password settings). Am I being totally stupid here? Quote Link to comment https://forums.phpfreaks.com/topic/215795-import-csv-into-via-phpmyadmin/ Share on other sites More sharing options...
fenway Posted October 17, 2010 Share Posted October 17, 2010 LOAD DATA from the server requires different perms. Quote Link to comment https://forums.phpfreaks.com/topic/215795-import-csv-into-via-phpmyadmin/#findComment-1122978 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.