chaseman Posted March 19, 2011 Share Posted March 19, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/231136-cant-create-database-access-denied-1044/ Share on other sites More sharing options...
amir78 Posted March 19, 2011 Share Posted March 19, 2011 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? Quote Link to comment https://forums.phpfreaks.com/topic/231136-cant-create-database-access-denied-1044/#findComment-1189707 Share on other sites More sharing options...
chaseman Posted March 19, 2011 Author Share Posted March 19, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/231136-cant-create-database-access-denied-1044/#findComment-1189734 Share on other sites More sharing options...
fenway Posted March 29, 2011 Share Posted March 29, 2011 Well, you can drop all of the privileges, but that seems like overkill... just check the GRANTs for that user. Quote Link to comment https://forums.phpfreaks.com/topic/231136-cant-create-database-access-denied-1044/#findComment-1193913 Share on other sites More sharing options...
chaseman Posted March 29, 2011 Author Share Posted March 29, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/231136-cant-create-database-access-denied-1044/#findComment-1193926 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.