How to get Zen to use a different mysql port than the default?

18 Jul 2009, 7:28 AM

#1

New Zenner

Join Date:: Jul 2009
Posts:: 2
Plugin Contributions:: 0

How to get Zen to use a different mysql port than the default?

Hello

How can we get zen cart 1.2.4 (we are going to upgrade it shortly) to use a different mysql port as we have 2 mysql versions running on our server and the one we need to connect to is not running on 3306.

Many thanks in advance

Paul

18 Jul 2009, 3:13 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: How to get Zen to use a different mysql port than the default?

In your configure.php file, add the port number to the server name.

So, if you have your database server name set to 'localhost', change it to 'localhost:5000' (assuming the port is 5000)

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

18 Jul 2009, 3:17 PM

#3

2mad

New Zenner

Join Date:: Jul 2009
Posts:: 2
Plugin Contributions:: 0

Re: How to get Zen to use a different mysql port than the default?

Hi DrByte,

Thanks for your reply

We tried that first and it did not have any effect.

:-(

Thanks

Paul

18 Jul 2009, 3:54 PM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: How to get Zen to use a different mysql port than the default?

Odd. It just worked fine for me.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.