Zeppelin connection MySQL

One of the above articles, for the use of Zeppelin, is just that we store the data in the file, every time when we are connected to the database, there will be problems, today just

To solve this problem today we're just going to show you how to use Zeppelin to connect to data

First of all, such as the previous article, download the compressed package, change the contents of the configuration file, after these are done, if we want to operate on the database, so we want to operate on JDBC,

We want to modify the following arrows to their own configuration

　　

And then after that, we need the jar package that's connected to the database, and this time we download the jar, and we put the jar package in

Zeppelin inside the Lib file inside (actually can not write in Lib), and then in this configuration to find this address

　　　　

Then the configuration is complete and we can use it now.

Note: Access denied for user ' [email protected] ' (using passwd:yes) If this problem is encountered, is due to when we

When we connect the data inside Linux, but this MySQL does not support remote connection, then we can write the address in Windows

MySQL database, for this, in fact, very similar to the company, our code in win above, but Hadoop,spark environment on Linux, anyway

These two ports can communicate, then after we restart Zeppelin, we re-read the data operation, you can successfully

　　　　

Zeppelin connection MySQL