my server is runing with sha1 and the account that are made by the website to the database aren't in sha1 (readable
and i tried
Perform these in MySQL command shell or phpMyAdmin SQL tab within root of selected database:
ALTER TABLE `accounts` CHANGE `password` `plainpassword` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
ALTER TABLE `accounts` ADD `password` CHAR( 40 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `name` ;
UPDATE accounts SET password=SHA1(plainpassword) ;
it change the old accounts to sha1 but when i make new account passwond not sha1
and i tried
Perform these in MySQL command shell or phpMyAdmin SQL tab within root of selected database:
ALTER TABLE `accounts` CHANGE `password` `plainpassword` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
ALTER TABLE `accounts` ADD `password` CHAR( 40 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `name` ;
UPDATE accounts SET password=SHA1(plainpassword) ;
it change the old accounts to sha1 but when i make new account passwond not sha1