Apache Friends Support Forum

After installing Xampp 8.03 for Windows in a different directory than the default I tried to enter the database with the aim of changing the password. However, when I run Mysqld I get the errors
Can't create test file c:\xampp\mysql\data\LAPTOP-JOD2HF4P.lower-test
AND
Can't change dir to 'c:\xampp\mysql\data\' (Errcode: 2 "No such file or directory")

As Xampp is installed in D:\xampp80 it looks like the install procedure forgot to change some paths.

Did you use the installer or a zip version of xampp?

Did you executed the setup_xampp.bat file once to adjust all paths?

I used the installer (the .exe file).

I never thought about setup_xampp.bat. But when I run it now I get "nothing to do".

How did you run mysqld? From command line?
Did you tell mysqld where the config file is?
Did you tell mysqld to run as console application?

So did you use the following command?:

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console

With older versions of Xampp it was never necessary to include this path. Has that been changed?

I have checked XAMPP 1.7.1 which is nearly 12 years old, even this old version of xampp adds the defaults-file parameter

mysql_start.bat

Code: Select all

@echo off
echo Diese Eingabeforderung nicht waehrend des Running beenden
echo Please dont close Window while MySQL is running
echo MySQL is trying to start
echo Please wait  ...
echo MySQL is starting with mysql\bin\my.cnf (console)

mysql\bin\mysqld --defaults-file=mysql\bin\my.ini --standalone --console

if errorlevel 1 goto error
goto finish

:error
echo.
echo MySQL konnte nicht gestartet werden
echo MySQL could not be started
pause

:finish