MySQL Forums
Forum List  »  Microsoft SQL Server

Re: MySQL Error Number 2003, Can't connect to MySQL server on 'localhost' (10061)
Posted by: krishna murali
Date: July 01, 2009 01:28AM

SETUP:
WindowXP Home Edition
Almost fresh installation, only softwares installed are: IIS, Apache, Tomcat, J2SE, Perl, PHP, and two firewalls.


GOAL:
I installed before MySQL on window 2000 professional and it worked fine with PHP. This time I want to installed it on my window XP home version. However it doesn't work.


STEPS:
Here are the actual steps I did:
- go to mysql.com
- download the zip file for Windows 95/98/NT/2000/XP/2003 4.0.15
http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.0%2Fmysql-4.0.15-win.zip&mirror=http%3A%2F%2Fmysql.zawodny.com%2F
- Unzip and run the setup.exe
- Press next all the time ==> typical setup, root in C:\mysql
- Go to DOS and try to run mysql: C:\mysql\bin\mysql.exe. I get:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)


- Go to service and go to MySQL property. The configuration is:
- Start: Automatic
- Local system account
- try to start MySql service but I get:
Error 1067: The process terminated unexpectedly

- Go to laptop.err and got the following mesg:

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to section 3.1 of
InnoDB: http://www.innodb.com/ibman.html
030912 2:19:10 Can't init databases
030912 2:19:10 Aborting

030912 2:19:10 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
030912 2:19:10 MySql: Shutdown Complete

- uninstalled MySQL, and reinstalled it,
- Turn off all firewalls including the Windows XP firewalls.
- Turn off all servers IIS, apache, and tomcat


==> Got the same errors, however the err file is gone. HOWEVER I can't find any err file in the directory C:\mysql.


- Check the event log>System and the last one say:

The MySql service terminated unexpectedly. It has done this 14 time(s).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

- Run mysqld-max.exe
- Run mysql.exe ==> Same error message as before!
- Run winmysqladmin.exe, and check the config file:

#This File was made using the WinMySQLAdmin 1.4 Tool
#9/12/2003 2:00:57 AM

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

[mysqld]
basedir=C:\mysql
path=C:\mysql

#bind-address=192.168.1.102
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=thomas
password=*****


PS: I hide the password for security reason.

Options: ReplyQuote




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.