[email]yashgt[/email] wrote:Is your firewall blocking port 3306?> 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
> 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.
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
JDS Computer Training Corp.