I've been trying to find a switched 12V and negative wiring in the sunroof connector for the past week.
The wires at the Sunroof Connector: +Red/white stripe , - Blue/black stripe
Although it will look like you have a constant 12V via the meter at these connections, It is a momentary 12V at the connector, this triggers the sunroof to open or close. It does not have enough current or constant voltage to power the mirror.
Use the above instructions bringing power leads from the passenger kick panel wiring: Green w/black stripe and silver dots and ground wire.
Listed here is the factory installation instruction, note: use Green w/black stripe and SILVER DOTS
So, I sold our 2006 Mazda 5 however did not want to part with the Homelink mirror so I simply removed it and left the wiring harness in place as it was too much trouble to remove it.
Silly me figured I could just go to the dealership and purchase the harness as part of kit 0000-8C-L12 only to find they had updated this kit to 0000-8C-L12A. Ordered it figuring $35 is not that much and it was coming from Japan. 2 months later and get notified Mazda will not provide the harness. Apparently they don't stock these things but simply build on demand. Given the age, they have decided little interest.
So, after going over this thread, I have decided to try my luck and order just the harness 0000-8C-H12. Low and behold there are only a few left in the US and available for $55. Ouch. All of this just to get a wiring harness! I should have listened to myself and just clipped the wire with the connector before selling the car but hey, I guess that's what you get for trying to be nice. Using some of the above links, I can determine that really there is only 3 connectors that are important.