When you move Hue database to another server or from sqlite to mysql and just want to start over, with a fresh empty DB, do as follows:
- configure Hue to use the right database credentials, without starting it
- on the host that Hue is configured to run on, do:
/opt/cloudera/parcels/CDH/lib/hue/build/env/bin/hue syncdb --noinput
This will create all the tables and let Hue run. - start Hue and login