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?
error #1044 - Access denied
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: error #1044 - Access denied
You don't say what database you are using? the error says the user is ''. That looks suspicious.
(#10850)
Re: error #1044 - Access denied
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'
I deleted user name from the sentence. #1044 - Access denied for user 'myusername '@'localhost' to database 'mydatabase'
Re: error #1044 - Access denied
Have you checked here: http://dev.mysql.com/doc/refman/5.1/en/ ... enied.html ?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Re: error #1044 - Access denied
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?
Could that be your problem?