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
1508
September 16, 2020 08:04PM
629
September 16, 2020 08:22PM
1000
September 17, 2020 01:38AM
1474
September 27, 2020 06:38PM


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.