paultaylor01 Posted February 23, 2008 Share Posted February 23, 2008 Hi there, Does anyone know how this password encryption words? I havn't seen/used 'agabus' before...thanks. UPDATE tablename set password = encode('$pass1','agabus') where tag = '$tag' Paul Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted February 23, 2008 Share Posted February 23, 2008 Searching the manual is really the only way to find answers to such basic questions - http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode Quote Link to comment Share on other sites More sharing options...
paultaylor01 Posted February 23, 2008 Author Share Posted February 23, 2008 So the second agabus element is simply a password - thank you for your help. I thought it had some bearing on the actual encryption being used (can you guess i'm new to MySQL?!?). I assume therefore that the encrypted password would therefore be the same whatever the password was? Paul Quote Link to comment Share on other sites More sharing options...
fenway Posted February 23, 2008 Share Posted February 23, 2008 I assume therefore that the encrypted password would therefore be the same whatever the password was? How do you mean? Quote Link to comment Share on other sites More sharing options...
paultaylor01 Posted February 23, 2008 Author Share Posted February 23, 2008 I mean does the choice of password have any bearing on the encrypted value? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 24, 2008 Share Posted February 24, 2008 Doesn't it have to? I'm quite confused... there's a plaintext string, and then there's the key -- they have nothing to do with one another. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.