Thank you very much for your precious help, without it I cannot host my sites in local
When I create a site in local, the following error message appears:
[Window Title] Error
[Main Instruction]
Uh-oh! Unable to provision site.
[Content]
Error: Error: Command failed: C:\Program Files (x86)\Local\resources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe --defaults-file=C:\Users\Sébastien\AppData\Roaming\Local\run\c_nawvxlk\conf\mysql\my.cnf --initialize-insecure
mysqld: Can’t create/write to file ‘C:\Users\Sébastien\AppData\Roaming\Local
un\c_nawvxlk\mysql\data\is_writable’ (OS errno 2 - No such file or directory)
2023-05-02T22:01:37.107415Z 0 [System] [MY-013169] [Server] C:\Program Files (x86)\Local\resources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe (mysqld 8.0.16) initializing of server in progress as process 4052
2023-05-02T22:01:37.115888Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.
2023-05-02T22:01:37.124301Z 0 [ERROR] [MY-010460] [Server] --initialize specified but the data directory exists and is not writable. Aborting.
2023-05-02T22:01:37.124366Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\Users\Sébastien\AppData\Roaming\Local
un\c_nawvxlk\mysql\data\ is unusable. You can safely remove it.
2023-05-02T22:01:37.124525Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-02T22:01:37.125802Z 0 [System] [MY-010910] [Server] C:\Program Files (x86)\Local\resources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
at ChildProcess.exithandler (node:child_process:407:12)
at ChildProcess.emit (node:events:527:28)
at maybeClose (node:internal/child_process:1092:16)
at ChildProcess._handle.onexit (node:internal/child_process:302:5)
Sorry I have another problem which is the following:
[Window Title]
Error
[Main Instruction]
Uh-oh! Unable to provision site.
[Content]
Error: Error: Command failed: C:\Program Files (x86)\Localresources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe --defaults-file=C:\Users\Sébastien\AppData\Roaming\Localrun\8fkxFj3C6\conf\mysql\my.cnf --initialize-insecure
mysqld: Can’t create/write to file ‘C:\Users\Sébastien\AppData\Roaming\Local
un\8fkxFj3C6\mysql\data\is_writable’ (OS errno 2 - No such file or directory)
2023-05-03T21:07:51.802218Z 0 [System] [MY-013169] [Server] C:\Program Files (x86)\Local\resources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe (mysqld 8.0.16) initializing of server in progress as process 2896
2023-05-03T21:07:51.806912Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.
2023-05-03T21:07:51.810191Z 0 [ERROR] [MY-010460] [Server] --initialize specified but the data directory exists and is not writable. Aborting.
2023-05-03T21:07:51.810230Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\Users\Sébastien\AppData\Roaming\Local
un\8fkxFj3C6\mysql\data\ is unusable. You can safely remove it.
2023-05-03T21:07:51.810375Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-03T21:07:51.810953Z 0 [System] [MY-010910] [Server] C:\Program Files (x86)\Local\resources\extraResources\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
at ChildProcess.exithandler (node:child_process:407:12)
at ChildProcess.emit (node:events:527:28)
at maybeClose (node:internal/child_process:1092:16)
at ChildProcess._handle.onexit (node:internal/child_process:302:5)
This is the same problem as I linked to in my earlier reply in this thread. The “é” character in your Windows username, and thus your user directory name, causes issues.
Yes, it poses difficulties. But that thread goes into more depth than I can offer here. It doesn’t appear that there is a simple solution to the issue currently, but that thread is where you might want to follow up, with others that have been directly impacted. You should also vote for it (in the top-left of that thread) to bring developer attention to it.