blocks|key|5246424|text|在Tools+>+Preferences+>+Databases下，必须设置第三方JDBC驱动程序路径。一旦设置了驱动程序路径，一个单独的“MySQL”选项卡将出现在“新建连接”对话框中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5246425|注意:这是可以从MySQL网站下载的JAR的同一个jdbc连接器。|5246426|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

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

blocks|key|752113|text|事实上，你应该同时做这两件事：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|752114|752115|752116|添加驱动程序|ordered-list-item|752117|752118|-+Download+driver+[https://maven.atlassian.com/content/groups/public/mysql/mysql-connector-java/5.1.29/](https://maven.atlassian.com/content/groups/public/mysql/mysql-connector-java/5.1.29/)
-+To+add+this+driver+:
-+In+Oracle+SQL+Developper+>+Tools+>+Preferences...+>+Database+>+Third+Party+JDBC+Drivers+>+Add+Entry...
-+Select+previously+downloaded+mysql+connector+jar+file.|code-block|syntax|javascript|752119|​|752120|752121|添加Oracle+SQL+developper连接器|752122|752123|-+In+Oracle+SQL+Developper+>+Help+>+Check+for+updates+>+Next
-+Check+All+>+Next
-+Filter+on+"mysql"
-+Check+All+>+Finish|752124|752125|752126|下次添加连接时，MySQL新选项卡可用!|offset|length|style|BOLD|752127|752128|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|8|5|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|C|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1A|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|1D|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|1F|8|@]|9|@]|A|$K|L]]|$1|U|3|N|5|6|7|1G|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1I|8|@$Y|1J|Z|1K|10|11]]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|14|$]]

In fact you should do both :

<hr>

<ol>
<li>Add driver

<ul>
<li>Download driver <a href="https://maven.atlassian.com/content/groups/public/mysql/mysql-connector-java/5.1.29/">https://maven.atlassian.com/content/groups/public/mysql/mysql-connector-java/5.1.29/</a></li>
<li>To add this driver :</li>
<li>In Oracle SQL Developper > Tools > Preferences... > Database > Third Party JDBC Drivers > Add Entry...</li>
<li>Select previously downloaded mysql connector jar file.</li>
</ul></li>
<li>Add Oracle SQL developper connector

<ul>
<li>In Oracle SQL Developper > Help > Check for updates > Next</li>
<li>Check All > Next</li>
<li>Filter on "mysql"</li>
<li>Check All > Finish</li>
</ul></li>
<li>Next time you will add a connection, MySQL new tab is available !</li>
</ol>

blocks|key|752071|text|下面是另一个非常详细的演练，它也向您展示了整个过程，包括在安装JDBC驱动程序之后在连接对话框中放入什么值：http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|752072|entityMap|0|LINK|mutability|MUTABLE|url|http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html^0|1I|28|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Here's another extremely detailed walkthrough that also shows you the entire process, including what values to put in the connection dialogue after the JDBC driver is installed: <a href="http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html">http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html</a>

blocks|key|749032|text|我使用windows客户端和linux/mysql服务器的经验：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|749033|当sqldev用于windows客户端，而mysql安装在linux服务器上时，意味着sqldev可以通过网络访问mysql。|749034|假设mysql已经启动并运行，并且要访问的数据库已经启动并正常运行：|749035|·确保sqldev的版本(32或64)。如果为64并避免处理路径访问，请将有效的64版本的msvcr100.dll复制到目录~\sqldeveloper\jdev\bin中。|749036|a.在记事本中打开msvcr100.dll文件，搜索第一次出现的PE|749037|+i.+“PE++d”+it+is+64.

ii.+“PE++L”+it+is+32.|code-block|syntax|javascript|749038|b.注意:如果sqldev为64，msvcr100.dll为32，则应用程序在启动时会卡住。|749039|·要让sqldev与mysql一起使用，需要JDBC+jar驱动程序。从mysql站点下载。|749040|a.驱动程序名称=+mysql-connector-java-x.x.xx|749041|b.将其复制到与sqldeveloper目录相关的某个位置。|749042|c.在菜单中设置sqldev+Tools/Preferences/Database/Third+Party+JDBC+Driver+(添加条目)|749043|·在Linux/mysql服务器中更改文件/etc/mysql/mysql.conf.d/mysqld.cnf查找|749044|bind-address+=+127.0.0.1+(此linux本地主机)|749045|并更改为|749046|bind-address+=xxx.xxx(这是linux服务器的真实IP或机器名，如果DNS已启动)|749047|·进入linux+mysql并授予所需的访问权限，例如|749048|mysql+-u根-p|749049|GRANT+ALL+ON。通过‘mysqlPasswd’标识的root@'yourWindowsClientComputerName‘；|749050|刷新权限；|749051|重启mysql+-+sudo+/etc/init.d/mysql重启|749052|·启动sqldev并创建新连接|749053|a.用户=+root|749054|b.+pass+=(您的mysql+pass)|749055|c.选择MySql选项卡|749056|+i.+++Hostname+=+the+linux+IP+hostname

+ii.++Port+++++=+3306+(default+for+mysql)

+iii.+Choose+Database+=+(from+pull+down+the+mysql+database+you+want+to+use)

+iv.++save+and+connect|749057|在我的情况下，这就是我要做的一切。|749058|谢谢,|749059|白酒|749060|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|20|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|21|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|22|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|23|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|24|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|25|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|26|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|27|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|28|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|29|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|2A|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|2B|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2C|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|2D|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|2E|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2F|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|2H|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|2I|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|2J|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|L|7|2M|8|@]|9|@]|A|$M|N]]|$1|1Q|3|1R|5|6|7|2N|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|6|7|2O|8|@]|9|@]|A|$]]|$1|1U|3|1V|5|6|7|2P|8|@]|9|@]|A|$]]|$1|1W|3|-4|5|6|7|2Q|8|@]|9|@]|A|$]]]|1X|$]]

My experience with windows client and linux/mysql server:

When sqldev is used in a windows client and mysql is installed in a linux server meaning, sqldev network access to mysql.

Assuming mysql is already up and running and the databases to be accessed are up and functional:

• Ensure the version of sqldev (32 or 64). If 64 and to avoid dealing with path access copy a valid 64 version of msvcr100.dll into directory ~\sqldeveloper\jdev\bin.

a. Open the file msvcr100.dll in notepad and search for first occurrence of “PE “ 

<pre><code> i. “PE d” it is 64.

ii. “PE L” it is 32.
</code></pre>

b. Note: if sqldev is 64 and msvcr100.dll is 32, the application gets stuck at startup.

• For sqldev to work with mysql there is need of the JDBC jar driver. Download it from mysql site.

a. Driver name = mysql-connector-java-x.x.xx

b. Copy it into someplace related to your sqldeveloper directory.

c. Set it up in menu sqldev Tools/Preferences/Database/Third Party JDBC Driver (add entry)

• In Linux/mysql server change file /etc/mysql/mysql.conf.d/mysqld.cnf
 look for

bind-address = 127.0.0.1 (this linux localhost)

and change to

bind-address = xxx.xxx.xxx.xxx (this linux server real IP or machine name if DNS is up)

• Enter to linux mysql and grant needed access for example

# mysql –u root -p

GRANT ALL ON . to root@'yourWindowsClientComputerName' IDENTIFIED BY 'mysqlPasswd';

flush privileges;

restart mysql - sudo /etc/init.d/mysql restart

• Start sqldev and create a new connection

a. user = root

b. pass = (your mysql pass)

c. Choose MySql tab

<pre><code> i. Hostname = the linux IP hostname

 ii. Port = 3306 (default for mysql)

 iii. Choose Database = (from pull down the mysql database you want to use)

 iv. save and connect
</code></pre>

That is all I had to do in my case.

Thank you,

Ale

blocks|key|2992028|text|尽管@BrianHart的答案是正确的，但如果您从远程主机进行连接，则还需要允许远程主机连接到MySQL/MariaDB数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2992029|我的文章描述了在Oracle+SQL+Developer中连接到MySQL/MariaDB数据库的完整说明：|2992030|https://alvinbunk.wordpress.com/2017/06/29/using-oracle-sql-developer-to-connect-to-mysqlmariadb-databases/|offset|length|2992031|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|2Z|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

Although @BrianHart 's answer is correct, if you are connecting from a remote host, you'll also need to allow remote hosts to connect to the MySQL/MariaDB database.

My article describes the full instructions to connect to a MySQL/MariaDB database in Oracle SQL Developer:

<a href="https://alvinbunk.wordpress.com/2017/06/29/using-oracle-sql-developer-to-connect-to-mysqlmariadb-databases/" rel="nofollow noreferrer">https://alvinbunk.wordpress.com/2017/06/29/using-oracle-sql-developer-to-connect-to-mysqlmariadb-databases/</a>

blocks|key|3836285|text|您可能会发现以下内容也是相关的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3836286|Oracle+SQL+Developer+connection+to+Microsoft+SQL+Server|offset|length|3836287|在我的例子中，我必须将ntlmauth.dll放在sql-developer应用程序目录中(即sql-developer\jdk\jre\bin)。为什么这个位置在系统jre/bin上我不知道。但它起作用了。|style|CODE|3836288|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/23797585/oracle-sql-developer-connection-to-microsoft-sql-server/26598722#26598722^0|0|0|1J|0|0|B|C|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@$D|X|E|Y|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

You may find the following relevant as well:

<a href="https://stackoverflow.com/questions/23797585/oracle-sql-developer-connection-to-microsoft-sql-server/26598722#26598722">Oracle SQL Developer connection to Microsoft SQL Server</a>

In my case I had to place the <code>ntlmauth.dll</code> in the sql-developer application directory itself (i.e. sql-developer\jdk\jre\bin). Why this location over the system jre/bin I have no idea. But it worked.

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

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

How do you connect to a MySQL database using Oracle SQL Developer?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我已经安装了Oracle SQL Developer，并且能够连接和查询Oracle数据库。使用Help ->检查更新，我能够安装Oracle浏览器扩展，但没有用于MySQL数据库的连接选项。

问如何使用Oracle SQL Developer连接到MySQL数据库？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Oracle SQL Developer连接到MySQL数据库？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Oracle SQL Developer连接到MySQL数据库？
EN