https://forums.mysql.com/read.php?169,706346,706346#msg-706346
Hi Experts,
my post at the SQL forums went unanswered.
On advise from the course, I have installed SQL installation at the same location as the Apache and PHP and data is at the default location.
I get errors when I run SQL server
C:\MySQL\MySQL Server 8.0\bin>mysqld
2022-09-22T12:16:12.994662Z 0 [System] [MY-010116] [Server] C:\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.30) starting as process 19380
2022-09-22T12:16:13.002043Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2022-09-22T12:16:13.002112Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2022-09-22T12:16:13.002361Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2022-09-22T12:16:13.003648Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-09-22T12:16:13.005739Z 0 [System] [MY-010910] [Server] C:\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.30) MySQL Community Server - GPL.
Please may I know how to resolve these?