MySQL import

theraven · #1 11-10-2007, 09:52 PM

I just signed up today and am having some issues importing the SQL file from my old host over to HostGator. I created a database and user using the Cpanel, but when I try to import the old SQL file through PHPMyAdmin I get the following message (with the username and database blanked out):
#1044 - Access denied for user '***'@'localhost' to database '***'

Can anyone shed some light on what I'm doing wrong?

Thanks.

GvilleRick · #2 11-10-2007, 09:58 PM

Did you add the user to the database? After you create the database and user you will need to add the user to the database using the dropdown menu in the MySQL section.

theraven · #3 11-10-2007, 10:01 PM

Yes, I added the user to the database. I guess one of my first questions would be how to login as that user when using phpMyAdmin - because I don't see any option to do so when clicking the phpMyAdmin link from the Cpanel.

GvilleRick · #4 11-10-2007, 10:10 PM

phpMyAdmin should be able to access any databases created by your username. Sounds like you should contact the Help Desk and have someone take a look.

If the old host ran cPanel you can request having HG move the site over. That would include all of the databases, etc.

Goddess Dix · #5 11-11-2007, 09:41 AM

Quote:

Originally Posted by theraven

Yes, I added the user to the database. I guess one of my first questions would be how to login as that user when using phpMyAdmin - because I don't see any option to do so when clicking the phpMyAdmin link from the Cpanel.

the user is added to the database in the cpanel mysql options, not from phpmyadmin. it lists databases and users and you attach the users to the database there. don't forget that both databases and users are started with your account user name, so a db named database1 with would be called user_database1, and the user name would be user_databaseusername...

theraven · #6 11-11-2007, 05:45 PM

Thanks, Support was able to import the SQL file (they had to comment out a couple lines). My site is pretty much moved over now, but I'm having an issue with SEF turned on in Mambo for some reason. I've submitted a request for Support to take a look at it.

neocorps · #7 12-04-2008, 03:23 PM

hi!, do u know what lines were commented from the sql file?, because i have a database from wamp i want to upload, but i seem to have the same problem that you have.

Thx

quietFinn · #8 12-04-2008, 03:43 PM

Quote:

Originally Posted by neocorps

hi!, do u know what lines were commented from the sql file?, because i have a database from wamp i want to upload, but i seem to have the same problem that you have.

Thx

Most likely the lines where the database is created.
You can't create a database in cPanel's PHPMyAdmin.

lsuedulive · #9 12-06-2008, 06:59 PM

Sounds like from 2007 you are the DB and SQL expert.

Good for you.

Quote:

Originally Posted by GvilleRick

Did you add the user to the database? After you create the database and user you will need to add the user to the database using the dropdown menu in the MySQL section.

corbacho · #10 07-27-2009, 12:39 PM

Hi, I have same kind of problem and I fix it this way:

If you have a phpMyadmin backup file, (.gz file) don't try to restore it through phpMyadmin, it will tell u access denied and other errors due of the fact that is different username

The right way to do it, it's through cPanel -> Backup -> Restore MySQL

But first, open the .sql file and delete or comment the lines at the beggining that says about CREATE DATABASE (...), USE DATABASE (...)

That's all, hope it helps to someone