Answers for "how to reset password in phpmyadmin"

wordpress change user password sql

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";

phpmyadmin reset root password

-- DEFAULT: Username:root , Password: –  (none)
mysql> SET PASSWORD FOR root@localhost=PASSWORD('mypassword');
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost 
	IDENTIFIED BY 'mypassword' WITH GRANT OPTION;