mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on Windows XP Home

[NewbieSupreme]

I installed Apache 2.0.58, tested it, got the "working" page. Installed
MySQL 5.0.22, and didn't really see how to test that, but there is a mysql
process running in the task manager. Ran through the PHP 5.1.4 installation
directions, and that seems to work, since I can use phpinfo() and get all
the information on a test php page.

Then I installed (really just unzipped and placed some files according to
the directions) PHPMyAdmin; did the configuration, ran through their setup
script, and that all seemed to go OK.

However, when attempting to open the index.php in the PHPMyAdmin folder, it
says it couldn't open the mysqli connection (also tried setting it to mysql
in the config, but same message).

I then searched the groups and saw the big uproar that php 5 as a windows
installer package did not include mysql support the way previous versions
did. Some posts said the only option was to compile it myself w/ mysql
support, or wait for a dll to be made. However, all these posts were from
2003 - 2005. I also searched online documentation at php.net, but could
find no successful searches for adding mysql support to php 5.

Can anyone tell me if there's a way to get phpmyadmin and mysql working on
this Windows XP Home machine running Apache2? Do I need to downgrade
versions of something, or can I somehow add some lines to my PHP files and
put a dll somewhere?

Secondary question: I notice that I have a php.ini file in the Windows
directory, and that's the one showing in the phpinfo() info as well. But
the main PHP folder is in c/PHP, and the ini_recommended and all that is in
there. Did I screw up the PHP install? Meaning, should the php.ini file be
in the php folder instead of the Windows folder?

Thanks for any help and/or advice; I am a complete newb, normally an asp and
Access guy (and no expert at that) trying to learn the MySQL/PHP way of
things.

Thanks for reading

[Paul Lautman]

Re: mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on Windows XP Home

NewbieSupreme wrote:[color=blue]
> I installed Apache 2.0.58, tested it, got the "working" page. Installed
> MySQL 5.0.22, and didn't really see how to test that, but
> there is a mysql process running in the task manager. Ran through
> the PHP 5.1.4 installation directions, and that seems to work, since
> I can use phpinfo() and get all the information on a test php page.
>
> Then I installed (really just unzipped and placed some files
> according to the directions) PHPMyAdmin; did the configuration, ran
> through their setup script, and that all seemed to go OK.
>
> However, when attempting to open the index.php in the PHPMyAdmin
> folder, it says it couldn't open the mysqli connection (also tried
> setting it to mysql in the config, but same message).
>
> I then searched the groups and saw the big uproar that php 5 as a
> windows installer package did not include mysql support the way
> previous versions did. Some posts said the only option was to
> compile it myself w/ mysql support, or wait for a dll to be made. However,
> all these posts were from 2003 - 2005. I also searched
> online documentation at php.net, but could find no successful
> searches for adding mysql support to php 5.
> Can anyone tell me if there's a way to get phpmyadmin and mysql
> working on this Windows XP Home machine running Apache2? Do I need
> to downgrade versions of something, or can I somehow add some lines
> to my PHP files and put a dll somewhere?
>
> Secondary question: I notice that I have a php.ini file in the
> Windows directory, and that's the one showing in the phpinfo() info
> as well. But the main PHP folder is in c/PHP, and the
> ini_recommended and all that is in there. Did I screw up the PHP
> install? Meaning, should the php.ini file be in the php folder
> instead of the Windows folder?
> Thanks for any help and/or advice; I am a complete newb, normally an
> asp and Access guy (and no expert at that) trying to learn the
> MySQL/PHP way of things.
>
> Thanks for reading[/color]

Why not just install XAMPP and get an immediate working system?

[rb]

Re: mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on Windows XP Home


"NewbieSupr eme" <newbiesupreme@ yahoo.com> wrote in message
news:d9adnZYvvZ vwLRLZnZ2dnUVZ_ sidnZ2d@comcast .com...[color=blue]
> I installed Apache 2.0.58, tested it, got the "working" page. Installed
> MySQL 5.0.22, and didn't really see how to test that, but there is a mysql
> process running in the task manager. Ran through the PHP 5.1.4[/color]
installation[color=blue]
> directions, and that seems to work, since I can use phpinfo() and get all
> the information on a test php page.
>
> Then I installed (really just unzipped and placed some files according to
> the directions) PHPMyAdmin; did the configuration, ran through their setup
> script, and that all seemed to go OK.
>
> However, when attempting to open the index.php in the PHPMyAdmin folder,[/color]
it[color=blue]
> says it couldn't open the mysqli connection (also tried setting it to[/color]
mysql[color=blue]
> in the config, but same message).
>
> I then searched the groups and saw the big uproar that php 5 as a windows
> installer package did not include mysql support the way previous versions
> did. Some posts said the only option was to compile it myself w/ mysql
> support, or wait for a dll to be made. However, all these posts were from
> 2003 - 2005. I also searched online documentation at php.net, but could
> find no successful searches for adding mysql support to php 5.
>
> Can anyone tell me if there's a way to get phpmyadmin and mysql working on
> this Windows XP Home machine running Apache2? Do I need to downgrade
> versions of something, or can I somehow add some lines to my PHP files and
> put a dll somewhere?
>
> Secondary question: I notice that I have a php.ini file in the Windows
> directory, and that's the one showing in the phpinfo() info as well. But
> the main PHP folder is in c/PHP, and the ini_recommended and all that is[/color]
in[color=blue]
> there. Did I screw up the PHP install? Meaning, should the php.ini file[/color]
be[color=blue]
> in the php folder instead of the Windows folder?
>
> Thanks for any help and/or advice; I am a complete newb, normally an asp[/color]
and[color=blue]
> Access guy (and no expert at that) trying to learn the MySQL/PHP way of
> things.
>
> Thanks for reading
>
>[/color]
Hi,
Or you could also try apache2triad, which is also a complete instalation

http://apache2triad.net/

Robert

[Jerry Stuckle]

Re: mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on WindowsXP Home

NewbieSupreme wrote:[color=blue]
> I installed Apache 2.0.58, tested it, got the "working" page. Installed
> MySQL 5.0.22, and didn't really see how to test that, but there is a mysql
> process running in the task manager. Ran through the PHP 5.1.4 installation
> directions, and that seems to work, since I can use phpinfo() and get all
> the information on a test php page.
>
> Then I installed (really just unzipped and placed some files according to
> the directions) PHPMyAdmin; did the configuration, ran through their setup
> script, and that all seemed to go OK.
>
> However, when attempting to open the index.php in the PHPMyAdmin folder, it
> says it couldn't open the mysqli connection (also tried setting it to mysql
> in the config, but same message).
>
> I then searched the groups and saw the big uproar that php 5 as a windows
> installer package did not include mysql support the way previous versions
> did. Some posts said the only option was to compile it myself w/ mysql
> support, or wait for a dll to be made. However, all these posts were from
> 2003 - 2005. I also searched online documentation at php.net, but could
> find no successful searches for adding mysql support to php 5.
>
> Can anyone tell me if there's a way to get phpmyadmin and mysql working on
> this Windows XP Home machine running Apache2? Do I need to downgrade
> versions of something, or can I somehow add some lines to my PHP files and
> put a dll somewhere?
>
> Secondary question: I notice that I have a php.ini file in the Windows
> directory, and that's the one showing in the phpinfo() info as well. But
> the main PHP folder is in c/PHP, and the ini_recommended and all that is in
> there. Did I screw up the PHP install? Meaning, should the php.ini file be
> in the php folder instead of the Windows folder?
>
> Thanks for any help and/or advice; I am a complete newb, normally an asp and
> Access guy (and no expert at that) trying to learn the MySQL/PHP way of
> things.
>
> Thanks for reading
>
>[/color]

Well, if phpinfo() is showing the php.ini in your windows directory as being
active, then that's the one that's active. Try changing that one. There's a
registry entry to tell you which php.ini to use - but I never remember or worry
about it. I just use the one in c:\windows (it doesn't get overlaid during the
next install, either).

I've run several versions of PHP 5 here on Windows (currently at 5.1.2) and all
work with MySQL just fine.

BTW, I tried xamp. It worked OK. But I like more control over my setup. So I
installed all from scratch. Once you've done it a couple of times it isn't
hard. But that first time is a real bear. And I'll be repeating that process on
a brand new customer VPS later today. Planning on a couple of hours to install
and configure IIS, Apache (different ports), PHP, MySQL, Perl and about 4 web apps.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Tim Van Wassenhove]

Re: mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on Windows XP Home

On 2006-06-14, NewbieSupreme <newbiesupreme@ yahoo.com> wrote:[color=blue]
> I installed Apache 2.0.58, tested it, got the "working" page. Installed
> MySQL 5.0.22, and didn't really see how to test that, but there is a mysql
> process running in the task manager. Ran through the PHP 5.1.4 installation
> directions, and that seems to work, since I can use phpinfo() and get all
> the information on a test php page.[/color]

Ran through the php5.1.4 installation? Afaik, the installer doesn't come
with modules for mysqli etc.. I think the zip package is what you need.

And read through the INSTALL.TXT that comes with it.

First configure a PHPRC environment variable, eg: C:\Program
Files\php-5.1.4-Win32 (php will look in this directory for a php.ini
file)

All your httpd.conf needs are the following lines:

LoadModule php5_module "C:/Program Files/php-5.1.4-Win32/php5apache2.dll "
AddType application/x-httpd-php .php

And make sure to uncomment the line(s) where the mysql and mysqli
extensions are loaded in the php.ini file.

In my experience, it may be possible that you also have to make sure
that the mysql/bin directory is in your path.


--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be >

[otrWalter@gmail.com]

Re: mysql 5.0.22, php 5.1.4, and phpmyadmin on Apache2 on Windows XP Home

The best way to install Apache, PHP (with PEAR), mySQL, Perl (even
Python!), CVS (with ssh keys!) and SSH is...

web.torres.ws/walters_way

* Takes a little time to set up.
* Takes very little time to back-up
* Take even less time to restore!
* Gives you a real good understanding of how all this fits together
* Gives you virtual hosts
* PHP with PEAR
* Perl with CPAN
* Python, if you care
* command line CVS
* command line ssh/2
* CVS via SH keys to sourcesforge (if you care)
* mySQL
* phpMyAdmin is a drop in after all this
* many scripts and PHP apps (ex: Joomla) are drop ins!

And best of all!
* Nothing!!! in WINDOWS folder
* Nothing!!! in registry!
* and I mean NOTHING!
* OK, maybe if you count the ENV VARS you have to create

This sysem works on all Windows based OS's and Servers from 98 up!

Walter