MySQL Forums
Forum List  »  Newbie

can't connect to mysql from a different host
Posted by: tiinu murjam
Date: April 05, 2005 03:53AM

Hi everibody, I am facing a connecting trouble.

Here is the discription of the situation:
I have running mysql server on my pc. I can connect to mysql on that pc, create databases ect. So the thing is working and everything is OK, but....
The problem is, that I cannot connect to the mysql on my pc from another pc. In the user table I have such user, that can connect from any host and also a user that theoretically can connect from scpecified hosts, but none of them can really do it.

It looks like that:

>mysql\bin\mysql -h myhost -u theuser -p
enter password: **********

>ERROR 2003: is not allowed to connect to host 'myhost' (10060)

or it gives sometimes

>ERROR 2013: lost connection during the query.....

and I am sure that this syntax is correct, i mean it works on other pc's.

PLEASE HELP ME!

What may be wrong?
How to get access to the databases and tables (how to get the connection first;)) to mysql from not local pc? How to do it properly? What van be wrong in configuration?

Options: ReplyQuote


Subject
Written By
Posted
can't connect to mysql from a different host
April 05, 2005 03:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.