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 vote175 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote184 views1 answer
How to generate ids in sql
SQL
0 vote148 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote174 views1 answer
Mariadb number format
SQL
0 vote181 views1 answer
ORA-00942
SQL
-1 vote174 views1 answer
Round up and down sql
SQL
0 vote190 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote169 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote176 views1 answer
Psql connect
SQL
2 votes176 views1 answer
SELECT INTO
SQL