Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get rid of complete mysql database

Status
Not open for further replies.

GerritR

Technical User
Jun 18, 2002
41
NL
I installed mysql and after some testing I lost my password to the root :(
I deinstalled mysql, stoppped the service and deleted the complete c:\mysql directory.
After that I installed a new copy of mysql, and I still can not get in there :(
Winmysqladmin also shows the testtables I made before
Can someone tell me how to delete all databases, tables and install a fresh one?

Thanks
 
Removing a database:

Code:
DROP DATABASE database_name;

Removing a table from a database:
Code:
USE database_name;
DROP TABLE table_name;

*cLFlaVA
----------------------------
"Holy crip he's a crapple!
 
when you del c:\mysql you have also del file my.ini in the windows system or my.cnf then reinstall it and it will be prompt a new account info of root

best luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top