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

3 votes165 views2 answers
Brew restart mysql
SQL
0 vote126 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote121 views2 answers
Azure sql-datenbank
SQL
4 votes141 views1 answer
List tables sqlite
SQL
9 votes131 views2 answers
Convert data type in sql
SQL
0 vote127 views1 answer
Sql server update top n records
SQL
0 vote127 views1 answer
Mysql select smaller of two values
SQL
0 vote127 views1 answer
Column ' ' in field list is ambiguous
SQL
2 votes111 views1 answer
Sql to char function with date
SQL
9 votes124 views2 answers
Sql limit order by
SQL