Question: |
Good day!I want to use a query with LOAD DATA INFILEБД says #1045 - Access denied for user `samsonsh`@`localhost` (using password: YES)How can I obtain a permit? |
Answer: |
Hello use palihawadana database. not samsonsh created in the panel |
Question: |
I`m doing the query directly in phpMyAdmin.How can I use another user? |
Answer: |
what is the query? |
Question: |
Here it is:LOAD DATA INFILE `public_html/maxstoreclon/for_export_completed_all.csv` INTO TABLE `import_prices` FIELDS TERMINATED BY `;` ENCLOSED BY `\"`LINES TERMINATED BY `\\n` |
Answer: |
in a request refers to an invalid file path |
Question: |
Well!And it would be nice if You just wrote to me correct :)so, how to specify the correct? |
Answer: |
unfortunately, so imports will not poluchaetsya. this requires super privileges, which of course you do not |
Question: |
And how can you make the import? |
Answer: |
the Question referred to the administrator, wait for amp. |
Question: |
Thank you!wait. |
Answer: |
import can be done in menu - import in phpmyadmin selects Ebisu , choose the type of import file and import |
Question: |
Yes, the import worked.Thank you!!! |
Answer: |
Thank you, that appealed to customer support. |