如何使用Oracle SQL Developer连接到MySQL数据库? [英] How do you connect to a MySQL database using Oracle SQL Developer?

问题描述

我已经安装了Oracle SQL Developer，并且能够连接和查询Oracle数据库.

I have Oracle SQL Developer already installed and am able to connect to and query Oracle databases.

使用帮助->检查更新我能够安装Oracle MySQL Browser扩展，但是MySQL数据库没有连接选项.

Using Help -> Check for Updates I was able to install the Oracle MySQL Browser extension but there are no connection options for MySQL databases.

推荐答案

在工具">首选项">数据库"下，必须设置第三方JDBC驱动程序路径.设置驱动程序路径后，新建连接"对话框中将出现一个单独的"MySQL"选项卡.

Under Tools > Preferences > Databases there is a third party JDBC driver path that must be setup. Once the driver path is setup a separate 'MySQL' tab should appear on the New Connections dialog.

注意:这是同一个jdbc连接器，可以从MySQL网站上通过JAR下载获得.

Note: This is the same jdbc connector that is available as a JAR download from the MySQL website.

这篇关于如何使用Oracle SQL Developer连接到MySQL数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！