MySQL Forums
Forum List  »  MySQL Workbench

server can't start after editing my.ini
Posted by: JIA YANG
Date: September 16, 2020 08:04PM

I tried to enable remote access to MySQL Server 8.0.14 on windows 10, using modifying bind address method, it was not successful, then I restored the my.ini to the original one, but still can't start server at workbench, then tried in windows cmd. I got the following errors. I saw a similar issue is solved by repair datadir=C...., but mine is ok, pointing to correct folder, which I never changed.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld
2020-09-17T01:14:15.041847Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.17) starting as process 4736
2020-09-17T01:14:15.066954Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2020-09-17T01:14:15.067979Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2020-09-17T01:14:15.068375Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2020-09-17T01:14:15.178869Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-17T01:14:15.179962Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.

Options: ReplyQuote


Subject
Views
Written By
Posted
server can't start after editing my.ini
144
September 16, 2020 08:04PM


Sorry, only registered users may post in this forum.

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.