#1044 - Access denied

[jerome1g]

To all,

I am trying to import a .sql file that will create a database with a user and tables and data into x10hosting(free account)
I get the following message:

Error
SQL query:

CREATE DATABASE IF NOT EXISTS `jerome1g_career1transit` /*!40100 DEFAULT CHARACTER SET latin1 */;

MySQL said:

#1044 - Access denied for user 'jerome1g'@'localhost' to database 'jerome1g_career1transit'

In addition on the "SQL" tab(phpMyadmin) I see the following:

Run SQL query/queries on server "localhost":

create database jerome

#1044 - Access denied for user 'jerome1g'@'localhost' to database 'jerome'

I believe these are the same errors
Do I need to change some setting or something ?

Thank You

 

[essellar]

Databases must be created via cPanel (use the database wizard) in order for you to have ownership of them, and you'll need to create a database user as well. Yes, you can create a database directly, but it won't be yours, confusing though that maybe.