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 vote186 views1 answer
Get a list of tables and the primary key
SQL
0 vote200 views1 answer
Delete a temporary table mysql
SQL
0 vote168 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
2 votes185 views1 answer
Sql server case sensitive search
SQL
28 votes190 views6 answers
Foreign key
SQL
0 vote177 views7 answers
10 random questions use python and SQL
SQL
0 vote188 views2 answers
How to relationship query two different tables in MySQL
SQL
3 votes179 views2 answers
Postgres inner join vs join
SQL
1 vote171 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote192 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL