Abstract Hard ceramic coatings were successfully prepared on the surface of ZM5 magnesium alloy by micro-arc oxidation (MAO) technology in silicate and aluminate electrolytes, respectively. The optimization of hard ceramic coatings prepared in these electrolyte systems was investigated through an orthogonal experimental design. The microstructure, elemental composition, phase composition, and tribological properties of the coatings were characterized by scanning electron microscopy (SEM), energy-dispersive X-ray spectroscopy (EDS), X-ray diffraction (XRD), and tribological testing equipment. The results show that the growth of the hard ceramic coatings is significantly influenced by the different electrolyte systems. Coatings prepared from both systems have shown good wear resistance, with the aluminate electrolyte system being superior to the silicate system in performance. The optimized formulation for the silicate electrolyte solution has been determined to be sodium silicate at 8 g/L, sodium dihydrogen phosphate at 0.2 g/L, sodium tetraborate at 2 g/L, and potassium hydroxide at 1 g/L. The optimized formulation for the aluminate electrolyte solution consists of sodium aluminate at 5 g/L, sodium fluoride at 3 g/L, sodium citrate at 3 g/L, and sodium hydroxide at 0.5 g/L. Keywords: ZM5 magnesium alloy; micro-arc oxidation; process optimization; hard ceramic coating; ultra-anti-corrosion; tribology