In this paper, the hydrodynamics of streamwise and normal vibration wall are studied using the Lattice Boltzmann method. Firstly, based on the two-dimensional flow geometry model, which is made up of flat wall and water fluid, the characters of the fluid near the streamwise and normal vibration wall are simulated under the condition of mutative vibration parameters. By rigorous data treating, some notable results such as the velocity distribution, density distribution curves of the flow field, and the frictional force of the solid-liquid interface are gained. Secondly, the reason of the change of frictional resistance at the solid-liquid interface by wall vibration are studied. And the results are evidence that well drag reduction effect can be obtained by applying appropriate flow vibration parameters to the solid wall. In addition, the reduction in fluid density near the solid-liquid wall is another significant cause behind the frictional drag decrease.