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

2 votes289 views1 answer
Update trigger
SQL
0 vote278 views1 answer
Sql if else in select
SQL
4 votes291 views3 answers
Oracle sql first day of quarter
SQL
0 vote306 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote314 views1 answer
Savepoint mysql script
SQL
0 vote304 views1 answer
Mysql grant grant option
SQL
0 vote295 views1 answer
Mysql cast null to string
SQL
2 votes312 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
2 votes284 views1 answer
Mysql time ago difference
SQL
0 vote326 views1 answer
Hue hive UploadingTextFiletoHive
SQL