472,145 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Multiple MySQL installs - 2 applications [help modify my.cnf/my.ini]

Here's my installation issue:

I have two versions of an application (I'll refer to it as "ABC"). One
version of the tool requires MySQL 4.1.x and the other requires MySQL
5.0.x, which is not an issue as I can install each of these on their
own port; 3346 and 3356 respectively.

The complex part of this problem is that ABC's executable is ABC in
both versions of the tool. In the past I could easily define ABC in the
my.ini/my.cnf by calling the client with [ABC].

Each version of ABC resides in it's own directory:
C:\Program Files\ABC1\
C:\Program Files\ABC2\

The client connection process is limited to an installation application
that asks for the following:

Server:
Username:
Password:
Database:

How can I get both of these versions to connect to their respective
MySQL installation.

Thank you in advanced!

-L

Jul 5 '06 #1
3 2080
Sorry my first email went personal instead of the group!!!

Maybe try something like this:

server:port#

For example:

10.10.10.1:3356

Or
If you're using dsn names:

Myserver.com:3356

Hope this helps
On 7/5/06 08:47, in article
11*********************@75g2000cwc.googlegroups.co m, "kr******@gmail.com"
<kr******@gmail.comwrote:
Here's my installation issue:

I have two versions of an application (I'll refer to it as "ABC"). One
version of the tool requires MySQL 4.1.x and the other requires MySQL
5.0.x, which is not an issue as I can install each of these on their
own port; 3346 and 3356 respectively.

The complex part of this problem is that ABC's executable is ABC in
both versions of the tool. In the past I could easily define ABC in the
my.ini/my.cnf by calling the client with [ABC].

Each version of ABC resides in it's own directory:
C:\Program Files\ABC1\
C:\Program Files\ABC2\

The client connection process is limited to an installation application
that asks for the following:

Server:
Username:
Password:
Database:

How can I get both of these versions to connect to their respective
MySQL installation.

Thank you in advanced!

-L
Jul 5 '06 #2
Unfortunately this didn't work..

Any other ideas.

I have a feeling that modifying the my.ini/.cnf may be required.

Thank you,

-L

Shawn Hamzee wrote:
Sorry my first email went personal instead of the group!!!

Maybe try something like this:

server:port#

For example:

10.10.10.1:3356

Or
If you're using dsn names:

Myserver.com:3356

Hope this helps
On 7/5/06 08:47, in article
11*********************@75g2000cwc.googlegroups.co m, "kr******@gmail.com"
<kr******@gmail.comwrote:
Here's my installation issue:

I have two versions of an application (I'll refer to it as "ABC"). One
version of the tool requires MySQL 4.1.x and the other requires MySQL
5.0.x, which is not an issue as I can install each of these on their
own port; 3346 and 3356 respectively.

The complex part of this problem is that ABC's executable is ABC in
both versions of the tool. In the past I could easily define ABC in the
my.ini/my.cnf by calling the client with [ABC].

Each version of ABC resides in it's own directory:
C:\Program Files\ABC1\
C:\Program Files\ABC2\

The client connection process is limited to an installation application
that asks for the following:

Server:
Username:
Password:
Database:

How can I get both of these versions to connect to their respective
MySQL installation.

Thank you in advanced!

-L
Jul 5 '06 #3
Potentially, you can run a virtual machine on your server and run one of the
mysql instances on that virtual machine with its own ip address. You can
even run both mysql servers on the same port because ip addresses are
different!

Am not not sure how you can change the conf file to accommodate something
like this??!!

-s
On 7/5/06 19:55, in article
11**********************@m73g2000cwd.googlegroups. com, "kr******@gmail.com"
<kr******@gmail.comwrote:
Unfortunately this didn't work..

Any other ideas.

I have a feeling that modifying the my.ini/.cnf may be required.

Thank you,

-L

Shawn Hamzee wrote:
>Sorry my first email went personal instead of the group!!!

Maybe try something like this:

server:port#

For example:

10.10.10.1:3356

Or
If you're using dsn names:

Myserver.com:3356

Hope this helps
On 7/5/06 08:47, in article
11*********************@75g2000cwc.googlegroups.co m, "kr******@gmail.com"
<kr******@gmail.comwrote:
>>Here's my installation issue:

I have two versions of an application (I'll refer to it as "ABC"). One
version of the tool requires MySQL 4.1.x and the other requires MySQL
5.0.x, which is not an issue as I can install each of these on their
own port; 3346 and 3356 respectively.

The complex part of this problem is that ABC's executable is ABC in
both versions of the tool. In the past I could easily define ABC in the
my.ini/my.cnf by calling the client with [ABC].

Each version of ABC resides in it's own directory:
C:\Program Files\ABC1\
C:\Program Files\ABC2\

The client connection process is limited to an installation application
that asks for the following:

Server:
Username:
Password:
Database:

How can I get both of these versions to connect to their respective
MySQL installation.

Thank you in advanced!

-L
Jul 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by David Scribler | last post: by
3 posts views Thread by Lauren Quantrell | last post: by
3 posts views Thread by genenamg | last post: by
8 posts views Thread by eholz1 | last post: by
8 posts views Thread by Stevebo | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.