Database Import Error|Help Urgent|

[indra00]

#1044 - Access denied for user 'blackboo'@'localhost' to database '146265'

This is the error i am getting when i try to import the database. I hv set disable foreign key checks when i exported it from another host.

blackboo user has been previlegdged to all permissions to the databse also.

Plz tell urgently what should i do.

[Oldiesmann]

Do you have a database called 146265? If so, make sure it's not trying to drop the database and recreate it.

[LiroyvH]

If you are using cPanel (and maybe with some other control panels, but your comment about all priviliges made me think wether it was added that way), note that you should add your cPanel username in front of the username and database.
Like if your cPanel username is "indra" then your database name is "indra_146265" and your username "indra_blackboo"

[indra00]

prob solved... for any future user who faces same problem here is wat u hv to do..

Delete this line from ur sql file by editing...

Code Select Expand

CREATE DATABASE `db name` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `db name`;