Page 1 of 2

mysql won't start on Win2Ksp4

Posted: Thu Oct 07, 2004 12:52 pm
by glennn3
have attempted SO MANY different Apache/PHP/mysql/phpmyadmin "installers" and am now unable to "remove" mysql or get it started - in my Comp Servcs list, the path to the server (?) is C:\/mysql/bin/mysqld-opt.exe - my WINNT my.ini reads

Code: Select all

[server]
skip-bdb
skip-innodb
skip-name-resolve
skip-symlink
default-character-set=cp1251 
[mysqld]
# set basedir to your installation path
basedir=C:/mysql
# set datadir to the location of your data directory
datadir=C:/mysql/data

[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
where might i begin looking for the problem? and how do i get rid of old/disabled services such as the one mentioned above...

thanks
glenn

Posted: Thu Oct 07, 2004 12:58 pm
by glennn3
Apache2 is running (2 instances in my Task Magr?)...

/Apache2, /mysql/, and /phpmyadmin are all on C:\ ...

Posted: Thu Oct 07, 2004 1:14 pm
by twigletmac
Are you getting any error messages?

Mac

Posted: Thu Oct 07, 2004 1:59 pm
by glennn3
if i start mysql from Services then i get Error 1067: process term. unexpectedly -

right now i've installed (with the windows installer) 3.23.57 - i had also tried 4...

Posted: Thu Oct 07, 2004 2:03 pm
by twigletmac
Did you follow the uninstall directions in the docs? That 1067 error is a bit of a catchall bugger unfortunately.

Mac

Posted: Thu Oct 07, 2004 2:16 pm
by glennn3
no i didn't - i will go do so -

in WinMySQLAdmin i see a MyODBC driver 3.51 Not Found in the Environment section - anything?

Posted: Thu Oct 07, 2004 2:27 pm
by twigletmac
Not having MyODBC shouldn't be causing your problems.

Mac

Posted: Thu Oct 07, 2004 2:32 pm
by bling
This may only complicate the issue but mySQL 4.1 is almost production ready.

Posted: Thu Oct 07, 2004 2:35 pm
by glennn3
there are no uninstall directions in the docs, or at least in the manual in /docs. the consensus in google seems to be to remove the folder and to remove the my.ini file. i didn't have this problem with WinXP - can't imagine why i'd have it with 2k...

i just reinstalled 4.0 - this shouldn't be this difficult...

Posted: Thu Oct 07, 2004 2:37 pm
by twigletmac
Question - did you have MySQL running and tried to upgrade it or has it never worked from the first install?

Mac

Posted: Thu Oct 07, 2004 2:41 pm
by glennn3
it ran when i had WinXP on this machine - i broke Windows a while back and had lost my Disc, so i installed Windows 2k and have just now tried to get apache/php/mysql running again. they run fine, just mysql won't start. so, no, it's not yet ran on this Windows.

Posted: Thu Oct 07, 2004 2:42 pm
by twigletmac
They've hidden it well (found it via Google not via the documentation search :| ) but the instructions to remove the service are on this page: http://dev.mysql.com/doc/mysql/en/NT_start.html
MySQL manual wrote:To remove a server that is installed as a service, first stop it if it is running. Then use the --remove option to remove it:

C:\> C:\mysql\bin\mysqld --remove
Mac

Posted: Thu Oct 07, 2004 2:51 pm
by glennn3
bingo - that did it. now, might you suggest a GOOD package or installer or tutorial on installing these services separately on Windows? Apache vs. Apache2...?

Posted: Thu Oct 07, 2004 2:55 pm
by twigletmac
I always tend to follow the individual instructions in the documentation for each package - Apache goes on first, then PHP, then MySQL and phpMyAdmin. The docs for all are pretty detailed and the only one that ever really causes issues is MySQL but it always starts working in the end (once I've figured out what's causing the 1067 error this time).

Mac

Posted: Thu Oct 07, 2004 2:58 pm
by glennn3
ok, good - 1 Q. > when installing apache i'm asked for domain info, though i'm clearly installing on a private machine. what would i put in these fields?