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:

  1. configure Hue to use the right database credentials, without starting it
  2. 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.
  3. start Hue and login


  The Cog In The Machine On Which All Depends