Re: Connecting PHP to MySQL on Windows

[michael manning <michaelgmanning@xxxxxxxxx>]

Hi Daniel,

When testing with the CLI, netstat shows:
=========
C:\Users\mmanning>netstat -b

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    127.0.0.1:80           mmanning-PC:49391      ESTABLISHED
 [httpd.exe]
  TCP    127.0.0.1:3306         mmanning-PC:49338      ESTABLISHED
 [mysqld.exe]
  TCP    127.0.0.1:27015        mmanning-PC:49157      ESTABLISHED
 [AppleMobileDeviceService.exe]
  TCP    127.0.0.1:49157        mmanning-PC:27015      ESTABLISHED
 [iTunesHelper.exe]
  TCP    127.0.0.1:49262        mmanning-PC:49263      ESTABLISHED
 [firefox.exe]
  TCP    127.0.0.1:49263        mmanning-PC:49262      ESTABLISHED
 [firefox.exe]
  TCP    127.0.0.1:49264        mmanning-PC:49265      ESTABLISHED
 [firefox.exe]
  TCP    127.0.0.1:49265        mmanning-PC:49264      ESTABLISHED
 [firefox.exe]
  TCP    127.0.0.1:49338        mmanning-PC:3306       ESTABLISHED
 [mysql.exe]
  TCP    127.0.0.1:49391        mmanning-PC:http       ESTABLISHED
 [firefox.exe]
  TCP    130.130.48.79:49208    nimmo-37:8080          ESTABLISHED
 [googletalk.exe]
  TCP    130.130.48.79:49238    nimue-37:8080          ESTABLISHED
 [chrome.exe]
  TCP    130.130.48.79:49344    nimue-37:8080          ESTABLISHED
 [chrome.exe]
=======

I ran the same test script on my computer at home without difficulty.  It is
running Apache 2.2.16, PHP 5.3.3 and MySQL 5.1.51 on Windows XP Professional
SP3.

regards

Mike
michaelgmanning@xxxxxxxxx

On Fri, Jan 7, 2011 at 3:49 AM, Daniel Brown <danbrown@xxxxxxx> wrote:

> On Thu, Jan 6, 2011 at 01:13, michael manning <michaelgmanning@xxxxxxxxx>
> wrote:
> > Hi,
> >
> > I have installed MySQL 5.1.52, Apache 2.2.15 and PHP 5.3.2 on my Windows
> > Vista computer.
> > The MySQL works fine with the command line client and I have tested the
> > Apache and PHP and it appears fine when I test this with the phpinfo()
> > function.  There is just one exception - I cannot connect to a MySQL
> > database from within a PHP script.  I have installed the MySQLi extension
>
>     I know you said MySQL works fine from the CLI, but a stupid
> question: is the MySQL server running while you're trying to test from
> PHP?  And, if so, on what port does netstat show it running?
>
> --
> </Daniel P. Brown>
> Network Infrastructure Manager
> Documentation, Webmaster Teams
> http://www.php.net/
>