[eddyvlad]

When I use the Password function in MYSQL, it will encrypt the password rite... how do I decrypt it back?
I notice also the encryption varies, if I encrypt the same value twice.
Now I realise that I cannot backup my database since the encrypted password will be different.

I use the following for password validation :-

PHP Code:

$username = $_POST['user'];

$passwrd = $_POST['pass'];



$query = "SELECT * FROM user WHERE userid='$username' AND pass=PASSWORD('$passwrd')"; 

[nd2]

you don't.
you encript the password you want to match, such as the one coming from user input form.

$query = "SELECT * FROM user WHERE userid='$username' AND pass=PASSWORD('".addslashes($_POST['passwrd'])."')";

if you are using mysql 4.0 or less use md5() becouse it's a bit more secure, however if you have 4.1 or beater mysql has updated the password function in this release to a 41byte long hash compared to md5's 32byte long hash and the old password functions 16byte.

[eddyvlad]

Then how do I backup my database?

[NeverMind]

Originally Posted by eddyvlad

Then how do I backup my database?

if you are using phpMyAdmin, Click on Export and all tables should be packed into a file or shown on screen...

[eddyvlad]

Originally Posted by NeverMind

if you are using phpMyAdmin, Click on Export and all tables should be packed into a file or shown on screen...

The problem is, the encrypted password will stay encrypted and when I load it back at the database, the encrypted password will not be valid coz MySQL will somehow have a different encryption like an enigma machine or something.

[NeverMind]

after you have encrypted all passwords, you can't retraive the original ones !