Further to dsun's reply, here are the implementation steps: 1) login to the HDF sandbox (default password is hadoop) ssh -p 12222 root@localhost 2) login to the mysql console (default password is also hadoop) [root@sandbox-hdf streamline]# mysql streamline --user=root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 488 Server version: 5.6.36 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 3) set the global foreign_key_checks variable to off: mysql> set @@global.foreign_key_checks=off; Query OK, 0 rows affected (0.00 sec) 4) restart SAM on the ambari console 5) add the application as per the original tutorial. , Further to dsun's answer, here are the commands to apply the recommended solution: # Login as root to the hdf sandbox (ssh -p 12222 root@localhost) <default pwd is hadoop># run the following (default pwd is also hadoop>mysql streamline --user=root -p Enter password: hadoop Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 488 Server version: 5.6.36 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> set @@global.foreign_key_checks=off; Query OK, 0 rows affected (0.00 sec) Then, restart SAM from the ambari console, and try again. ... View more