MySQL password

[dummyagain]

As i have two part (photo gallery and forum) and they use the different login system...
now i want to implement the following functions:

when a user register for the forum, the user name and password will be copied to the photo gallery for registration, so one registration for two function parts.

However, since the password is encrypted, i would like to ask how i can copy the password to other part of the database?

Thank you

[antares686]

I assume you store the password encrypted in the database from your question. As long as you are using the same encryption method and keys then doing a straight copy thru code should do the trick. However I don't use MySQL at all right now and haven't made time to work with it but you might could use a trigger as well.

[ovidiucucu]

The users' passwords are stored in mysql.user table.
So you can select the password from the table above mentioned.
To calculate a password string from the plain text sting you can use PASSWORD MySQL function.
See MySQL Reference Manual for more details.

[ovidiucucu]

However I don't use MySQL at all right now and haven't made time to work with it but you might could use a trigger as well.

Unfortunatelly, as I know, MySQL does not (yet) support triggers.