what the format password mysql in backup ?

[bartik]

Hi, i have question: what the format password mysql in user.backup ?
example:
file username_site.conf

accesshosts=0=localhost
db_collation=CATALOG_NAME=&DEFAULT_CHARACTER_SET_NAME=cp1251&DEFAULT_COLLATION_NAME=cp1251_general_ci&
solargard_site=alter_priv=Y&create_priv=Y&create_tmp_table_priv=Y&delete_priv=Y&drop_priv=Y&grant_priv=N&index_priv=Y&insert_priv=Y&lock_tables_priv=Y&passwd=*7AD5343D1A9B17BFCE3B119BF9C9A5369ACE0A32&references_priv=Y&select_priv=Y&update_priv=Y

What the format ? (*7AD5343D1A9B17BFCE3B119BF9C9A5369ACE0A32) to decipher - rd6uMg3E , please what the format, algorithm ?

Please sorry my bad english

 

[Richard G]

Is it because the user forgot his password? If yes, you can change that via a mysql command when logged in as root in mysql (or with da as da_admin) for example like this:

SET PASSWORD FOR 'tom'@'localhost' = PASSWORD('foobar');

which would set password foobar for user tom.
You have to select the correct database first ofcourse.

 

[bartik]

no, i learn password change. I need what the format ? (*7AD5343D1A9B17BFCE3B119BF9C9A5369ACE0A32) to decipher, please what the format, algorithm ?

i write php script convert.

 

[Arieh]

You can't decrypt it since it's a one way hash. However this is how it's done:

sha1(sha1('rd6uMg3E', true));