MySQL – @derblub

Changing only the year in a mysql date or datetime field

Ever had to change only the year of an date-field? Continue reading to learn how!

Hi, my name is Robert’); DROP TABLE Students;–

Exploits of a Mom: Teacher: “Hi, this is your son’s school. We’re having some computer trouble.” Mom: “Oh, dear – Did he break something?” Teacher: “In a way… Did you really name your son Robert’); DROP TABLE Students;–?” Mom: “Oh, yes. Little Bobby Tables we call him.” Teacher: “Well, we’ve lost this year’s student records.… Continue reading Hi, my name is Robert’); DROP TABLE Students;–

How To Recover Your MySQL root Password

I just needed to recover a lost MySQL root password on a clients server recently and thought I’d share the method I used. [ad name=”Adsense – text only”] Actually it’s not a method for recovering but you can change the forgotten password to a new one. All you need is to follow this 6 easy… Continue reading How To Recover Your MySQL root Password