Notice: Undefined index: countryCode in C:\xampp\htdocs\wordpress\index.php on line 30

Notice: Undefined index: countryCode in C:\xampp\htdocs\wordpress\index.php on line 30
Fred Kuo :: Blog » Archive » mysql password recover

mysql password recover

  1. Stop the mysqld daemon process.
  2. Start the mysqld daemon process with the –skip-grant-tables option.
  3. Start the mysql client with the -u root option.
  4. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
  5. Execute the FLUSH PRIVILEGES; command.

尚無留言

rssComments RSS   transmitTrackBack Identifier URI

No comments. Be the first.

addLeave a comment