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 votes137 views6 answers
Second max salary in sql
SQL
3 votes137 views3 answers
Create table in microsoft sql server
SQL
0 vote143 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote137 views1 answer
Sql server express download
SQL
0 vote136 views1 answer
Sql change date format
SQL
0 vote155 views3 answers
Insert query in ci
SQL
0 vote134 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote147 views1 answer
Mysql changer nom table
SQL
0 vote137 views1 answer
Mysql 5.7 in centos 7
SQL
2 votes125 views1 answer
SQL IF ELSE
SQL