Reset MySQL root Password on Windows

MySQLToday i received a ticket from customer said that they forgot their MySQL root Password. They request us to reset their MySQL root password. Currently their MySQL Server running on Windows Server 2008.

To reset the MySQL Root Password on Windows the steps almost same as reset MySQL Root Password in Linux. To learn how to reset MySQL Password in Linux, just click HERE.

On Windows, use the following procedure to reset the password for all MySQL root accounts:

1) Log on to your system as Administrator. Continue reading

How to Backup and Restore MySQL Database Using mysqldump

Nowadays we store our web applications data in databases. Do you backup your databases? t is very important to make regular backups of your data to protect it from loss. I store all my web application data in to MySQL database, so i going t show how to backup and restore the data in your MySQL database.

There are 2 way to perform backup and restore MySQL database. The easier way to perform backup and restore MySQL databases is use phpMyAdmin. phpMyAdmin is open source GUI tool to manage MySQL databases. phpMyAdmin allows users to save database dump as file and import it. But it probably won’t be a good idea if your database size too huge.

Another method to perform backup and restore MySQL database is using mysqldump command. I prefer use mysqldump command to perform backup and restore MySQL database cause it easy to use it. I can done the backup and restore by just enter 2 command.

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command.

How to backup MySQL database Continue reading