Steve,
The first and most obvious problem is you're my.ini file. The basedir
should be: c;/mysql and the datadir should be c:/mysql/data.
Second; for the missing .cnf files, I've been hearing that he 4.0.20
release did not include them for some reason. You can download an older
zipped version of MySQL and they will be in there.
Third, your MySQL service is pointing to the wrong file. Go to the
c:\mysql\bin directory and remove the service: "mysqld-nt --remove" and
then reinstall the service "mysqld-nt --install" It should now load the
service as pointing to c:\mysql\bin\mysqld-nt.exe
Cheers.
Armando
-----Original Message-----
From: Steve Leung [mailto:sleung30@stripped]
Sent: July 20, 2004 4:42 AM
To: win32@stripped
Subject: Need Help on My MySQL Installation Problem
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
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=1
