Installing AMP locally

[trib4lmaniac]

AMP is LAMP for windows :D I do not have a clue what to do here. But the recent release of PHP5 has inspired me to at least try to install it locally on WinXP. I imagine I'd be using Apache with it, aswell as MySQL. (They're free!) But I do not have a clue what to do with the downloads though. (I have downloaded apache_2.0.50-win32-x86-no_ssl.msi, php-5.0.0-Win32.zip and mysql-4.0.20d-win.zip from their respective sites.) If I need to download different files for an easier installation, (or just to work it,) no fuss. Just tell me.

All help is appreciated.

[raf]

LAMP for windows = WAMP.

Can't help you on installationtips. I always just plug a selfinstalling package from somewhere. Plenty of choice:
http://www.google.be/search?q=php5+windows+install&ie=UTF-8&hl=nl&meta=

[trib4lmaniac]

Thanks, WAMP5 works. But I'm having a problem with MySQL. Everytime I try to connect to it, MySQL shuts down! I get the message "Lost connection to MySQL server during query"

[raf]

you mean that you try to connect inside a PHP-script, right?

is that a MySQL errormessage, or is it one of your own errormessages?

[trib4lmaniac]

When I try to connect through phpMyAdmin, which I suppose counts as script.
And no, it's a error that is listed in the MySQL documentation.

[raf]

i don't realy know much about the phpmyadmin backend.

have you tried running a query from one of your own pages? (after verifying that mysql is running + that you have an account set up + that there is at leas one db with one table on your dataserver)

[trib4lmaniac]

Hmm, the wamp icon changes depending on what services are running. Half full if php is running, completly full if both php and mysql are running. If I try to connect to the database through anything, the icon changes to half full! (Because mysql gets disabled.) If I don't do anything at all it will stay on for about 30 seconds... then stop.

[raf]

check out in the task-manager which processes are running (before running the PHP page, then right after you run it etc).

sounds to me like PHP is crashing the mysql server ...

[trib4lmaniac]

Now I can only get it to run for about 3 seconds, then it stops. In task manager mysqld-nt.exe runs then disappears. It's nothing to do with php by the looks of it!

[mordred]

What does the MySQL error log say? Can you connect and send queries through the MySQL client program (mysql.exe)?

[trib4lmaniac]

040719 10:48:44 InnoDB: Started
040719 10:48:44 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040719 10:48:44 Aborting

040719 10:48:44 InnoDB: Starting shutdown...
040719 10:48:46 InnoDB: Shutdown completed
040719 10:48:46 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown CompleteWhy cant you just send a quote without having to write something after it :thumbsup:

[mordred]

Uhm, judging from the smiley you put at the end of your post, can I assume you got it finally working? If not, it looks like your installation process seems to have missed some essential tables in the mysql database.

[trib4lmaniac]

Nope :(

[mordred]

There are some similar error descriptions in the MySQL manual which might be relevant to your situation (especially what's written in the user comments):
http://dev.mysql.com/doc/mysql/en/Cannot_find_table.html

[Grant Palin]

Sounds like you're having trouble with a prepackaged server. Maybe you'd be interested in setting up WAMP yourself (without a packaged server). It's not that hard. And you have much more control this way.

Here (http://www.ricocheting.com/server/index.html) is an excellent tutorial on setting up your own server software. I just followed the instructions, and had no problems!

[trib4lmaniac]

Thanks Grant, I'll try it. First I'll spring clean my pc though! (Reinstall windows :D)

[trib4lmaniac]

That's what I get when I load Apache! I've followed that tutorial Grant posted and It worked perfectlyuntil I tried the MySQL functions....

Fatal error: Call to undefined function mysql_connect() in C:\web\index.php on line 2

Looking it up on php.net I found this (http://uk.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5). So I uncommented the appropriate line in php.ini and copied libmySQL.dll to my %SYSTEMROOT% directory, (c:\WINDOWS,) and got the error message in the title when I restarted Apache.

Looking around on the net I found people with the same trouble, but all they did was copy libmysql.dll to their Apache\bin directory, which I have since tried!

All help appreciated as this is no fun :(

[trib4lmaniac]

Solved it by putting both files in all 3 directories then working backwards from there!

[Grant Palin]

So is it all working now? When I did the tutorial, I went with PHP 4, since it was some time ago. I'm in no rush to move to PHP5...I'm going to let everyong else iron out the bugs first!

[trib4lmaniac]

Seems to be working fine now :thumbsup:

[Grant Palin]

Have fun! :D :thumbsup: