search

phpmyadmin / phpmyadmin

A web interface for MySQL and MariaDB
https://www.phpmyadmin.net/
GNU General Public License v2.0
7.23k stars 3.38k forks source link

Problems Uploading csv file into My SQL #2024

Closed pma-import closed 9 years ago

pma-import commented 21 years ago

Hi, I am trying to resolve an issue with uploading csv files into MySQL.

I have a MySQl server database hosted by www.oneandone.co.uk

I have created the Database structure, exported the structure to csv and added all records.

When I attempt to upload using PhpMyAdmin (latest release).

I get the following error

MySQL said Access Denied for user on db***@server (using password: YES)

I have checked with oneandone and they keep saying everythings ok.

They inserted the csv file themselves with no problems.

In order to resolve this I am trying to find out if there are settings besides servername, database name, user id, password that I need to complete to ensure that csv upload works.

Cheers

Raj

pma-import commented 21 years ago

Logged In: YES user_id=210714

Did you try other operations, like creating a table and inserting rows in it?

pma-import commented 21 years ago
pma-import commented 21 years ago

Logged In: YES user_id=739062

I can create tables and insert data into the table with no problem's. It is inly when I try to insert a csv file that I get the access denied for user message.

pma-import commented 21 years ago

Logged In: YES user_id=739062

I can create tables and insert data into the table with no problem's. It is inly when I try to insert a csv file that I get the access denied for user message.

pma-import commented 21 years ago

Logged In: YES user_id=473563

Does your provider import your CSV file with exactly the same user as you're accessing your phpMyAdmin with?

I guess your user doesn't have the FILE privilege and the provider used another DB user...

Regards, Garvin.

pma-import commented 21 years ago
pma-import commented 21 years ago

Logged In: YES user_id=473563

No answer. Should be related to the (FILE) privileges.

pma-import commented 21 years ago