Robin Johnson wrote:
On Thu, 8 Aug 2002, Marc Delisle wrote:
can I assume that the password is always the third field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your query?
Because the goal is to find if the name of the password field in mysql.user is Password or password, and I wanted to avoid doing a loop for each of the fields, looking for "assword".
I am implementing the fix in user_details as is, maybe someone will come with a better solution.
Marc