Mysql xampp reset root password

/* Go to the phpMyAdmin panel and select the SQL tab.
** Then run this lines:
*/
UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;

/* Open the file C:\xampp\phpMyAdmin\config.inc.php
** Search for this line and set the new password.
*/
$cfg\['Servers'\]\[$i\]['password'] = 'new_password'

Similar codes

0 vote105 views1 answer
Get only one row in mysql
SQL
0 vote103 views1 answer
Liquibase update row
SQL
0 vote120 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote102 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote147 views1 answer
Creating sqeuence in oracle database
SQL
2 votes111 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote98 views1 answer
Uuid sqlalcomany
SQL
0 vote111 views1 answer
When mysql server would not work in xampp
SQL
0 vote110 views1 answer
Soql last week
SQL
-1 vote132 views2 answers
Sql search all tables for attributes
SQL