Error 2003: Cannot connect to mySQL server on localhost <10061>

Thanks for your quick response.
- I've checked process running and I cannot get mysql to run using the
CMD window and typing mysqld or mysqld-n. Also when I start the
winmysqladmin, the stoplight never turns green. It also says myodbc
not found.

- err file in data directory: I cannot open it or do not know how to
open it - it is called Robert.err and is 345kb so something is in it.
When I use winmysqladmin and go to err file nothing shows up. I do
have a my.ini file under windows but not my.cnf file.

- run "eventvwr"), or run the server (mysqld-nt ?) from the command
line: don't see anything in event viewer related to mysql,and when I
run mysqld-nt or mysqld nothing happens. When I use HijackThis to see
start up processes it shows 023-service:mysql-unknown
owner-c:mysql/bin/mysqld-nt.exe; however, when I check processes
running, mysql has stopped while showing automatic.

- This problem started after I reinstalled windows xp and I noticed
the update version was labled differently than what I had before. Do
you think I will need to reinstall mysql?

- I installed and configured the myodbc 3.51 and the winsqladmin still
says myodbc not found but also has ...
Driver Version
Driver c:\windows\system32\myodbc3.dll
api level
setup c:\windows\system32\myodbc3s.dll
sql level

- my.ini file listing is the following:
#This File was made using the WinMySQLAdmin 1.4 Tool
#7/17/2003 10:47:51 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=68.70.103.150
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=bob
password=bob

I hope this sheds some light on what I must do to correct this issue.

Again thanks for your help.

Bob

-----Original Message-----
From: David Dindorp [mailto:ddi@dubex.dk]
Sent: Tuesday, November 29, 2005 2:43 AM
To: Bob Melis
Cc: myodbc@lists.mysql.com
Subject: RE: Error 2003: Cannot connect to mySQL server on localhost
<10061>


Bob Melis wrote:
> I cannot get mysql to run.

Check the mysql .err file in your data directory (specified in
my.{ini,cnf}) for error messages from the server. If the mysql server
doesn't even get that far, check your NT Application event log (run
"eventvwr"), or run the server (mysqld-nt ?) from the command line.

> Cannot connect to mySQL server on localhost <10061>

10061 is an error number from Windows' socket layer meaning that the
TCP
connection was actively refused (by a RESET packet from the remote
host). This usually means that noone is listening at the ip/port
you're
trying to access.

> I am using mysql-connector-java-3.0.8-stable-bin.jar. I believe that
> is to connect my java application to the Microsoft ODBC.

Never used it, but I think you're wrong.
I think ODBC connections from Java are done using a generic ODBC-JDBC
bridge (supplied by eg. Sun).
I think the Java connector is a JDBC driver that does not depend on
Connector/ODBC.



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org