MySQL Stops after starting it. XAmpp 7.4.7
Posted: 15. March 2021 17:32
Since I have various Xampps in use, they are in their own directory ie c:\xampp-8.0.1\...
So, following the instructions above, when trying to start via the command line I get a warning
[Warning] Can't create test file c:\xampp\mysql\data\E590.lower-test
If I create the directory/file, it does start....
but then the "use mysql" returns "Unknown database 'mysql'"
since I assume since it is using this empty /xampp directory...
So...I assumed there was some default setting somewhere that did not got changed on the setup_xampp script.
In mysql/data there is another my.ini file which does point to the /xampp directory.
I changed that to match the real my.ini and the [Warning] Can't create test file c:\xampp\mysql\data\E590.lower-test, did not appear, but still it failed to start.
However there were new messages in the mysql_error.log:
[ERROR] InnoDB: Operating system error number 3 in a file operation.
[ERROR] InnoDB: The error means the system cannot find the path specified.
[ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
[ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\gtid_slave_pos.ibd' OS error: 203
I tried creating that file in that directory, and subdirectories, but got no further.
[EDIT by Altrea: Splitted from original topic - one topic per unique user and issue rule]
So, following the instructions above, when trying to start via the command line I get a warning
[Warning] Can't create test file c:\xampp\mysql\data\E590.lower-test
If I create the directory/file, it does start....
but then the "use mysql" returns "Unknown database 'mysql'"
since I assume since it is using this empty /xampp directory...
So...I assumed there was some default setting somewhere that did not got changed on the setup_xampp script.
In mysql/data there is another my.ini file which does point to the /xampp directory.
I changed that to match the real my.ini and the [Warning] Can't create test file c:\xampp\mysql\data\E590.lower-test, did not appear, but still it failed to start.
However there were new messages in the mysql_error.log:
[ERROR] InnoDB: Operating system error number 3 in a file operation.
[ERROR] InnoDB: The error means the system cannot find the path specified.
[ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
[ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\gtid_slave_pos.ibd' OS error: 203
I tried creating that file in that directory, and subdirectories, but got no further.
[EDIT by Altrea: Splitted from original topic - one topic per unique user and issue rule]