Server has no local IP address, does not appear in LAN list in router

But Did you switch to mobile data on smartphone when you turned on tethering?

Also check this: Ethernet not working on cloned Debian 11 with Yunohost - #6 by cichy1173