Water–sand mixture inrush generally poses a significant threat to the safe operation of the quarry of coal mines. Therefore, proactive management initiatives are essential to enhance the impact resulting from mining operations. A novel approach involving grouting into the unconsolidated sand aquifer and the weathered zone was initially executed in the 1010-1 panel of the Wugou coal mine in Anhui Province, China. Considering the hydrogeological conditions of the study area, over 70 thousand tons of cement and fly ash were injected through 42 boreholes. Sampling, laboratory tests, similar materials model simulations, and numerical simulations of the trending and dipping profiles were all employed to elucidate the evolution and characteristics during the progression of the No. 10 coal seam. The outcomes illustrated that the grouting execution had transformed the structure of the porous media, weakened the watery media, and intensified the mechanical strength of the No. 4 aquifer and the weathering zone. This transformation proved beneficial in reducing the heights of the caving zone and water-conductive fracture zone, leaving more coal–rock pillars for safety. Twenty-seven underground detection drill holes and whole-space 3D resistivity exploration were adopted to verify its transformed property of low water content. During the mining process, the height of the caving zone at 19.70 m was measured through inter-hole parallel electrical detection. The pressure of hydraulic supports in the grouted area did not exceed the rated working pressure during mining. All of these findings highlight the significant impact of grouting in this study area. The successive safe mining of the 1010-1 panel demonstrates that grouting can be used to prevent water–sand mixture inrush during mining operations.