How to Connect Apache Zeppelin with MindsDB (Build AI with SQL)

Learn to Connect Apache Zeppelin (Open Source Data Visualization) with MindsDB (Build AI with SQL)

Step 01: Click on Interpreter

Step 02: Click on Create to create new interpreter.

Step 03: type interpreter name as mindsdb

Step 04: Choose Interpreter as JDBC.

Step 05: Type JDBC URL as jdbc:mysql://localhost:47335/mindsdb

Step 06: Type default user as mindsdb

Step 07: Type default driver name as com.mysql.cj.jdbc.Driver

Step 08: Add artifacts or JDBC jar path for mysql and click on save as shown in below screeshot

Step 09: Now search mindsdb interpreter and make sure that it is highlighted in green, which show everything is ok in configuration.

Step 10: Now create new note.

Step 11: Write new note name and choose interpreter as mindsdb

Step 12: Choose your new note created in previous step to get started.

Step 13: type %mindsdb and click on run to use mindsdb

Step 14: click on add paragraph

Step 15: Type

show databases;

and click on run.