Can't create test file

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Can't create test file

Postby musicmaster » 14. March 2021 17:01

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.
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: Can't create test file

Postby Altrea » 14. March 2021 17:42

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

Did you executed the setup_xampp.bat file once to adjust all paths?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Can't create test file

Postby musicmaster » 14. March 2021 17:57

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".
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: Can't create test file

Postby Altrea » 15. March 2021 00:23

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Can't create test file

Postby musicmaster » 19. March 2021 18:38

With older versions of Xampp it was never necessary to include this path. Has that been changed?
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: Can't create test file

Postby Altrea » 19. March 2021 18:56

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 79 guests