Apache Ranger如何使用MySQL8

Question

setup.sh默认使用的是MySQL5的驱动包里的com.mysql.jdbc.Driver驱动类，在哪里可以配置成使用MySQL8的驱动包中的com.mysql.cj.jdbc.Driver驱动类？

Answer 1

叁金 2020-04-22 14:17:37

你使用MySQL8的jdbc jar包，然后类用MySQL5的即可，是向下兼容的

• 提问者 吹雪一笑 #1

  这样不行，报错：
  Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
  Traceback (most recent call last):
    File "dba_script.py", line 1824, in <module>
      main(sys.argv)
    File "dba_script.py", line 1811, in main
      xa_sqlObj.create_rangerdb_user(xa_db_root_user, db_user, db_password, xa_db_root_password,dryMode)
    File "dba_script.py", line 230, in create_rangerdb_user
      if self.check_connection('mysql', root_user, db_root_password):
    File "dba_script.py", line 222, in check_connection
      if output.strip('Production  |'):

• 叁金 回复 提问者 吹雪一笑 #2

  上面那句话没关系的，你把异常粘贴完整

• 叁金 回复 提问者 吹雪一笑 #3

  脚本中你可以修改驱动类

点开查看后面2条评论