Can't Create Database -> Access Denied #1044

[chaseman]

When I try to create a database I get the error message:

 

#1044 - Access denied for user 'chase'@'localhost' to database 'test'

 

The MySQL database is on a shared hosting server and I operate it with phpMyAdmin in CPanel. I used to be able to create databases and I already have 3 databases, but I must have accidentally changed a setting and now suddenly I'm not able to create any more databases.

 

I've tried googling but I come across a lot of cryptic text that's hard to decipher. I've looked for the right syntax to grant ALL rights to user but every command I find contains "on -database-" in the command. But I think I don't need to grant myself privileges, since I'm the only user, so I should have all privileges already, right?

 

 

What could be the cause for this problem?

 

Any ideas?

 

What I'm doing:

 

I simply go into the SQL register of phpMyAdmin and then I type in:

 

 

create database test;

 

This works on my local server but creates the error access denied on my shared hosting server.

 

EDIT: MySQL version: 5.1.52

[amir78]

Have you checked the user table for MYSQL in PHPmy Admin?

The user/admin account you are using is it allowed to connect from other IP reather than localhost?

[chaseman]

Unfortunately I'm not even able to call the user table, when I try to run the command:

 

desc mysql.user;

 

 

I get the error:

 

#1142 - SELECT command denied to user 'chase'@'localhost' for table 'user'

 

 

Is there a way to RESET MySQL completely? As of now I don't have anything serious on there anyway, it wouldn't harm if the 3 databases I have now get deleted.

[fenway]

Well, you can drop all of the privileges, but that seems like overkill... just check the GRANTs for that user.

[chaseman]

Sorry for not keeping you up to date, this forum doesn't have a solved button anymore otherwise I would have marked it as such. Well, it was a misunderstanding on my part regarding my web host, to create a database you have to go to the special section for it inside cpanel, other than that you can do pretty much everything inside phpMyAdmin.

 

My web host is Hostgator, if somebody is wondering.

 

See ya.