Category Archives: MySql

MySQL Date Age Calculation

Posted on July 2, 2008 by Jeffery

I have always had the need to calculate the age as year and month from a MySQL field of type date. No doubt you can achieve this with a bit of PHP, but when you require to do the conversion … Continue reading →

Posted in MySql | Tagged , | Leave a comment

MySQL Forge is Open

Posted on August 13, 2007 by Jeffery

Use the Forge! The Forge: home of MySQL Community MySQL Forge is the place where MySQL AB, the company behind the popular Open Source Database (MySQL) and the community meet and work together. If you have a cool project? Give … Continue reading →

Posted in MySql | Leave a comment

MySQL Database backup script

Posted on January 25, 2007 by Jeffery

This script I have here has saved me a number of times from embarrassment. Many a times I happened to have “accidently” dropped an entire database (in phpmyadmin) while wanting to drop only a few tables. Apparently the big-fat “drop” … Continue reading →

Posted in MySql | 2 Comments

Re-setting Mysql root password

Posted on May 28, 2006 by Jeffery

If you have never set a root password for your MySQL database, then the server will not require a password at all for connecting as root. It is recommended to always set a password for each user and more importantly … Continue reading →

Posted in MySql | Leave a comment