mysql xampp reset root password

Solutions on MaxInterview for mysql xampp reset root password by the best coders in the world

showing results for - "mysql xampp reset root password"
Emmanuel
25 Nov 2017
1/* Go to the phpMyAdmin panel and select the SQL tab.
2** Then run this lines:
3*/
4UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
5FLUSH PRIVILEGES;
6
7/* Open the file C:\xampp\phpMyAdmin\config.inc.php
8** Search for this line and set the new password.
9*/
10$cfg\['Servers'\]\[$i\]['password'] = 'new_password'