Re: [cobalt-developers] Update PHP3.0.7 to PHP3.0.16

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Rob Spurlock <rspurlock@xxxxxxxxxxxx> wrote:
> Well list,  I have done it now.  I have followed the instructions to update
> the required libraries and install a newer version of MySQL (to be followed
> by PHP3.0.16).  I went through the steps and now I have 2 different versions
> of MySQL installed on the server and both work fine (not at the same time of
> course).

Actually, you can run several instances of MySQL simultaneously.  I currently
have several different instances (mix of stable and development versions
optimized a little differently) running on some RaQ2s.  The trick is to install
each to run on different ports with different lock files and then to explicitly
state the port in PHP and Perl code calling the databases.

> Problem is I cannot use the newer version of MySQL with the PHP I
> have on there.  It will not allow me to connect using localhost.  How do I
> get rid of the older version (installed with RPMs) of MySQL and edit the new
> MySQL to work?  Help?

To delete the older MySQL that was installed by RPM find the RPM names and
delete them using "rpm -e package_name_here".  To find them do "rpm -qa | sort".
Newer versions of MySQL do not allow localhost as the host when calling from PHP
or Perl scripts.  If you are trying to access MySQL via localhost from the MySQL
commandline and you're unable to, it's probably b/c of a conflict between the
MySQL instances installed.  Maybe both are using the same port # and / or lock
file.

--
Steven Werby {steven-lists@xxxxxxxxxxxx}