A hose nut for connecting a shower head to a water hose, comprising a nut body having a throughbore formed therein, the nut body comprising: a lower portion for receiving at least a part of the water hose; a transition portion immovably secured to the lower portion; an upper portion for connection to the shower head and arranged on the transition portion in such a manner that the upper portion is rotatable relative to the transition portion around an axis of the upper portion; at least one magnetic element mounted on a side of the lower portion, the magnetic element being adapted to be slidably attached to a holding device on a wall for hanging the shower head on the wall by a magnetic attraction force generated between the magnetic element and the holding device, characterized in that the hose nut further comprises a locking mechanism for locking the upper portion with the shower head at a desirable angle and preventing the rotation of the upper portion relative to the transition portion around the axis of the upper portion; wherein the locking mechanism comprises a button, and a stopper coupled to the button, the stopper being configured to engage with the upper portion thereby creating a lock therebetween for prevention of the rotation of the upper portion when the button is released, and to disengage from the upper portion to allow the rotation of the upper portion when the button is pressed; and wherein the stopper has at least one tooth on an inner wall surface thereof, wherein the at least one tooth is able to engage with one of a plurality of recesses circumferentially formed on an outer surface of a bottom of the upper portion when the button is released, and the at least one tooth of the stopper is forced to disengage from the recess on the bottom of the upper portion when the button is pressed. a lower portion for receiving at least a part of the water hose; a transition portion immovably secured to the lower portion; an upper portion for connection to the shower head and arranged on the transition portion in such a manner that the upper portion is rotatable relative to the transition portion around an axis of the upper portion; at least one magnetic element mounted on a side of the lower portion, the magnetic element being adapted to be slidably attached to a holding device on a wall for hanging the shower head on the wall by a magnetic attraction force generated between the magnetic element and the holding device, characterized in that the hose nut further comprises a locking mechanism for locking the upper portion with the shower head at a desirable angle and preventing the rotation of the upper portion relative to the transition portion around the axis of the upper portion; wherein the locking mechanism comprises a button, and a stopper coupled to the button, the stopper being configured to engage with the upper portion thereby creating a lock therebetween for prevention of the rotation of the upper portion when the button is released, and to disengage from the upper portion to allow the rotation of the upper portion when the button is pressed; and wherein the stopper has at least one tooth on an inner wall surface thereof, wherein the at least one tooth is able to engage with one of a plurality of recesses circumferentially formed on an outer surface of a bottom of the upper portion when the button is released, and the at least one tooth of the stopper is forced to disengage from the recess on the bottom of the upper portion when the button is pressed.