The invention relates to an antibacterial sol-gel coating solution, a process for preparing the antibacterial sol-gel coating solution, an antibacterial article, and a process and an apparatus for producing the antibacterial article. Said antibacterial sol-gel coating solution comprises a. at least one substance selected from the group consisting of Ti or Si-containing compounds capable of hydrolyzing to form a base film; b. a regulating agent capable of regulating the hydrolysis rate of the Ti or Si-containing compounds; c. an organic solvent; d. water; and e. at least one soluble compound of antibacterial metal selected from the group consisting of Ag, Cu, Mg, Zn, Sn, Fe, Co, Ni, and Ce; wherein a, b and a portion of c are first mixed to form a solution I, d and the rest of c are then mixed and added into solution I to form a dispersion II, and then e is added into dispersion II to form the antibacterial sol-gel coating solution.