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

4 votes218 views2 answers
Tables in sql
SQL
0 vote224 views1 answer
Data types mysql vs postgresql
SQL
0 vote217 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote216 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote240 views1 answer
Sql output select
SQL
11 votes242 views2 answers
Mysql set safe mode off
SQL
0 vote222 views1 answer
Min mysql
SQL
13 votes240 views2 answers
Sql join 3 tables
SQL
0 vote226 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote240 views1 answer
Drop tables from local database postgres pgadmin
SQL