My SQL Access Denied

[mcthon]

Hi,

I'd like to import the content of my website from my last mysql Server to the X10Hosting mysql server. I' don't know why but each time that i try the import button from phpmyadmin it tell me :
Erreur

requête SQL:
--
-- Base de donn�es: `dotclear`
--
USE `d otclear `;
MySQL a répondu:
#1044 - Access denied for user 'mcthon'@'localhost' to database 'dotclear'

I have created a user mcthon_mcthon that get all privilege and didn't help.

Please Help !!

Tanks
​

 

[Corey]

Do this:
Create the database and assign the user privileges. Open your SQL backup and delete any of the header information along with the CREATE DATABASE part so all that is left is the create tables and rows. Then import the file.

-Corey

 

[mcthon]

Sweet!!!

It's working...

Thanks!!