Can super glue hold a car rearview mirror?

Yes it can. Make sure first, that both surfaces are clean and de-greased by washing with a little lacquer thinner or similar.