PHWinfo - Afficher un message

30/03/2006, 00h04

Greg Noss wrote:
> Thanks for your input, I had another app. that installed their version of
> MySQL I wasn't using their functions I removed their version adn PRESTO
> MySQL worked.

I would guess that your copy of MySQL wasn't running at all; it was the
vendor's instance running on the same port. That would explain why your
password wasn't being recognized.

> Is it possible to run to different copies of MySQL on the
> same machine?

Yes, it should be possible to do so.

More recent versions of MySQL support the concept of running "instances"
of one installation.
http://dev.mysql.com/doc/refman/5.0/...e-manager.html

But if you want to run multiple instances of _different_ MySQL
installations (for example, if you want to keep several different
versions available for testing), it gets trickier.

They need to be installed in different directories, and they must not
touch each other's databases. They should listen on distinct ports. If
you run them as services on Windows, they need to use distinct service
names. On UNIX/Linux, they also need to have distinct locations for
their respective log files, init scripts, and socket files. Whew!

Regards,
Bill K.

30/03/2006, 00h04	#4
Bill Karwin Messages: n/a Hébergeur:	Re: Getting Error Nr. 1045 during setup Greg Noss wrote: > Thanks for your input, I had another app. that installed their version of > MySQL I wasn't using their functions I removed their version adn PRESTO > MySQL worked. I would guess that your copy of MySQL wasn't running at all; it was the vendor's instance running on the same port. That would explain why your password wasn't being recognized. > Is it possible to run to different copies of MySQL on the > same machine? Yes, it should be possible to do so. More recent versions of MySQL support the concept of running "instances" of one installation. http://dev.mysql.com/doc/refman/5.0/...e-manager.html But if you want to run multiple instances of _different_ MySQL installations (for example, if you want to keep several different versions available for testing), it gets trickier. They need to be installed in different directories, and they must not touch each other's databases. They should listen on distinct ports. If you run them as services on Windows, they need to use distinct service names. On UNIX/Linux, they also need to have distinct locations for their respective log files, init scripts, and socket files. Whew! Regards, Bill K.