hue访问mysql,【原创】大叔经验分享（50）hue访问mysql（librdbms）

cloudera manager安装hue后想开启访问mysql(librdbms)需要在这里配置(hue_safety_valve.ini)

添加配置如下

[librdbms]#The RDBMS app can have any number of databases configured in the databases

#section. A database is known by its section name

#(IE sqlite, mysql, psql, and oracle in the list below).

[[databases]]#mysql, oracle, or postgresql configuration.

[[[mysql]]]#Name to show in the UI.

nice_name="db_dataone"

#For MySQL and PostgreSQL, name is the name of the database.

#For Oracle, Name is instance of the Oracle server. For express edition

#this is 'xe' by default.

name=db_dataone#Database backend to use. This can be:

#1. mysql

#2. postgresql

#3. oracle

engine=mysql#IP or hostname of the database to connect to.

host=192.168.0.1

#Port the database server is listening to. Defaults are:

#1. MySQL: 3306

#2. PostgreSQL: 5432

#3. Oracle Express Edition: 1521

port=3306

#Username to authenticate with when connecting to the database.

user=root#Password matching the username to authenticate with when

#connecting to the database.

password=123456

#Database options to send to the server when connecting.

#https://docs.djangoproject.com/en/1.4/ref/databases/

## options={}

注意：[[databases]]下可添加多个[[[mysql]]]或其他数据库，如果有多个mysql，分别命名为[[[mysql1]]],[[[mysql2]]]或其他名字区分

除此之外，还要添加notebook

[notebook]

[[interpreters]]

[[[impala]]]

name=Impala

[[[hive]]]

name=Hive

[[[mysql]]]

name=Mysql

interface=rdbms

[[[java]]]

name=Java

interface=oozie

[[[spark2]]]

name=Spark

interface=oozie

[[[shell]]]

name=Shell

interface=oozie

[[[sqoop1]]]

name=Sqoop1

interface=oozie

[[[distcp]]]

name=Distcp

interface=oozie

此处略去了不需要的Pig和MapReduce等；

然后重启hue

如果要添加多个mysql，如下配置：

[librdbms]

[[databases]]

[[[mysql1]]]

...

[[[mysql2]]]

...

[notebook]

[[interpreters]]

[[[mysql1]]]

...

[[[mysql2]]]

...

参考：

https://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Hue-db-editor-permissions/td-p/78298

http://cloudera.github.io/hue/docs-4.4.0/user/editor/

http://cloudera.github.io/hue/latest/administrator/configuration/editor/