Hi,
I have a MySQL server 5.0 running on my Windows XP professional PC
named PS0160. I am able to connect to it locally.
However my colleague using a different PC PS0322, and who also has
mysql, wants to connect to it. How do I setup the server to make this
possible.
After reading some articles, I have done the following:

use mysql;
grant all privileges on *.* to user1@'%' identified by 'pwd123' with
grant option ;
insert into host values('ps0322','%', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');

When we try to connect from PS0322 using:
mysql --host=ps0160 --user=user1 -ppwd123
we get the following error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'ps0160' (10060)

Nothing helpful seems to be available on the net.
Please let us know how to enable remote access.

Thanks

yashgt@gmail.com wrote:
> Hi,
> I have a MySQL server 5.0 running on my Windows XP professional PC
> named PS0160. I am able to connect to it locally.
> However my colleague using a different PC PS0322, and who also has
> mysql, wants to connect to it. How do I setup the server to make this
> possible.
> After reading some articles, I have done the following:
>
> use mysql;
> grant all privileges on *.* to user1@'%' identified by 'pwd123' with
> grant option ;
> insert into host values('ps0322','%', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
> 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');
>
> When we try to connect from PS0322 using:
> mysql --host=ps0160 --user=user1 -ppwd123
> we get the following error:
> ERROR 2003 (HY000): Can't connect to MySQL server on 'ps0160' (10060)
>
> Nothing helpful seems to be available on the net.
> Please let us know how to enable remote access.
>
> Thanks
>

Is your firewall blocking port 3306?

Also - it shouldn't be necessary to insert into host. Just granting
privileges should be sufficient. But since you did, did you reload your
privilege tables afterwards?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================