Page 1 of 1

error #1044 - Access denied

Posted: Wed Jan 04, 2012 8:38 am
by comodo
Hi!

I want to import my localhost database to internet server but it shows me error #1044 - Access denied for user ' '@'localhost' to database 'mydatabase'
I created new user in localhost database privileges and gave all access.
Also I checked my configuration file.
All seems to be correct but it still shows me error :S

Help please?

Re: error #1044 - Access denied

Posted: Wed Jan 04, 2012 1:01 pm
by Christopher
You don't say what database you are using? the error says the user is ''. That looks suspicious.

Re: error #1044 - Access denied

Posted: Thu Jan 05, 2012 1:40 am
by comodo
I use phpmyadmin. Or what do you want to know exactly?
I deleted user name from the sentence. #1044 - Access denied for user 'myusername '@'localhost' to database 'mydatabase'

Re: error #1044 - Access denied

Posted: Thu Jan 05, 2012 10:25 am
by pickle

Re: error #1044 - Access denied

Posted: Wed Jan 11, 2012 12:57 pm
by JohnK_UK
I ran into the same problem myself a while ago. For me the problem was the access I'd granted myself. (I was using MySQL Administrator rather than MySQLAdmin...) The hostname "%" allows access from every host *except* localhost. You have to add localhost separately.

Could that be your problem?