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 votes367 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote336 views1 answer
Two inner joins sql
SQL
0 vote319 views1 answer
Duplicate value unique constraint mysql error
SQL
-1 vote299 views1 answer
How to format tables in sqlplus
SQL
0 vote346 views1 answer
Add mysql database to power bi web
SQL
1 vote322 views3 answers
Psql fatal database does not exist
SQL
1 vote349 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote307 views1 answer
Get all employees if name ends with in sql
SQL
0 vote310 views1 answer
Sql comparison operators
SQL
1 vote364 views1 answer
Sql view where tables have same column name combine results
SQL