Re: Connecting PHP to MySQL on Windows

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@gmail.com On Fri, Jan 7, 2011 at 3:49 AM, Daniel Brown <danbrown@php.net> wrote: > On Thu, Jan 6, 2011 at 01:13, michael manning <michaelgmanning@gmail.com> > 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/ >