Dear Sir/Madam,
I would appreciate if you can help me to fix my MySQL
installation problem. I tried to install MySQL 4.0.20d
(and 4.0.15) on my 2 GHz Windows XP computer but I was
getting "Can't connect to MySQL Server on "localhost""
when I run my simple test.php file on Apache (The same
.php file worked on the remote Yahoo's web server).
Here are the problem descriptions:
- MySQL installed on c:\mysql
- winmysqladmin was working. The my.ini tab shows:
#This File was made using the WinMySQLAdmin 1.4 Tool
#7/5/2004 11:58:11 PM
#Uncomment or Add only the keys that you know how
works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/Program Files
#bind-address=127.0.0.1
datadir=C:/Program Files/data
#language=C:/Program Files/share/your language
directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=sleung
password=musql
- I could only find readme and Uninst.isu in C:\mysql
and did not see my-medium.cnf and other three *.cnf
files.
- If I go to command line and typed:
C:\>c:\mysql\bin\mysqld --install, the system
prompted: The service already exists. The current
server installed : C:/Program Files/bin/mysqld-nt.exe.
- If I entered: NET START MySQL, the system prompted:
System error 2 has occured. The system cannot find the
file specified.
- If I eneterd; C:\>c:\mysql\bin\mysqld test, the
system prompted: 040720 2:01:11 can't find messagefile
'c:\Program Files\share\english\errmsg.sys' 040720
2:01:11 Aborting.
- If I enetered: C:\>c:\mysql\bin\mysql mysql, the
systme prompted: Error 2003: Can't connect to MySQL
server on 'localhost' <10061>
I have read all related documents available in
mysql.com website and have searched all related books
that I could find in bookstores but still could not
figure out the problem. Would you please help me out?
Thank you.
Best regards
Steve