473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
5 3340
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Kevin | last post by:
I posted this to the sourceforge phpMyAdmin ng, but there was a comment that it was properly a php question, so I'm posting it here. I'm on Windows XP, and have just installed Apache, php 5, and...
0
by: Ryan Schefke | last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit ..I just sent this out to the win32 distribution list but no one has...
6
by: TonyB | last post by:
I'm running the zip'd version of PHP (PHP 5.1.2 zip package) downloaded from here: http://www.php.net/downloads.php. PHP won't connect with MySQL. >From docs and threads, it seems enabling...
0
by: Howard | last post by:
I have Apache Web Server 2.0.55 installed locally with MySQL 5.0.18-nt, and of course PHP 5.1.2 I also have installed phpMyAdmin. It is accessible through http://localhost/phpMyAdmin. The pathing...
5
by: news.telia.net | last post by:
Hi! I have a question. I have installed php and mysql on an apache-server on windows and I can't connect to the server. I tried to create a database (since I am trying to learn howto). My...
3
by: Susanne | last post by:
I have a server with my own domain and have created some users under htdocs/users/. I have installed phpMyAdmin under htdocs/. Everything works, but I can't open phpMyAdmin. I have made an alias in...
1
by: Raul Elms | last post by:
Hi, I'm running Apache2 together with the php and mysql modules on an opensuse 10.1 machine. Most scripts run well, I can connect and query databases without any problems. But some well known...
8
by: deko | last post by:
I've just loaded phpMyAdmin on a Debian Linux server with Apache2, MySql5 and PHP5. myserver # dpkg -l | grep php ii libapache-mod-php5 5.2.0-8+etch4 ii libapache2-mod-php4 4.4.4-8+etch2 ii...
39
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.