473,378 Members | 1,495 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,378 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 3342
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.