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 vote393 views1 answer
Redshift running queries
SQL
4 votes318 views1 answer
Refresh postgres config
SQL
0 vote304 views1 answer
Postgres in operator with comma separated values
SQL
0 vote317 views1 answer
Horizontal join sqlite
SQL
0 vote314 views1 answer
Reset postgresql password windows
SQL
0 vote377 views1 answer
Sql doesn't contain
SQL
0 vote315 views1 answer
Mysql update set sum
SQL
0 vote314 views1 answer
Sql server python connection
SQL
0 vote304 views1 answer
Difference between varchar and varchar2
SQL
1 vote293 views1 answer
MySQL AND Operator
SQL