Hello.


Check with netstat if MySQL is listening on 3306 port on the server. Use

traffic analyzers to see if your packets reach the server. Enable the

general query log on the server to see if server receives your requests to

connect.  See:

  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html

  http://dev.mysql.com/doc/mysql/en/query-log.html





"Reema Troiana" <[EMAIL PROTECTED]> wrote:

> Hi All,

> 

> I'm trying to connect to MySql server from MySql Administrator on a network 
> machine. I specify the Server host as IP of the machine where DB server is 
> running and Port as 3306.

> 

> Username as 'root' and the password

> 

> I have tried with other usernames and specifying machine name instead of IP. 
> It doesn't work in any case. 

> 

> But i always get this error:

> 

> "Could not connect to the specififed instance. MySQL Error number 2003" and 
> it says:

> 

> "If you want to check network connection, please ping"

> When i click "ping" i get reply from the machine i'm trying to connect to

> 

> I'm able to connect to localhost, i.e., if i have the DB server on the same 
> machine. MySql server is running on XP machine. Is there any option that i 
> have to enable to make network machine to log on to Mysql DB server??

> 

> I'll appreciate any help.

> 

> Thanks,

> Reema

> 

> 

>             

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to