The invention relates to an oyster attachment substrate technology, in particular to a cement concrete oyster attachment substrate with a rough surface and a preparation method, and belongs to the crossing field of marine sessile organisms and marine concrete. The attachment substrate comprises the following components: a cementing material, a light coarse aggregate, a light fine aggregate, water,dark pigment, biological calcium powder, calcium carbonate powder, trace elements, chopped fibers and a superplasticizer. According to the invention, dilute acid modification and composite grinding technologies are adopted; the inducibility of bovine bone meal is fully exerted, the mixing amount of the bovine bone meal is greatly reduced, anti-corrosion treatment and modification are carried out,a composite inducer with the bovine bone meal as the main component is achieved, the mixing amount is small, the strength and permeability of concrete are hardly affected, meanwhile, the oyster larvaadhesion capacity is very high, and the mildewing problem of the concrete is solved. Compared with concrete without an inducer, the concrete doped with the inducer has the advantage that the attachment number of oyster larvae is obviously increased.