【原创】大叔经验分享（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]]]或其他名字区分

 

然后重启hue

 

参考：
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/