blocks|key|4890190|text|您要做的是设置一个所谓的"LAMP“服务器(Linux、Apache、MySQL、PHP)。有很多关于如何设置它们的指南，比如http://www.ubuntugeek.com/step-by-step-ubuntu-810-intrepid-ibex-lamp-server-setup.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4890191|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ubuntugeek.com/step-by-step-ubuntu-810-intrepid-ibex-lamp-server-setup.html^0|1R|2E|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]]]]

What you are trying to do is set up what's called a "LAMP" server (Linux, Apache, MySQL, PHP). There are plenty of guides on how to set these up, such as <a href="http://www.ubuntugeek.com/step-by-step-ubuntu-810-intrepid-ibex-lamp-server-setup.html" rel="nofollow">http://www.ubuntugeek.com/step-by-step-ubuntu-810-intrepid-ibex-lamp-server-setup.html</a>

blocks|key|3478402|text|为了在PHP脚本中连接到MySQL数据库，您需要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3478403|3478404|使用用户正确配置了MySQL服务器，该用户在从启动mysql_connect脚本的主机到运行MySQL数据库的主机的|ordered-list-item|3478405|的mysql_connect()+function|3478406|Network连接中具有相应的PHP指定参数|unordered-list-item|3478407|3478408|PHP脚本可以在命令行中执行，也可以作为web应用程序执行。显然，只有在第二种情况下才需要Apache+web服务器。|3478409|对于您的特定错误，您可以在ServerFault上查看相应的问题，例如在this+one上。|offset|length|3478410|entityMap|0|LINK|mutability|MUTABLE|url|https://serverfault.com/questions/80044/cant-start-mysql-on-mac-os-x-getting-mysql-sock-connection-error^0|0|0|0|0|0|0|0|10|8|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|12|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|13|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|15|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@]|9|@$P|17|Q|18|1|19]]|A|$]]|$1|R|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

In order to make connection to MySQL database from in PHP script, you need:

<ol>
<li>Correctly configured MySQL server, with user, which has corresponding permissions</li>
<li>Correctly specified parameters in mysql_connect() function</li>
<li>Network connection from host where PHP script is started to host where MySQL database is running</li>
</ol>

PHP script may be executed either in command-line, or as web application. Obviously, Apache web server is necessary only for the second case.

For your specific error, you may take a look at corresponding questions at ServerFault, for example, at <a href="https://serverfault.com/questions/80044/cant-start-mysql-on-mac-os-x-getting-mysql-sock-connection-error">this one</a>.

blocks|key|4890270|text|这与Apache无关；它与MYSQL服务器和PHP的配置有关。可以通过网络或本地UNIX域套接字访问数据库(取决于配置)。在您的示例中，配置了PHP+(通过MySQL客户端库)在/var/lib/mysql.sock中查找套接字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4890271|检查配置。确保数据库正在运行。检查/var/lib/mysql中的套接字。|4890272|顺便说一下，在我的系统上，套接字位于/var/run/mysqld/mysqld.sock中。这是从/etc/mysql/my.cnf配置的。|4890273|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|$]]

This is not Apache related; it's related to the configuration of the MYSQL server and PHP. The database can be reached via the network or local UNIX domain sockets(depending on configuration). In your case, PHP (via the MySQL client lib) is configured find a socket in /var/lib/mysql.sock.

Check the configuration. Ensure the database is running. Check for the socket in /var/lib/mysql. 

BTW on my system, the socket is in /var/run/mysqld/mysqld.sock. That was configured from /etc/mysql/my.cnf.

blocks|key|3478215|text|首先，即使没有与数据库建立任何连接，也需要Apache来运行PHP。通常，Apache将PHP作为DLL运行，您需要在Apache安装的httpd.conf+(配置)文件中输入一些命令。你熟悉这些吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3478216|其次，为了通过mysql_connect与数据库建立连接，您必须已经启动并运行了MySQL服务器。我不是Linux用户，但在Windows中，我已经将MySQL注册为服务，以便在启动时启动。然而，它们也可能是在Linux中实现这一点的一种方式。|3478217|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|$]]

First of all, you need Apache to run PHP even if you are not making any connections to your database. Usually Apache runs PHP as a DLL and you need to enter some commands in the httpd.conf (configuration) file of your Apache installation. Are you familiar with these?

Second, you have to have the MySQL server already up and running, in order to make a connection to your database through mysql_connect. I am not a Linux user, but in Windows, I have registered MySQL as a service to be started at startup. However, they may well be a way of doing this in Linux as well.

blocks|key|4890167|text|再说一次，这些是针对Windows的-抱歉！您应该将路径替换为Linux+Apache安装中的路径和DLL的名称。这些是针对PHP版本5的(如果您正在使用它)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4890168|PHPIniDir+"C:/Program+Files/PHP/“LoadModule+php5_module+"C:/Program+Files/PHP/php5apache2_2.dll”|4890169|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|$]]

Again, these are for Windows - sorry!
You should replace the paths with the ones you have in your Linux Apache installation and the name of the DLL. And these are for version 5 of PHP (if that is what you are using)

PHPIniDir "C:/Program Files/PHP/"
LoadModule php5_module "C:/Program Files/PHP/php5apache2_2.dll"

I am runing linux mint. I have a mysql db called Test. Do i need apache or something to hook it up to my db? 

When i try to do my php myqlconnect i get this:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any ideas? thanks!

How to hook up mysql to my website?

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

我正在运行linux mint。我有一个名为Test的mysql数据库。我需要apache之类的东西才能把它挂到我的数据库上吗？当我尝试执行php myqlconnect时，我得到这样的信息:警告: mysql_connect()函数。MySQL - connect :无法通过套接字‘/var/lib/mysql/mysql/mysql.sock’连接到本地mysql服务器(2)有什么想法吗？谢谢

问如何将mysql连接到我的网站？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将mysql连接到我的网站？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将mysql连接到我的网站？
EN