Re: MySQL Error Number 2003, Can't connect to MySQL server on 'localhost' (10061)
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.