MySQL Starts and then Stops

[Mystique]

Hello: I can't get MySQL to start so tried the above solution but I got:
Setting environment for using XAMPP for Windows.
dorot@LAPTOP-82SL9TT1 c:\xampp
# mysqld --console --skip-grant-tables --skip-external-locking
2021-11-08 23:54:29 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-11-08 23:54:29 0 [Note] mysqld (mysqld 10.4.21-MariaDB) starting as process 15760 ...
2021-11-08 23:54:29 0 [Warning] Can't create test file C:\xampp\mysql\data\LAPTOP-82SL9TT1.lower-test
mysqld: Can't change dir to 'C:\xampp\mysql\data\' (Errcode: 2 "No such file or directory")
2021-11-08 23:54:29 0 [ERROR] Aborting

Can you suggest a solution please?

[Altrea]

Hi,

# mysqld --console --skip-grant-tables --skip-external-locking

This is a specific type of command for a specific type of error.
There is no hint that you got this type of error.

If you have trouble starting mysql instead use the following command

Code: Select all

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

2021-11-08 23:54:29 0 [Warning] Can't create test file C:\xampp\mysql\data\LAPTOP-82SL9TT1.lower-test
mysqld: Can't change dir to 'C:\xampp\mysql\data\' (Errcode: 2 "No such file or directory")
2021-11-08 23:54:29 0 [ERROR] Aborting

Did you delete or move the folder C:\xampp\mysql\data\ by accident?

[Mystique]

Thanks for reply. As far as I can see, C:\xampp\mysql\data\ is in place.