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

9 votes259 views3 answers
Show table columns mysql command line
SQL
0 vote260 views2 answers
Postgres having
SQL
0 vote261 views1 answer
Copy data from one postgres container to another
SQL
1 vote261 views1 answer
Psql autocomplete for mac brew install
SQL
7 votes258 views3 answers
Restore postgres database from sql file
SQL
0 vote272 views1 answer
Set column in all row mysql
SQL
1 vote260 views1 answer
Postgres convert date to string
SQL
0 vote247 views1 answer
Sql server select ignore dupplicates
SQL
7 votes262 views1 answer
Sql limit decimal places
SQL
-3 votes332 views8 answers
Sql to c# linq converter online
SQL