Page 1 of 1
MySQL start then auto-stop
Posted:
22. March 2008 15:44
by lazenge
Hi guys
I've installed Xampp 1.6.6a on Windows XP SP2
Apache is starting correctly but when I try to start MySQL, it start then auto-shutdown
MySQL doesn't start even if I setup it as a service
I've tried any kind of solution discussed in this forum
paths in my.ini and my.cnf are right, de-installing ad re-installing doesn't work, using directly .bat files doesn't work
Any idea out there?
Thank you
Posted:
22. March 2008 16:04
by Wiedmann
when I try to start MySQL, it start then auto-shutdown
Can you read an error message with "mysql_start.bat"?
Error reporting
Posted:
22. March 2008 21:22
by lazenge
Executing mysql_start.bat produce this errors output:
>Diese Eingabeforderung nicht waehrend des Running beenden
>Please dont close Window while MySQL is running
>MySQL is trying to start
>Please wait ...
>MySQL is starting with mysql\bin\my.cnf (console)
>080322 21:07:58 [Warning] Can't create test file >C:\xampp\mysql\data\aux.lower-test
>080322 21:07:58 [Warning] Can't create test file >C:\xampp\mysql\data\aux.lower-test
>080322 21:08:00 [ERROR] mysql\bin\mysqld: Can't create/write to file >'C:\xampp\mysql\data\aux.pid' (Errcode: 2)
>Can't start server: can't create PID file: No such file or directory
>MySQL konnte nicht gestartet werden
>MySQL could not be started
>Premere un tasto per continuare . . .
It seems something related to write permissions or something like this...
I'm experienced configuring Mysql in Linux systems, and I notice no permission problem in Debian 4.0 logging as superuser...
in Windows I've configured no other user than default (root/administrator)
Thanks for your reply!
Posted:
22. March 2008 21:49
by Wiedmann
>080322 21:08:00 [ERROR] mysql\bin\mysqld: Can't create/write to file >'C:\xampp\mysql\data\aux.pid' (Errcode: 2)
>Can't start server: can't create PID file: No such file or directory
The directory "C:\xampp\mysql\data" exists?
Posted:
23. March 2008 01:50
by lazenge
Yes, of course
Posted:
23. March 2008 02:09
by Wiedmann
Well, I think I figured it out... it's the hostname/computername "aux". Because "aux" is a special name in the Windows filesystem, and thus MySQL can't make a file like "aux.pid" (even if you have an extension)
Can you change your Computername?
I can't believe...
Posted:
23. March 2008 02:35
by lazenge
AAAHHHHH Ok!
I can't change computer name for very special technical reasons (my office net is figured according a built-in structure that refer to computernames), but I can assign a worker to computer named aux and try to install xampp on a different machine...it's a bit hard to switch configurations but I see I have no other chance...
I'll try to solve this way my problem
Thank you very much
(P.S. if the name aux is reserved in Windows, why Windows is not programmed to REALLY reserve it? Bah!)