Thank you Phill W.

Yes I’m stuck with PhpMyAdmin.

I will take a look at encrypting the passwords on the DB and decrypting at the application, however there is very little risk exposing the username and passwords hence the lack of willingness to invest in changes.

The username and passwords are simply used to allow the user access to the local application to avoid unauthorised users sending print requests. Once the user has logged in the print request is generated and then sent to the print room via email, then there is a confirmation process via email before any print work is completed, as a result any unauthorised request would be picked up during the confirmation process.

Regards,
Jason