Press Release : Problem when I want to create a website

Hello,

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)

[OK]

You are likely being impacted by a known bug on Windows related to extended characters in your Windows username (the second character), and thus in the path to your Local sites. This thread discusses that: Unable to provision site due to special characters in Windows username - #52 by dev_dignamik

Hello burt!

Thanks a lot for the help, I still need help :slight_smile:

I managed to get into the local software. Unfortunately when I start up my site I get this 404 error:

Not Found
The requested URL was not found on this server.

Apache/2.4.54 (Win64) OpenSSL/1.1.1p PHP/8.1.12 Server at portfolio.local Port 80

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)

[OK]

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.

How do I change the use name of the root directory? Won’t this cause problems for other software?

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.