If you read the thread I useda php page totest mysql connectivity after phpmyadmin did not work... At this point I am willing to pay someone to troubleshoot this as I am baffled there is no definitive troubleshooting documentation for Windows installs. From: Barry Stear [mailto:bstear@xxxxxxxxx] Sent: Wednesday, December 23, 2009 12:04 PM To: Adam Sonzogni Cc: PHP DB Posts Subject: Re: RE: Help for a beginner Well I am not familiar with ASP. You might want to check to make sure that you didn't make any typos in your mysql_test.php page. I would suggest seeing if you can connect through phpMyAdmin. That might give you a better idea of where the problem lies. On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni <asonzogni@xxxxxxxxxxxx<mailto:asonzogni@xxxxxxxxxxxx>> wrote: Barry, Yes this is all installed ona single system. The code was in the original message <% set conn=Server.CreateObject("ADODB.Connection") conn.ConnectionString="Driver={mySQL};Server=localhost;Database=test;User Id=root;Password=youwish" conn.open Response.write("Connected") conn.close %> So line 4 is: conn.open Thanks, Adam -----Original Message----- From: Barry Stear [mailto:bstear@xxxxxxxxx<mailto:bstear@xxxxxxxxx>] Sent: Wednesday, December 23, 2009 11:28 AM To: PHP DB Posts Subject: Re: RE: Help for a beginner Adam, What is at Line 4 in your test.asp? The error you provided said that there was a problem where it could not find the default driver to use. Also when you get the connection failed you were trying to connect to MYSQL from the system running MYSQL correct? On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni <asonzogni@xxxxxxxxxxxx<mailto:asonzogni@xxxxxxxxxxxx>>wrote: > Giff, > > Not sure what you mean, and I suspect this is because of my confusion > around PMA (as mentioned originally) SO let me elaborate... > > > > In my config.inc.php I changed pma to root and the pma password to the root > password for mysql > When I browse to the phpmyadmin page I neter root and the root password for > mysql > > Thanks, > Adam > > -----Original Message----- > From: Giff Hammar [mailto:ghammar@xxxxxxxxxxxxxx<mailto:ghammar@xxxxxxxxxxxxxx>] > Sent: Wednesday, December 23, 2009 10:41 AM > To: php-db@xxxxxxxxxxxxx<mailto:php-db@xxxxxxxxxxxxx> > Subject: Re: RE: Help for a beginner > > It looks like you are not connecting because of a user name/password > combination. Typically, Windows does not use root as a valid login as do > most other operating systems. Try using your login information to see if > you can connect to mySQL using the GUI. I suspect you'll succeed. The > other option would be to use the mySQL admin user name and password. One > of those should work. > > Once you can connect to your database with the GUI, you can then use PHP > to call the mySQL database connect strings and manipulate your data as > necessary. The DBD/DBI is a more generic solution that allows you to use > a standard coding structure in PHP (or perl) and easily change databases > underneath. For a small implementation, this isn't necessary. There are > other database abstraction layers that perform the same function. > > Giff > > On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote: > > why dont u install the xampp.... > > > > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni <asonzogni@xxxxxxxxxxxx<mailto:asonzogni@xxxxxxxxxxxx> > >wrote: > > > > > Mr. Brookhouse, > > > > > > Thanks for the quick reply. I am guessing it is not relevant to my case > > > because I am not using PERL. I cannot find anything that says PHP > requires > > > PERL so I suspect Iam ok in this regard. > > > > > > Thank You, > > > Adam > > > > > > > > > -----Original Message----- > > > From: Edward Brookhouse [mailto:ebroo@xxxxxxxxxxxxxxxxxxxxx<mailto:ebroo@xxxxxxxxxxxxxxxxxxxxx>] > > > Sent: Wednesday, December 23, 2009 9:59 AM > > > To: Adam Sonzogni; php-db@xxxxxxxxxxxxx<mailto:php-db@xxxxxxxxxxxxx> > > > Subject: RE: Help for a beginner > > > > > > Just a guess, as I have not tried a full stack in windows, but in any > unix > > > if you are connecting php and mysql, you need something in the middle > like > > > DBD::mysql > > > > > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856 > > > > > > > > > -----Original Message----- > > > From: Adam Sonzogni [mailto:asonzogni@xxxxxxxxxxxx<mailto:asonzogni@xxxxxxxxxxxx>] > > > Sent: Wednesday, December 23, 2009 9:52 AM > > > To: php-db@xxxxxxxxxxxxx<mailto:php-db@xxxxxxxxxxxxx> > > > Subject: Help for a beginner > > > > > > Hi everyone, first thank you for ALL help and the understanding that I > am > > > new to PHP and MySQL. This is a long email and for that I apologize but > I am > > > trying to provide as much detail as possible. If this is the wrong list > to > > > ask for help, kindly direct me to the proper authority. > > > > > > I am trying to learn and I have built the following environment. > > > > > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7 > > > mysql-essential-5.1.41-win32 > > > php-5.3.1-nts-Win32-VC9-x86.msi > > > phpMyAdmin-3.2.4-english.zip > > > > > > > > > I followed the steps as detailed below (I already had IIS7 and CGI > > > installed) > > > > > > > > > 1. Install CGI & PHP > > > > http://www.trainsignaltraining.com/iis-7-install-fastcgi-php/2008-09-04/ > > > > > > 2. Install MySQL > > > http://www.trainsignaltraining.com/install-mysql-on-iis7/2008-09-10/ > > > > > > 3. Install PHPMyAdmin > > > > > > > http://www.trainsignaltraining.com/install-phpmyadmin-on-iis7-and-server-2008/2008-09-16/ > > > > > > > > > After I completed the installations > > > 1. If I navigate to the PHP directory and type php -info it spews a ton > of > > > data at me > > > AND > > > I created info.php which contains: <?php phpinfo(); ?> > > > When I browse this, it correctly produces a page with all the info > about > > > my PHP server. Although I do not understand much of it I believe this > > > confirms PHP is working correctly with IIS > > > > > > 2. I open the MySQL CLI and perform the commands outlined in Step 23 at > > > this page > > > http://www.bicubica.com/apache-php-mysql/index.php > > > This returns the expected results, confirming MySQL is working > > > > > > 3. PHP is configured to work with php_mysql.dll as per the steps in the > > > trainsignal links above so I begin! > > > I go to the phpmyadmin page, enter root and my password and after a > long > > > time I get a FastCGI error. I am not ready to believe it because, in > classic > > > MS form, it has several VERY different potential causes, and I have > covered > > > all of those. Plus the error code is 0x00000000 which is like saying > > > nothing... I start thinking maybe it is not connecting to the mYSQL > server > > > right, the instructions re: pma and the password made no sense to me so > I > > > fiddle with that with no change. > > > > > > > > > I write the mysql_test.php page in step 5 of > > > http://www.bicubica.com/apache-php-mysql/index.php > > > This fails with: A connection attempt failed because the connected > party > > > did not properly respond after a period of time, or established > connection > > > failed because connected host has failed to respond. > > > > > > Because the PHP failed I try with ASP... > > > <% > > > set conn=Server.CreateObject("ADODB.Connection") > > > > conn.ConnectionString="Driver={mySQL};Server=localhost;Database=test;User > > > Id=root;Password=youwish" > > > conn.open > > > Response.write("Connected") > > > conn.close > > > %> > > > > > > This returns: > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > > > [Microsoft][ODBC Driver Manager] Data source name not found and > no > > > default driver specified > > > /test.asp, line 4 > > > > > > I believe I have established MySQL is working, but for some reason it > > > appears that it cannot be "reached" This IS on the same server so > firewall > > > should not be an issue, PLUS I confirmed the installer did create a > hole. I > > > turn off the MS firewall to be safe, no change.... I try a "repair" of > > > MySQL, I uninstall, reboot and reinstall with no change. > > > > > > NOTE: at several points I have tried iisreset and/or rebooting the > system > > > with no change. > > > > > > I start to research the matter and my mind is now unglued. I found > > > something referencing using mcrypt with PHPMyAdmin to speed it up and > > > wondered if maybe the long delay before the FastCGI error could be > resolved > > > so I tracked down the dll, put it in my ext directory and changed my > php.ini > > > to reflect this -- file found at > http://files.edin.dk/php/win32/mcrypt/ > > > > > > I found quite a bit about using libmysql.dll but there was no such file > in > > > my install, I pulled down the .zip package and that also did not > contain it, > > > I eventually found it in a 5.2.x archive but that does not seem to have > > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only > > > mysqli. None of this seems to have done anything to change my > situation. > > > > > > Again, I apologize for the lengthy message, I hope I have accurately > > > described my issue in the right amount of detail. > > > > > > Thank You! > > > Adam Sonzogni > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- <a href="http://www.c28.com/?adid=st&iid=19467";> <img src="http://www.c28.com/images/banner_88x31.gif"; border="0" width="88" height="31"></a> -- <a href="http://www.c28.com/?adid=st&iid=19467";> <img src="http://www.c28.com/images/banner_88x31.gif"; border="0" width="88" height="31"></a>
![http://www.c28.com/images/banner_88x31.gif"](http://www.c28.com/images/banner_88x31.gif"){kind=link}
