blocks|key|2802384|text|作为解决办法，您可以在mysql中启用网络连接，并使用phpstorm中的IP+127.0.0.1连接到数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2802385|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As a workaround, you could enable networked connections in mysql and connect to the database using the IP 127.0.0.1 in phpstorm.

blocks|key|1246381|text|你只要用JDBC连接器就行了。我以前用过Eclipse。不熟悉PHP风暴。我不确定它是否附带MAMP，所以你可能需要下载和安装它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1246382|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mysql.com/downloads/connector/j/^0|4|7|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]]]]

Well you could just use the <a href="http://www.mysql.com/downloads/connector/j/" rel="nofollow">JDBC connector</a>. I have used with Eclipse in the past. Not familiar with PHP storm. Im not sure if it comes with MAMP so you may have to download and install it.

blocks|key|2443160|text|据我所知，JDBC不支持Unix域套接字。您必须通过TCP/IP连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2443161|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As I understand it, JDBC does not support Unix domain sockets. You have to connect over TCP/IP.

blocks|key|2443174|text|我发现这篇文章很有用：http://pro-cosmos.blogspot.com/2011/03/phpstorm-mysql.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2443175|我成功地将phpstorm配置为使用mysql，但我使用"jdbc:mysql://localhost:3306作为url。|style|BOLD|2443176|entityMap|0|LINK|mutability|MUTABLE|url|http://pro-cosmos.blogspot.com/2011/03/phpstorm-mysql.html^0|B|1M|0|0|S|S|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@$A|U|B|V|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

I found this article useful: <a href="http://pro-cosmos.blogspot.com/2011/03/phpstorm-mysql.html">http://pro-cosmos.blogspot.com/2011/03/phpstorm-mysql.html</a> 

I successfully configured phpstorm to work with mysql but I used "jdbc:mysql://localhost:3306 as url.

blocks|key|1246420|text|在add连接窗口的顶部选择MySQL，然后单击下载。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246421|然后可以使用连接字符串jdbc:mysql://localhost:3306/databasename。连接字符串格式也包含在输入框的自动完成中。|offset|length|style|CODE|1246422|entityMap^0|0|B|14|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

On the top part of the add DB connection window choose MySQL, then click for download.

Then you can use the connection string <code>jdbc:mysql://localhost:3306/databasename</code>. The connection string format is also contained in the autocomplete of the input box.

blocks|key|2802419|text|不能在标准JDBC驱动程序中使用Unix套接字。JDBC并没有禁止编写Unix套接字驱动程序，但我不知道。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2802420|相反，您可能希望在MySQL中启用网络连接，并使用以下JDBC：|2802421|jdbc:mysql://localhost/mysql|2802422|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

You can't use Unix sockets with the standard JDBC driver. There's nothing about JDBC that prohibits writing a Unix socket driver, but I don't know of one.

Instead, you'll likely want to enable network connections in MySQL and use the following JDBC URL:

jdbc:mysql://localhost/mysql

blocks|key|2802460|text|这是我设定的屏幕截图。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2802461|谢谢cweiske的127.0.0.1，没有使用本地主机。|2802462|📷|atomic|offset|length|2802463|​|2802464|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/52148127a3f6aa537b69504afaf0b1cf.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|V|8|@]|9|@$G|W|H|X|1|Y]]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R|S|-4]]]]

Here's a screenshot of my settings.

Thanks cweiske for 127.0.0.1, didn't work with localhost.<img src="https://i.stack.imgur.com/8hck6.png" alt="enter image description here">

blocks|key|2443351|text|您唯一需要做的就是检查MAMP上的MySQL选项卡中的“允许网络访问MySQL”选项(为了您的安全，确保选择了“仅来自此Mac”的选项)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2443352|下面是这个场景的屏幕截图|offset|length|2443353|entityMap|0|LINK|mutability|MUTABLE|url|http://i.stack.imgur.com/CC3tX.png^0|0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

The only thing you have to do is check the option "Allow network access to MySQL" inside the MySQL tab on MAMP (for your security, ensure you have the option "only from this Mac" selected).

<a href="http://i.stack.imgur.com/CC3tX.png">Here is a screenshot of the setting</a>

blocks|key|2443369|text|对于套接字连接，请使用8889端口。示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2443370|jdbc:mysql://localhost:8889/|code-block|syntax|javascript|2443371|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For socket connecting use a 8889 port. Example:

<pre><code>jdbc:mysql://localhost:8889/
</code></pre>

For those of you who are familiar with Phpstorm I am using version 2.0.1 as writing this question.

I am on a Mac using MAMP. I tried to connect my database with Phpstorm but it is a bit confusing.

I went to tools -> data sources
when I press + to add 
and choose db datasource
it wants me to enter a "<code>jdbc://</code>" URL to the database. 

The whole time until now I've been using <code>/Applications/MAMP/tmp/mysql/mysql.sock</code>.

How do I get the db to connect with this socket thing? The software is amazing but confusing at times.

Mysql Connection with Phpstorm IDE

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

对于那些熟悉Phpstorm的人，我用2.0.1版本来写这个问题。我正在使用MAMP的Mac电脑上。我试图将我的数据库与Phpstorm连接起来，但这有点让人费解。当我按+添加并选择db数据源时，我转到tools ->数据源，它希望我向数据库输入一个"jdbc://“URL。到目前为止，我一直在使用/Applicati...

问Mysql与Phpstorm IDE的连接
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Mysql与Phpstorm IDE的连接EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Mysql与Phpstorm IDE的连接
EN