DO confirm this is the only working solution. adb console settings changes didn’t help.

I wish I found this forum earlier.

Adding some hot keywords for other users will be searching for this: “Connected but no internet on personal wi-fi hotspot Xiaomi tethering”. I run this issue in Thailand with TrueMove operator.