Editing NetHere (section)

==== Removing webmail filters ====

All webmail filters are stored in the MySQL database on webmail-1.

Simple SQL commands:

* Choosing a DB
mysql> use db_name;

* Showing tables in a DB (must be using a DB)
mysql> show tables;

* Describing a table's fields
mysql> describe table_name;


For NetHere, the database is horde_nh.
For Simply, the database is horde_si.
For zNET, the database is horde_zn.

1) Log to MySQL as root, using the normal root password
  a) # mysql -u root -p
2) Select the appropriate database
  a) mysql> use horde_nh
3) Delete webmail filters.
  a) mysql> delete from horde_prefs where pref_uid='<username>' and pref_name='filters';
     Replace <username> with the users login.