Newbies guide: PHP, MySQL and phpMyAdmin

[Goldmund]

Hi,

This is a newbies guide to installing and setting up PHP 5.0.3, MySQL 4.0 and phpMyAdmin 2.6.1. I am using Windows XP, by the way.

-Download phpMyAdmin 2.6.1 from http://www.phpmyadmin.net/home_page/downloads.php and follow the tutorial on http://www.trustabyss.com/.
-Download php 5.0.3-Win32.zip from http://www.php.net/downloads.php
*Be sure to download the one that reads: "PHP 5.0.3 zip package", because this is the one that comes with the 'php_mysql.dll' file.
-Follow the tutorial from http://www.trustabyss.com/ to install PHP
-Download the 'Collection of PECL modules for PHP 5.0.3'
*I'm not sure if you really need these, but do it anyway
-Extract these files to the 'C:/PHP/ext' folder
-Download MySQL 4.0 from http://dev.mysql.com/downloads/
-Follow the tutorial from http://www.trustabyss.com/
*When you first run MySQL create a username and password, which will
initiate the 'green light.'
-Go to your php.ini file in the 'C:/WINDOWS' folder and find...

;extension=php_mysql.dll

and change it to...

extension=php_mysql.dll

-Finally find...

extension_dir = "./"

and change it to...

extension_dir = "ext"

-Now if you open your Abyss Web Server Console and type in the URL:
http://127.0.0.1/phpadmin

Tada! You should see phpMyAdmin up and running!

Hope this helps!
_________________
You learn something new every day.

[Caduceus]

Hi,

I'm having a terrible time trying to get all three of these programs to work at the same time. I'm running on the following setup:

Sony VAIO (older machine) w/256Mb RAM and Win95
A dedicated 10Gb HD w/Abyss installed
In separate directories on the same drive, PHP and MySQL

I followed TRUSTpunk's tutorial, now I can't get MySQL to work.

There are several things that I need to clarify and maybe you can help.

1) Abyss says it's running on Port 80, but when you look at the url for phpadmin this is what I get

http://127.0.0.1:9999/phpadmin

2) When I go to that url I get a MySQL error

#2003 - The server is not responding

When I click on the link, the info at mysql.com I get the following re: that error code:

Error: 2003 (CR_CONN_HOST_ERROR)

Message: Can't connect to MySQL server on '%s' (%d)

3) I can't get MySQL to restart, although I had it running before I tried to set up phpadmin

Can you help?

Thanks

[Goldmund]

Caduceus, sorry for the long waited reply. I haven't used this forum in a while. Anyway, how are things with your server? Have you got it to work yet?

The first problem I see is is that you are using ":9999" in your URL. Don't do this, just go to http://127.0.0.1/phpadmin and this should work.

Secondly, I know a lot of people have had problems with starting the green light on MySQL. Have you downloaded the PECL modules for PHP and extracted them to the PHP/ext folder?

Also make sure you are downloading the right files for PHP, MySQL and phpMyAdmin (do not install the 'installer' ones, but the zip ones).

I'm installing my server all over again with all the new upgraded programs so I might run into some problems of my own. I wish you luck. Let me know how you are doing.
_________________
You learn something new every day.

[siralex205]

ok never mind i fixed it..THanks for the tutorial!

[anumeetsoni]

hi ! ur tutorial is good but i am facing a problem.

I have setup Abyss and PHP just fine and they seem to work fine, I tested using a test PHP script.
But i cannot seem to access Mysql from php. Even mysql itself is setup fine
how do i rectify this ?
when i try to run phpMyAdmin i get

"cannot load mysql extension;
please check PHP configuration
Documentation "

and the Abyss icon in system tray blinks with a green rectangle, I checked Php.ini in windows and it has the extension=php_mysql.dll line
plus the extension path is "ext" and i also checked the php install directory has a folder ext with all extensions including php_mysql.dll

I have php version 5.something and Mysql 4.1
Please help
also i tried installing phpBB and even that gave an error saying " your database type is not supported by your server" or something like that ...

Help would be really appreciated..thanx

[aprelium]

[ladytronica]

Okay, I've got Abyss Web Server, PHP5 (the package from here), MySQL and phpMyAdmin setup and everything is good, except for one thing: When I login to phpMyAdmin, I get this error message in red:

[ladytronica]

Nevermind, I got it to work!

I just forgot to remove the ";" from in front of "extension=php_mbstring.dll" in the "php.ini" file. When I did that and reloaded the page, the error message disappeared.
_________________
LT

[scorLex]

This :?
extension_dir = "C:/Php/ext/"

[Panda200x]

I tried adding PHP 5
http://www.aprelium.com/abyssws/php5win.html
and now i can't access my server.
What do I do?

[olly86]

what error are you getting?

(assuming error 500) most likely php has not been setup correctly, try following the install instructions again.
_________________
Olly

[AbyssUnderground]

[will-ko]

i just followed the Php tutorial in on that site and im pritty sure it didnt work. help me please :(

[TRUSTAbyss]

Make sure you save your PHP files in the ANSI encoding. You can do this by
using NotePad. If this doesn't fix the problem, can you post the code you're
using, that way we can give it a test to see if it's working?

Also, what's the version of Abyss Web Server you're using? Are you using the
correct FastCGI for the PHP version? PHP5 needs the "Local Pipes" option for
FastCGI Interface. Please review your settings.

[will-ko]

Sorry im new to this...
Could you please give me a little more detail?
Thanks

[hc2995]

switch the order about what to install yours is:
PMA installed first
PHP installed second
MySQL installed last

it should be:

PHP installed first
MySQL installed second
PMa installed last

That way that one person out there dosent try to install PMA then PHP5 then MySQL (couse theres bound to be 1 ;))
_________________
Where have i been? School got heck-tick, had to move half way around the state, then back... and then i had to change jobs, so iv been away for a while :P