8 messages in com.mysql.lists.javaRe: Connecting to an external mysql s...| From | Sent On | Attachments |
|---|---|---|
| Bruce Scharlau | 27 Mar 2002 19:52 | |
| Tommy Yin | 28 Mar 2002 07:23 | |
| Tommy Yin | 01 Apr 2002 08:38 | |
| yilmaz | 02 Apr 2002 01:37 | |
| Tim Endres | 02 Apr 2002 07:03 | |
| yilmaz | 02 Apr 2002 08:13 | |
| Peter T. Abplanalp | 02 Apr 2002 08:22 | |
| yilmaz | 02 Apr 2002 22:30 |
| Subject: | Re: Connecting to an external mysql server |
|---|---|
| From: | Tim Endres (ti...@trustice.com) |
| Date: | 04/02/2002 07:03:56 AM |
| List: | com.mysql.lists.java |
Sounds like all of your access in mysql.User has 'localhost' for the Host field. You will need an entry with the hostname of your host, or '%'.
tim.
Hi All, alhough it is a very simple problem, i just couldn't get rid of it, and neither could find any helpful explanation in Mysql documents. Please ignore my question if you don't want to answer. the problem is: on my pc i have a mysql installed , also on our company's server , there is another one installed, both are version 3.23.45. i can use both of them without any problem locally. However, i want to use server's mysql, instead of mine, since my PC is already full, and our server is much more faster than my PC. So , during development i want to access our server's MySQL through my PC's mysql. But, whenever i try to connect to server's mysql, i am having error:
mysql -h 211.20.38.118 -u root;
ERROR 2003: Can't connect to MySQL server on '211.20.38.118' (10060)
i also tried creating a user on the server mysql, then try connecting via this username like below;
mysql -h 211.20.38.118 -u myusername -pmypassword;
but without success. What mistake i am making? Both my PC and our server is Win 2000. I would appreciate any help. Thanks in advance Regards :)