Special characters in folder name not supported on Windows

[tenumera]

Bug Summary

When i create a new site, i receive an error message for mysql install/
"Uh-oh! Unable to start site.
Error: Commande failed:
C:\Users\AurélienXXXX\AppData\Roaming\Local\lightning-ser…\mysqladmin.exe ping
C:\Users\Aur?lienXXXX\AppData\Roaming\Local\lightning-services\mariadb-10…:
connect to server at ‘127.0.0.1’ failed
error: ‘Can’t connect to MySQL server on ‘127.0.0.1’ (10061)’
Check that mysqld is running and that the socket: ‘MySQL’ exists!

at ChildProcesse.exithandler (node:child_process:422:12)
at ChildProcess.emit (node:events:517:28)
at ChildProcess.emit (node:domain:489:12)
at maybeClose (node:internal/child_process:1098:16)
at ChildProcess._handle.onexit (node:internal/child_process:303:5)

Steps to reproduce

Create new site, preferred or custom ( choose Maria or MySQL)

Environment Info

Describe your environment.

• Windows 11 PRO
• Apache + MariaDB
• Latest

Supporting info

See Local Log.
local-lightning.log (12.6 KB)

I can’t change my user folder’s name as i’m on AzureAD for authentication, so the user folder is automatically created with the name of the user in Azure.

[Nick-B]

Hi @tenumera

This has been a long-standing bug here:

Special characters not supported on Windows username/password

Moderator Note: Known Bug Summary Thank you everyone who has chimed in and helps clarify this issue! The general problem is that when a Windows Username includes special characters (so an apostrophe ' or a non-ASCII character like é) it can break the commands Local uses to communicate with the MySQL database. Usernames that have an apostrophe in them should be fixed, so update to the most recent version of Local if the username has an apostrophe in it. Read on for what you can do if the userna…

I’m not sure if there any workarounds if AzureAD is forcing the user. Are you able to edit the user folders at all?