I have no idea why I have not yet seen anyone post the most probable fix for this issue. I have spent hours searching with the help of Mr. Google to find lots of suggestions about formatting the drive, plugging it into another computer (as if most people have computers laying around…especially two MacBooks!)
I just went through this same issue. The external drive was not connecting no matter what I did. I even tried connecting it to some older “about to be thrown out” Windows laptops to see if it would register. It didn’t. Believe it or not, the fix only cost me $6 from Amazon. The issue was the USB cable. The drive worked fine.
My recommendation is to simply buy a $6 USB replacement and see if that does the trick before reformatting the drive, potentially losing data, even after a backup. Yes, even backups can become corrupted and getting the data back may be impossible.
I went with: (Search on Amazon) Works like a charm!
Bargains Depot® Products USB 3.0 PC Power Charger Data Transfer Cable/Cord/Lead For WD Western Digital My Passport Essential SE 500GB / 750GB / 1TB model & part number compatible : WDBACY5000ABK, WDBACY5000ABL, WDBACY5000AWT, WDBACY5000ASL, WDBACY5000ARD, WDBACY5000ARD, WDBK6Z500ATT, WDBACX7500ABK, WDBACX7500ABL, WDBACX7500ASL-NESN, WDBACX7500ARD, WDBACX0010BBK, WDBACX0010BBL, WDBACX0010BSL, WDBACX0010BRD + Free Gift