Tag Archives: MySQL

Reset MySQL root Password on Windows

Posted on by
Reply

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

Posted on by
Reply

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 →

How To Reset MySQL Root Password

Posted on by
1

I setup MySQL Server on CentOS few month ago, but i forgot the root password for MySQL. How to reset the password?

You can recover MySQL database server password with following steps.

Step # 1: Stop the MySQL server process.

service mysqld stop

Step # 2: Start the MySQL (mysqld) in safe mode with the –skip-grant-tables option

mysqld_safe --skip-grant-tables -u root &

Continue reading →