Table Importing Issue with phpMyAdmin

Ice_Drake1

Registered
Jul 3, 2013
3
0
1
cPanel Access Level
Website Owner
Hi, I am an owner of a website hosted by [Removed]. I have a table importing issue with phpMyAdmin. When I tried to import data with CSV file, I get the following error:

SQL query:

LOAD DATA INFILE '/home/etheriac/tmp/php83KkA7' INTO TABLE `smf_geoip_countries` FIELDS TERMINATED BY ',' ENCLOSED BY '"'

ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 2 LINES

MySQL said: Documentation
#1045 - Access denied for user 'etheriac'@'localhost' (using password: YES)

I already raised the issue with my web service provider, but they told me that they have given me all the permissions and check everything and direct the source of the problem to elsewhere like the invalid content of my CSV files.

I checked the CSV files over myself with a private local server and the import was successful, so I took an extra step to export out the table into several SQL files since PHP has a timeout of 300 seconds. I tried importing those SQL files to the table and yet, I got a blank page after the import stops or finishes (not sure what), so I told the technical support personnel to import on my behalf; yet, they told me that they can only import database not a single table and they want only one file not broken into parts.

Disappointed by their reply, I came here to verify two things. Being unfamiliar with cpanel, I would like to verify if the technical support of my web service provider is correct about that they can't import a single table and that they can only import a database on their end.

The second thing I need to verify is if the error is coming from cpanel or not since my private server don't use cpanel. I use phpMyAdmin directly.

Here is the detail information of the virtual server and my private server:

Virtual Server:
cpanel version: 11.38.1 (build 6)
phpMyAdmin version: 3.5.8

Private Server:
phpMyAdmin version: 3.4.9
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

It's difficult to determine the exact cause of the problem without root access to the serve to reproduce the issue. You did post the following error:

#1045 - Access denied for user 'etheriac'@'localhost' (using password: YES)
This can sometimes indicate the account password needs to be updated so the MySQL password matches. It's possible your hosting provider is only a reseller without root access to complete this task. Importing a table should not be an issue using SSH as an alternative to phpMyAdmin. You are welcome to ask your hosting provider to open a ticket with us regarding this issue so we can attempt to reproduce the problem.

Thank you.
 

Ice_Drake1

Registered
Jul 3, 2013
3
0
1
cPanel Access Level
Website Owner
Going by your post it sounds like you might be using this:
geoIP (IP to Location)

If yes, you might try that forum thread.

HTH!
Yes, you are correct. I am trying to install geoIP, but that forum won't be able to help me. It is because I have been running into database problems since I can't seem to be able to import those tables successfully without getting an error. Later on, I found out that it was a permission problem coming from either cpanel or phpMyAdmin or both.
 

Ice_Drake1

Registered
Jul 3, 2013
3
0
1
cPanel Access Level
Website Owner
Hello :)

It's difficult to determine the exact cause of the problem without root access to the serve to reproduce the issue. You did post the following error:



This can sometimes indicate the account password needs to be updated so the MySQL password matches. It's possible your hosting provider is only a reseller without root access to complete this task. Importing a table should not be an issue using SSH as an alternative to phpMyAdmin. You are welcome to ask your hosting provider to open a ticket with us regarding this issue so we can attempt to reproduce the problem.

Thank you.
Thank you so much with your suggestion. I was able to import those tables to the database via SSH. In the process, I noticed that I can't log to mysql with cpanel username. I got a #1045 error as a result. Instead, I have to log in with my mysql username. The issue #1045 appears again as I attempt to import a CSV file to a table even when I am log in with mysql username.

Nonetheless, I got my tasks done. I have told the technical support of my web hosting provider to follow up with you guys on this issue. Whether they will or not is up to them. Thanks, again. This installation took me months to install properly.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Thank you so much with your suggestion. I was able to import those tables to the database via SSH. In the process, I noticed that I can't log to mysql with cpanel username. I got a #1045 error as a result. Instead, I have to log in with my mysql username. The issue #1045 appears again as I attempt to import a CSV file to a table even when I am log in with mysql username.
This indicates your hosting provider needs to update your account password via "WHM Home » Account Functions » Password Modification" and ensure that "Allow MySQL password change" is enabled.

Thank you.