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 vote263 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote219 views0 answer
How to connect to datbase in springboot
SQL
5 votes254 views2 answers
Oracle tables with column name
SQL
1 vote249 views1 answer
Show indices in mysql table
SQL
0 vote287 views1 answer
Time data type in mysql
SQL
0 vote251 views2 answers
Postgresql get long running queries
SQL
0 vote266 views1 answer
Sql server isnull function nor working count
SQL
1 vote274 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote221 views1 answer
Ms sql how to see active job current run time
SQL
0 vote310 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL