User default password encryption problem in MySQL

Problem Description:

In MySQL, the user table is added with a default password of 123456, but the display in the database is not clear, and MySQL's default field cannot be used with a function

Workaround:

with triggers

Delimiter |
Drop trigger if exists default_user_pwd;
Create trigger default_user_pwd before insert on user
For each row
if (New.pwd is null or NEW.PWD = "or new.pwd = ' 123456 ') then
Set new.pwd = ENCODE (' 123456 ', ' password ');
End if;|

Scope of Use

You can detect whether certain values are null or empty

User default password encryption problem in MySQL