RE: [PHP] PHP On Solaris 9 - MySQL Problem

> > I just finished doing that on a third machine that didn't have a > > previous MySQL installation. I installed the same version that the > > webserver has. I had the same results. > > I'm losing track here -- are you saying you can't connect to > another machine running MySQL 3.x from PHP but you can from > the mysql command line client? So this behavior is verified > against both a MySQL 3.x and 4.x server? I'm saying I can't connect to another machine running 3.x or 4.x from PHP, but I can connect to either via the v4.x mysql command line client that's installed on the webserver with PHP. > If so I agree, getting the router / firewall out of your way > is a good idea, though why it would matter if you can open a > socket connection, I don't know. I tried this too, same deal. > > > Note that the standard MySQL extension carries this note: > > > > > > This MySQL extension will not work with MySQL versions greater > > > than 4.1.0. For that, use MySQLi. > > > > > > > Not sure what MySQLi is, but I had thought since the 4.x > mysql client > > worked from the console, that there was no version problem > because it > > would be using the same client libraries that PHP is using. > Is that not the case? > > I'm not at all clear on that. For one thing it depends if > the various pieces were built dynamic or static. I would not > make this assumption. > > I thought you said the web server had MySQL 3.23 on it -- do > you also have a MySQL 4 client there? No, the webserver only has MySQL v4.x installed from a sparc binary. I'm going to compile a new MySQL with debugging and see if that helps. Let me know if you have any other ideas and thanks for your help. Cameron