Help please... Newbie.. [host' not allowed to connect]

[expired user #3407]'s profile image [expired user #3407] posted 16 years ago in Creating a connection Permalink
I already install the HeidiSQL and MySQL
my friend already give the username , Hostname, and Password
But. all i got is always like this..



I know that this problem have already been posted, but when i open it. idk what to do.. sorry.. i'm so new wit this things.. but i really need to use this program..

I pass Firewall and Norton.



Please need help..
you can scold me if u want..
but, i'm hoping u can fix my problems..

thanks..
Rare
ansgar's profile image ansgar posted 16 years ago Permalink
The message "... is not allowed to connect to this MySQL server" says that the server is giving you the message, not the client computer. So it's definitely a problem with your user account on the server. I guess he associated your account with a specific hostname or IP. If you want to connect over the public internet he has to edit your account. For example he can do so with HeidiSQL:
- Go to Tools > Usermanager
- Click on the "Edit users" tab
- Click on the relevant user
- Push the button "Edit user ..."
- Change whatever is put into the Host field to "%":
1 attachment(s):
  • edituser
[expired user #3407]'s profile image [expired user #3407] posted 16 years ago Permalink
ok..
i can go in now..
Thanks alot
thanks alot thanks alot

Rare..
GBu

Please login to leave a reply, or register at first.