Re: Copy password from one user to another

[Noel Abela]

Thank you for your response.

I actually solved it by using the same sql but replacing the column name password with authentication_string.

As to why we need this, I will attempt to explain it as best as I can.
Our client provides a payroll service to his clients using our payroll application and employs a number of users.
So the payroll application creates many companies (mysql databases). Each company has a list of users which can vary between companies but in reality it is practically the same list of users repeated in all companies because all the users can work on all the companies. When a new company needs to be created we have this feature to easily replicate all the users from an existing company to the new one. Otherwise we would have to create the users one by one and have them enter their password.