Java Mysql and FTP connection

Question

My doubt is not about how to make a connection with ftp or mysql, because this is not getting.

I connect using parameters such as host, port, user and password. My source code stores this information. Thinking about the security issue, how is a connection implemented without this information remaining in the source code? I thought to create a table in a bank with the user and password and my app to consult this table, but in the connection I use as parameter the user and password of that bank.

Answer 1

I don’t know if it’s the best way, but one I’ve used and it worked: - for each system user, create a user in the database, then the user will log into the system with a database login, so there would be no user and password information stored in the system codes.

Bonus: In addition to the connection data not being in the system codes, you can also set permissions in the database per user, thus generating additional security (not excluding the permissions managed by the system).

I hope I’ve helped!