Apache and PHP
Danesh Daroui
Danesh.D at bredband.net
Sat Nov 27 04:52:25 UTC 2004
Brian Richardson wrote:
> Danesh Daroui wrote:
>
>> file and also checked PHP.ini file to see if mysql.so which has PHP
>> mysql functions is loaded and it was loaded correctly. Also, when I
>> run my mysql script by PHP command line interpretet as: php
>> MySQLScript.php it show correct message and connects successfuly, but
>> through web server it does not. Can anybody help ?
>
>
> Sounds like an issue with how you're connecting. You need to connect
> to your mysql server through localhost:3306 from the web server (or at
> least make the UNIX domain socket read/write to the web server user,
> but don't do that). Since you run from the command line with different
> user privileges, standard connect works. However, I'd guess that doing
> so as the web server user doesn't work.
>
> Brian
>
MySQL works perfect on my system and it has no problem. It is a small
LAN (With 6 systems and one server) and MySQL has been installed on
server and works fine both remotely and locally. Also, yes, I connect
throught port 3306 and from localhost. In fact, I didn't define them in
PHP.ini because they will be retrieved from built-in MySQL variables
which are default if I do not set them to any specific valus.
More information about the users
mailing list