From settings to SIM and mobile network settings Tap the access point name in the SIM card settings Change the “MVNO type” of the SIM you are using to “SPN” Good luck
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.