how to reset mysql root password:
Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for [...]

Continue reading...

The general syntax of SET statement is :
        SET variable_assignment [, variable_assignment] …
variable_assignment  :  user_var_name = expr | [GLOBAL | SESSION] system_var_name = expr | [@@global. | @@session. | @@]system_var_name = expr
SET statement is used for assigning the values for different types of variables which affects the operation of your client or the server. In [...]

Continue reading...