By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jun 14 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
NewbieSupreme wrote:
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


Why not just install XAMPP and get an immediate working system?
Jun 14 '06 #2

P: n/a
rb

"NewbieSupreme" <ne***********@yahoo.com> wrote in message
news:d9******************************@comcast.com. ..
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

Hi,
Or you could also try apache2triad, which is also a complete instalation
http://apache2triad.net/

Robert
Jun 14 '06 #3

P: n/a
NewbieSupreme wrote:
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


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.
js*******@attglobal.net
==================
Jun 14 '06 #4

P: n/a
On 2006-06-14, NewbieSupreme <ne***********@yahoo.com> wrote:
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.


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>
Jun 14 '06 #5

P: n/a
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

Jun 14 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.