connecting from outside host to mysql xampp

[new_programmer]

Hello guys

Can someone please tell me how to configure mysql in xampp so that I can connect to mysql from a different host

So lets say i have host A that I have xampp installed on

But I want to connect to mysql from Host B to host A.

I can access from Host A fine.. if i use localhost as a host. but when i try to connect from host B by using the ip address of host A i get
"mysql_connect() [function.mysql-connect]: Host 'host B' is not allowed to connect to this MySQL server in C:\Program Files\xampp...."

I have set username password root and gave permissions

Please help

Thanks in Advance

[Wiedmann]

I have set username password root and gave permissions

In detail you have a user "root@localhost" in MySQL. But you need a user "root@*".
--> "*" in the host part = allow access from every host.

[new_programmer]

Hi thanks for the fast reply

Where exactly can i change root@localhost to root@* ?

I set root username and password from the xampp control panel in security section

thanks

[Wiedmann]

With phpMyAdmin or any other MySQL Client (like mysql.exe).

In the MySQL manual you can read anything about usersaccounts...

[new_programmer]

With phpMyAdmin or any other MySQL Client (like mysql.exe).

In the MySQL manual you can read anything about usersaccounts...

can you please exactly give me the syntax.. or how to do that in phpMyAdmin

Thanks for your help

[new_programmer]

With phpMyAdmin or any other MySQL Client (like mysql.exe).

In the MySQL manual you can read anything about usersaccounts...

Hi

I did as you said from phpmyadmin

But still I get the same error
Host 'Host B' is not allowed to connect to this MySQL server

[cj_nza]

The MySQL manual (that was referred to)

http://dev.mysql.com/doc/refman/5.0/en/ ... enied.html

Gives the following information relating to your error:

If the following error occurs when you try to connect from a host other than the one on which the MySQL server is running, it means that there is no row in the user table with a Host value that matches the client host:

Host ... is not allowed to connect to this MySQL server

You can fix this by setting up an account for the combination of client hostname and username that you are using when trying to connect.

If you do not know the IP number or hostname of the machine from which you are connecting, you should put a row with '%' as the Host column value in the user table. After trying to connect from the client machine, use a SELECT USER() query to see how you really did connect. (Then change the '%' in the user table row to the actual hostname that shows up in the log. Otherwise, your system is left insecure because it allows connections from any host for the given username.)