how to start completely fresh

[lucille_arkenst]

Whoever can help me out of this jam your help will be greatly appreciated.  I started having problems and so I wiped out my installation and started new.  Only to realize… I forgot about the database.  The alfresco.log file is telling me about a custom model I had implemented from before.  How do I wipe out the database in order to cooperate with the new instance of Alfresco?
MUCH THANKS IN ADVANCE

[darryl_staflund]

Hi there,

I do the following when I want to do a fresh re-install (NB:  I use MySQL – your database may differ):

1.  Log onto MySQL.
2.  Delete the 'alfresco' schema.
3.  Recreate the 'alfresco' schema.
4.  Grant the 'alfresco' user all privileges over the 'alfresco' schema.

Once you do this, Alfresco will re-create the tables, etc. on start-up.

I haven't tried this, but the following should work as well:

1.  Run '<alfresco_home>/extras/databases/mysql/db_remove.bat'.
2.  Run '<alfresco_home>/extras/databases/mysql/db_setup.bat'.

Hope this helps.

Darryl

[lucille_arkenst]

OK delete schema: drop database alfresco;
OK recreate the alfresco schema: create database alfresco default character set utf8 collate utf8_bin;
OK grant privileges 1: grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
Second one need to log in as root user…
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
And… I forgot the root password  ops:

[darryl_staflund]

I am not sure how you'd go about resetting the root password.  Reinstall MySQL? 🙂

Darryl

[lucille_arkenst]

I found out there are ways to reset it.  Hopefully it won't be so bad. 
Thanks for your help, Darryl.  I appreciate it