Installing My SQL but not at the default locations
Posted by: Anand G
Date: October 07, 2022 11:23PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Installing My SQL but not at the default locations
412
October 07, 2022 11:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.