Not possible to add several MySQL-instanses to same db-server


#1

Hello,

I’m running version 12.2.1 and the issue is that it is not possible to add several MySQL instances to the same MySQL server. As for example:

New backup job 1:
Hostname: testdb
MySQL port: 3321
Username: test
Password: test

New backup job 2:
Hostname: testdb
MySQL port: 3322
Username: test
Password: test

Both backup jobs will get the port of the last saved job,that is the issue, i.e. both job 1 and 2 will get the same portnumber in this case 3322 if backup job 2 was after backup job 1.

Best regards,
Magnus


#2

Hi Magnus,

If you need to connect to your MySQL Server to backup databases with different credentials or with different ports then please specify Server name like:

localhost /* any description of the connection */
localhost /* connection for the second user */
localhost /* any other connection */

and use different credentials or ports.

If you have any additional questions, please feel free to contact us. Connect%20to%20MySQL%20Server


#3

Thanks a lot Alexander!
It works fine now!

Best regards,
Magnus


#4

Hi Magnus,

Good news! Please feel free to contact us on any issues or concerns.


#5

Hi,

I’ve got the same question, but for PostgreSQL !

And it doesn’t seem to allow the “localhost /* any description of the connection /” syntax.

Regard,
Lionel


#6

Hi Lionel,

Please make sure you have specified your server’s name like

localhost /* any description of the connection */

where:

localhost - is your server’s name
/* any description of the connection */ - any description to identify your server


#7

Hi Alexander,

Your’re right, I did an error in the syntax.
It’s ok, thank you.


#8

Good news! Thanks for the reply.

Please feel free to contact us on any issues or concerns.