Nothing really is working. I guess your adapter really has issues with compatibility on some devices. I tried installing the driver on another laptop and the same thing happens: it still cannot...

@Kathy_Z yes, it is 2.4ghz only I updated my driver using the link you provided but, still, nothing has changed. I am using Windows 10, 64-bit driver version: 1030.6.1201.2015

My usb wifi adapter seems to have a hard time finding Redmi Note 8 Pro mobile hotspot. It can detect my hotspot sometimes but it is very rare and not reliable. The adapter seems to be working fine...