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&＃61;"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 &＃39;xe&＃39; by default.

name&＃61;db_dataone#Database backend to use. This can be:

#1. mysql

#2. postgresql

#3. oracle

engine&＃61;mysql#IP or hostname of the database to connect to.

host&＃61;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&＃61;3306

#Username to authenticate with when connecting to the database.

user&＃61;root#Password matching the username to authenticate with when

#connecting to the database.

password&＃61;123456

#Database options to send to the server when connecting.

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

## options&＃61;{}

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

除此之外&＃xff0c;还要添加notebook

[notebook]

[[interpreters]]

[[[impala]]]

name&＃61;Impala

[[[hive]]]

name&＃61;Hive

[[[mysql]]]

name&＃61;Mysql

interface&＃61;rdbms

[[[java]]]

name&＃61;Java

interface&＃61;oozie

[[[spark2]]]

name&＃61;Spark

interface&＃61;oozie

[[[shell]]]

name&＃61;Shell

interface&＃61;oozie

[[[sqoop1]]]

name&＃61;Sqoop1

interface&＃61;oozie

[[[distcp]]]

name&＃61;Distcp

interface&＃61;oozie

此处略去了不需要的Pig和MapReduce等&＃xff1b;

然后重启hue

如果要添加多个mysql&＃xff0c;如下配置&＃xff1a;

[librdbms]

[[databases]]

[[[mysql1]]]

...

[[[mysql2]]]

...

[notebook]

[[interpreters]]

[[[mysql1]]]

...

[[[mysql2]]]

...

参考&＃xff1a;

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/