error #1044 - Access denied

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
comodo
Forum Newbie
Posts: 3
Joined: Fri Dec 09, 2011 7:43 am

error #1044 - Access denied

Post 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?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: error #1044 - Access denied

Post by Christopher »

You don't say what database you are using? the error says the user is ''. That looks suspicious.
(#10850)
comodo
Forum Newbie
Posts: 3
Joined: Fri Dec 09, 2011 7:43 am

Re: error #1044 - Access denied

Post 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'
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: error #1044 - Access denied

Post by pickle »

Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
JohnK_UK
Forum Newbie
Posts: 5
Joined: Wed Jan 11, 2012 12:16 pm

Re: error #1044 - Access denied

Post 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?
Post Reply