MySQL 5.0.18 & PHP 5

I'm running MySQL 5.0.18 on my NW6.5.4 server. I created a PHP page that 
access my databases and do a list. It's just a test page to make sure my 
connection is working. The Apache2 server is on the same server as the 
MySQL server.

The weird thing is...my PHP page can't connect to the MySQL server. I 
created a test user and gave it full rights to everything and it can't 
connect. I created the user as test@localhost and test@% and they won't 
work. Both users have full access to the database. However, if I use 
"root," it'll work. Other than root, no one else can connect to the 
database via PHP.

If I try using MySQL admin or from the console, it works. It just won't 
work through the PHP unless I use the "root" username. Anybody know
why 
it's doing this?

Btw, I've also tried a different PHP server accessing the MySQL server 
and it still results to the same thing. Maybe something wrong with the 
MySQL server?

Hi Howard,
Nuri Inuki <howard.yuan@nospam.valence.com> wrote in
news:9jH_f.3541$vF3.517
@prv-forum2.provo.novell.com:

> Btw, I've also tried a different PHP server accessing the MySQL server 
> and it still results to the same thing. Maybe something wrong with the 
> MySQL server?
I doubt - seems more a client problem; you cant access a mysql5 server with a 
mysql4.0 client (at least not with paswsword)- but that's what PHP comes with 
by default.
You will have to update your php_mysql(i) extensions and make sure that the 
new libmysql.nlm gets loaded (delete any other ones, f.e. in sys:/system).
The PHP extensions should be available from the PHP Forge site.