sudo yum install -y mysql-server

sudo service mysqld start

sudo /usr/bin/mysql_secure_installation

Enter current password for root (enter for none): [Press Enter if the password is unset] 
OK, successfully used password, moving on...
[...]
Set root password? [Y/n] Y
New password:
Re-enter new password:
Remove anonymous users? [Y/n] Y
[...]
Disallow root login remotely? [Y/n] N
[...]
Remove test database and access to it [Y/n] Y
[...]
Reload privilege tables now? [Y/n] Y

[mysqld]
...
bind-address=0.0.0.0
default-storage-engine=innodb
sql_mode=STRICT_ALL_TABLES

sudo service mysqld restart

mysql -u root -p<root password>

create database hue collate = 'utf8_general_ci';
grant all on hue.* to 'hue'@'%' identified by 'huepassword';
quit

## Download Cloudera Manager to your package manager source directory.  
wget https://archive.cloudera.com/cm5/redhat/6/x86_64/cm/cloudera-manager.repo -P /etc/yum.repos.d/

## Install Cloudera Manager and Dependencies (sourced from the Cloudera Manager repo)
sudo yum install -y oracle-j2sdk1.7
sudo yum install -y cloudera-manager-daemons cloudera-manager-server
sudo yum install -y cloudera-manager-server-db-2

## Start the database and server
sudo service cloudera-scm-server-db start
sudo service cloudera-scm-server start

1. Select Custom Database, set parameters, and Test Connection and stop !

   DB Hostname  = cdh-db.<your domain>.com:3306
   DB Type      = MySQL
   DB Name      = hue
   Username     = hue
   Password     = <hue password set when granting hue permissions>

2. After successfully connecting to MySQL, reset the hostname and database type to PostgreSQL.
3. Select Embedded Database and again, click Test Connection.
     Note: Before moving on, click Show Passwords and copy the Hue password for safe-keeping.
4. After successfully connecting to the embedded database, click Continue. We reconnect to MySQL in Dump, Synchronize, and Load, after migrating the embedded database.

1. Select Actions > Dump Database.
2. Click Dump Database. The file is written to /tmp/hue_database_dump.json on the host of the Hue server.
3. Log on to the host of the Hue server in a command-line terminal.
4. Edit /tmp/hue_database_dump.json by removing all objects with useradmin.userprofile in the model field. For example:

   # Count number of objects
   grep -c useradmin.userprofile /tmp/hue_database_dump.json

   vi /tmp/hue_database_dump.json

   {
     "pk": 1,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:06:13",
       "creation_method": "HUE",
       "first_login": false,
       "user": 1,
       "home_directory": "/user/admin"
     }
   },
   {
     "pk": 2,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:27:10",
       "creation_method": "HUE",
       "first_login": false,
       "user": 2,
       "home_directory": "/user/alice"
     }
   },

1. Go to Hue > Configuration.
2. Filter by category, Database.
3. Set the following database parameters :

   DB Hostname  = <fqdn of host with postgres server>:3306
   DB Type      = <PostgreSQL>
   DB Name      = hue
   Username     = hue
   Password     = <hue database password set when granting hue permissions>

4. Click Save Changes.

1. Log on to the host of the MySQL server in a command-line terminal.
2. Delete the foreign key constraint and clean the table, django_content_type:

   mysql -u root -p

   SHOW CREATE table hue.auth_permission;
   ALTER TABLE hue.auth_permission DROP FOREIGN KEY content_type_id_refs_id_<input id>;

   DELETE FROM hue.django_content_type;

   
   
   
3. In Cloudera Manager, load the JSON file: select Actions > Load Database and click Load Database.
4. Add the foreign key back:

   ALTER TABLE hue.auth_permission ADD FOREIGN KEY (content_type_id) REFERENCES django_content_type (id);