How to reset lost MySQL password

how you can rest a lost MySQL password. Using this procedure you can reset the lost password of root or any other MySQL user. The best part is, it only resets the password, keeping your tables and data inside them quite safe.

MySQL Optimization from a developer’s point of view

Undoubtedly a Web Application’s backbone is a database. Apparently, the Web Application’s performance is dependent on the database’s overall performance. However, some developers blame Database Administrators for non-performing of the web application to the end user.

Difference between InnoDB and MyISAM in MySQL

MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between these two storage engines are : InnoDB supports transactions which is not supported by tables which use