Jump to content

auto encrypt user account password directly in mysql manager


Recommended Posts

Hi guys!

use a mysql editor (HeidSQL or NavCat) and select your ACCOUNT.ACCOUNT table to crate a trigger script.

Run this query: 

CREATE TRIGGER `account_before_update` BEFORE UPDATE ON `account` FOR EACH ROW BEGIN
/* TRIGGER WRITED BY [ADM]Arkatuz (Meleb.Net) */
if (LEFT(NEW.password,1)<>'*') then
SET NEW.password = PASSWORD(NEW.password);
END if;
END

Now, your can update PASSWORD column directly of the Mysql Editor. Eg.: your put 'mypasswd123' and the trigger crated go crypt to '*DD33176027C486CECB9B6F770756A1C115A1F659'. This is good to help administer your server without external applications to generate passwords. 

good lock! ^^

 

  • Good 2
  • Love 1
Link to comment
Share on other sites

  • Management
Link to comment
Share on other sites

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.