mysql won't start on Win2Ksp4

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

mysql won't start on Win2Ksp4

Post 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
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post by glennn3 »

Apache2 is running (2 instances in my Task Magr?)...

/Apache2, /mysql/, and /phpmyadmin are all on C:\ ...
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Are you getting any error messages?

Mac
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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...
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Did you follow the uninstall directions in the docs? That 1067 error is a bit of a catchall bugger unfortunately.

Mac
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Not having MyODBC shouldn't be causing your problems.

Mac
bling
Forum Commoner
Posts: 25
Joined: Mon Jul 12, 2004 12:44 pm

Post by bling »

This may only complicate the issue but mySQL 4.1 is almost production ready.
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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...
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Question - did you have MySQL running and tried to upgrade it or has it never worked from the first install?

Mac
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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...?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post 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?
Post Reply