One database server - different access data

How it works
1

Hello Community,

I have a database server at a provider, which I want to back up with SQL Backup and FTP.

Now I have several databases on this server, which I would like to back up in different jobs.

The problem is that if I change the user ID for one connection, it is automatically changed for the other jobs.

But logically I have a different user ID for each database.

Is it possible to assign different logins to a server connection?

Thanks.

Best Regards,
Phil

2

Hi Phil,

Yes, with SQLBackupAndFTP you can do it, please find more information on the following thread Not possible to add several MySQL-instanses to same db-server

Thank you!