How can I reset my MySQL database to default?

mike August 1, 2011
Pinterest Stumbleupon Whatsapp

How can I make it so that my MySQL database resets to defaults?

  1. johnstallone
    June 22, 2012 at 1:52 pm

    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

  2. Tina
    August 7, 2011 at 4:13 pm

    Mike,

    were you able to reset your MySQL database? Please let us know what worked for you. Thank you! 

  3. Anonymous
    August 1, 2011 at 1:48 pm

    Windows distributions include preinitialized mysql and test databases. This would seem to suggest that you do need to reinstall MySQL.

    http://dev.mysql.com/doc/refman/5.0/en/windows-postinstallation.html

    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
    http://downloads.jlbn.net/

    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:

    ---user.frm---user.myd---user.myi

    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,

    $cfg['Servers'][$i]['password'] =’’;

    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.

    http://www.staenzwebsolutions.com/reset-phpmyadmin-mysql-wampserver/569/

  4. Anonymous
    August 1, 2011 at 1:48 pm

    Windows distributions include preinitialized mysql and test databases. This would seem to suggest that you do need to reinstall MySQL.

    http://dev.mysql.com/doc/refman/5.0/en/windows-postinstallation.html

    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
    http://downloads.jlbn.net/

    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:

    ---user.frm---user.myd---user.myi

    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,

    $cfg['Servers'][$i]['password'] =’’;

    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.

    http://www.staenzwebsolutions.com/reset-phpmyadmin-mysql-wampserver/569/