How can I make it so that my MySQL database resets to defaults?
You need to programming method of resovling issue. Make use software below http://www.mysql.repairtoolbox.com program restores tables, procedures, logs and etc of mysql database
were you able to reset your MySQL database? Please let us know what worked for you. Thank you!
Windows distributions include preinitialized mysql and test databases. This would seem to suggest that you do need to reinstall MySQL.
Just start your command prompt thru Start -> Run -> cmd.exeyou can restore your db using command below:-C:> mysql -u root -p yourdbname Run -> type “cmd.exe” and enter
now enter the command below:-
C:xamppmysqlbinmysql.exe -u root -p #yourdbname# < c:xamptmpdump.sqlit should be able to restore your db.
If you are using WampServer on Windows for testing server side coding and to build your web application, you can easily reset the MySQL to initial or basic settings.
Download ResetMysql application from this page
1)- Exit from the WampServer by clicking on “Exit” option in the system tray icon of WS.
2)- Go to C:wampbinmysqlmysql5.x.xxdatamysql and copy three files mentioned below:
3)-replace these 3 files with the files in the unzipped folder “ResetMysql” that you just downloaded
4)- In C:wampappsphpmyadminx.xx.x, find config.inc.php file and delete the password (if any) for root user. Root user password should be blank like this,
5) - In the same file, you need to find the below code and cross check whether ‘config’ is in single quote
$cfg['Servers'][$i]['auth_type'] = ‘config’
6) - Now restart the WampServer, and access phpMyAdmin.
In case you are not able to see all the privileges to “root”, close the browser and start that again. Or you can try opening phpMyAdmin on different browser as well. This issue is related with some cookies if you already browsed (with problem of MySQL) the phpMyAdmin on same browser.