MySQL and Apache Zeppelin testing

Zeppelin_MySQL

Docs:
- https://zeppelin.apache.org/docs/0.10.1/quickstart/install.html
- https://www.apache.org/dyn/closer.cgi/zeppelin/zeppelin-0.10.1/zeppelin-0.10.1-bin-all.tgz

1) INSTALL Zeppelin
~~~~~~~~~~~~~~~~~~~
mkir /home/ted/demos/APACHE/Zeppelin
cd /home/ted/demos/APACHE/Zeppelin
wget https://dlcdn.apache.org/zeppelin/zeppelin-0.10.1/zeppelin-0.10.1-bin-all.tgz
tar xzf zeppelin-0.10.1-bin-all.tgz
./zeppelin-0.10.1-bin-all/bin/zeppelin-daemon.sh start

+ goto: http://localhost:8080/
Done ;)

2) Use MySQL - update JDBC setting
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.28.tar.gz
goto: http://localhost:8080/#/interpreter
Edit the "JDBC" interpreter according to this page: https://zeppelin.apache.org/docs/latest/interpreter/jdbc.html#mysql
Add file /home/ted/demos/APACHE/Zeppelin/mysql-connector-java-8.0.28/mysql-connector-java-8.0.28.jar to "Artifact"
Done!

I have tested with: /home/ted/sandboxes/mysqlEE@port3307
(ted/ted and port 3307)

3) Create some report
~~~~~~~~~~~~~~~~~~~~~
Pick Notebook -> "Create new note"
Set "Default Interpreter" to "JDBC"
Type "show databases" in text field and press "play/run"

Test also with;
use world;
select Continent, SUM(Population) as sum_population from world.country group by Continent;
+ play/run
Look at graphs also ;)