Phpmyadmin Sql Import

[lhite]

i'm trying to import a MySQL database with phpMyAdmin and am getting an error message:

 

#1044 - Access denied for user 'xxxxxxxx'@'localhost' to database 'milb'

 

where xxxxxxxx is my control panel user name, and the user name with which i logged in to the control panel. how do i get past this access error?

[TCH-Thomas]

The error 1044 indicates it could be a user name problem.

I would open a ticket with the help desk and ask them to help with this. Link in my signature.

[lhite]

The error 1044 indicates it could be a user name problem.

I would open a ticket with the help desk and ask them to help with this. Link in my signature.

 

will do -- thanks!

[lhite]

it's always the simple solutions that drive you up the wall.....

 

problem was that in the dump file, you need to change the name of the database so that it is prefaced with your control panel user name, as that's the way all the databases are named on the TCH server.

 

the first two lines of the dump file will typically look like:

 

CREATE DATABASE IF NOT EXISTS `milb` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `milb`;

 

you edit the file and change the database name to what the TCH server expects:

 

CREATE DATABASE IF NOT EXISTS `xxxxxxxx_milb` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `xxxxxxxx_milb`;

 

where xxxxxxxx is your control panel user name. from there everything works fine!

[TCH-Bala]

Thank you for sharing what the problem was.