"rtroiana" <[EMAIL PROTECTED]> wrote on 06/06/2005 08:42:18 AM:
> 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 Duggal Troiana > Senior Software Developer > BitArmor Systems, Inc. > 357 North Craig Street > Ground Floor > Pittsburgh, PA 15213 > [TEL] 412-682-2200 Ext 314 > [FAX] 412-682-2201 Not everyone works or lurks on the weekends. Have you tried to RTFM? http://dev.mysql.com/doc/mysql/en/post-installation.html http://dev.mysql.com/doc/mysql/en/problems.html (especially) http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html (and) http://dev.mysql.com/doc/mysql/en/starting-server.html Use the TELNET test connection method (described in the readings) to verify you have a working network path from your remote server to the MySQL server. By the domain in your return address, I believe you work for someone who is more likely than not to have several restrictions on your network traffic. Anything that prevents traffic through port 3306 (unless you told your MySQL daemon to use a different port) between your two machines will prevent your connection. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
