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

6 votes116 views2 answers
Mysql set primary key
SQL
0 vote111 views1 answer
Online sql testing tool
SQL
0 vote117 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
2 votes120 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote118 views1 answer
Mysql query with sql to get the next row
SQL
0 vote109 views1 answer
Min and max salary and name in sql
SQL
-1 vote136 views1 answer
Mysql extract days
SQL
19 votes127 views6 answers
Mysql if null
SQL
0 vote125 views1 answer
Get a list of tables and the primary key
SQL
4 votes120 views1 answer
Mysql ip address data type
SQL