my shell has mysql and php 4.2 they work fine from what ive seen, but then again i dont know to much about Mysql...

Concerning PHP, apparently due to an error in the conguration script, some happens to your MySQL module, causing it to map all 'localhost' calls to the db to 'localhost.localdomain'. Fortunatly, the PHP crew have give us a to reconfigure and recompile PHP with. Yay. Time for another 30 minutes of looking at scrolling text... Ah well.

im off topic here, but did you hear about ip version 6
the currernt version of the IP system we use now is ipv4 and its 32 bit, withh all the class range a,b,c,d,e, there all mostly sold out, ipv6 is 128 bit in hex. sounds nifty doesnt it...

Don't know allot about IPv6 yet, but hexadecimal? You mean hex IP adresses instead of decimal IP adresses? Like no more 212.187.15.61 but xD4.xBB.x0F.x3D ?

something like that it will be 128 bit in hex, so it would look something like this af:4d:00:b4:32:c2:ff:f5

IPv6 address look something like this: 3ffe:1900:4545:3:200:f8ff:fe21:67cf

A site with some information:

Although I must say that IPv6 has been greatly hindered by the proliferation of NAT (Network Address Translation).  Everything that was supposed to have taken an extra IP is usually just translated through special-purpose devices.  If you've got one of those excellent Cable/DSL routers that Linksys makes, you've got a little NAT box.

Just put the line:
127.0.0.1 localhost.localdomain

in your /etc/hosts file =).

All that aside, I've not tested Apache 2.0 and PHP 4.2 at all.  I guess I should update my ports collection more often =).  Even though Apache is the program that crashes the most on my boxes (2-3 crashes a day), it always starts back up transparently, so nobody ever notices it.

I don't see why (S)NAT hinders the development of IPv6. I think that IPv6 will be extremely hard to implement anyways due to the millions of PCs that will need instant changes to their most basic configurations, not to even mention the configurations of individual programs, the need to alter code etc... Would the advantages of IPv6 outweigh the disadvantages?

As for PHP 4.2.0, it's okay after I had build a new configure script. Everything seems to work more or less, but the GD libs seem to require humongous ammounts of systems resources, but I think that's mainly due to the fact that image generating is just a bitch on system resources.

And the MySQL bit isn't that easy to solve. All localhost connections were mapped to localhost.localdomain in the PHP MySQL libs, not due to a kernel issue. Using /etc/hosts would reroute it back to 127.0.0.1 but the request for authentication would still include localhost.localdomain as host, which would fail against most mysql.user tables because they usually only contain entries for localhost or remote hosts.

It doesn't directly hinder development of IPv6.  It's just that the need for IPv6 is less urgent because it's easy to map one IP to multiple devices with NAT.

Then why not do:
GRANT ... ...;

[Edit: Screw the SQL tag.  Stupid autoparser is going nuts on the email address.]