Visitors
Popular Posts
-
Please read my previous post before you watch this video. 1. Setting Your Own Website On CentOS 6 (PHP 5 & MySQL 5) 2. Instal...
-
In my previous post, I showed you how to build an website from scratch with PHP and MySQL. Now, I will start to build my forum using phpB... -
After your fresh install phpBB forum, usually users can not post their video link such as YouTube to the forum. It's because the permis...
-
1- Winetricks is a application which hel p to ins tall library or part for Wine. The process to inst all is quite simple :
My Blog List
How To Recover MySQL Root Password
Tuesday, August 23, 2011
Suppose you accidentally deleted MySQL’s root account or forgot what it is. In this case, this post explains how to recover MySQL root password by setting a new MySQL password.
Step 1. Stop the MySQL service then start with skip-grant-tables option, which allow anybody to login to MySQL without entering a password.
Step 2. Login Using MySQL Root User Without Entering Password
Step 3. Set MySQL Root Password To A New Password Using UPDATE Command
Step 4. Start MySQL Server and Login With The New Password
Have fun!
