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

1 vote150 views2 answers
Remove space in mysql
SQL
9 votes130 views2 answers
Nosql databases
SQL
4 votes124 views1 answer
Datepart postgres
SQL
0 vote137 views1 answer
Reset postgresql password windows
SQL
0 vote159 views1 answer
Prisma transaction
SQL
1 vote131 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote139 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote136 views2 answers
How to drop a unique constraint in sql
SQL
0 vote187 views1 answer
Tsql find procedure with name
SQL
2 votes139 views2 answers
Sql lag
SQL