MySQL start then auto-stop

[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

[Wiedmann]

when I try to start MySQL, it start then auto-shutdown

Can you read an error message with "mysql_start.bat"?

[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!

[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?

[lazenge]

Yes, of course

[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?

[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!)