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 vote191 views1 answer
Azure sql server check foreign key
SQL
0 vote211 views1 answer
Use where instead of join
SQL
19 votes200 views6 answers
What is mySQL
SQL
0 vote193 views1 answer
Sql get date from timestamp
SQL
1 vote329 views1 answer
How to select department from table
SQL
0 vote248 views1 answer
Updating database in sql
SQL
0 vote193 views1 answer
Mysql docker image for macbook m1
SQL
0 vote194 views1 answer
Select last N rows mysql
SQL
4 votes255 views3 answers
Postgres drop all tables
SQL
0 vote193 views2 answers
Plsql regex match whole word
SQL