mysql数据库-加密和系统函数

后端 / 2021-08-23

user

# 查询当前用户
select USER()
from dual;

database

# 查询当前数据库
select DATABASE()
from dual;

md5

# 计算 md5
select md5('luzhenfang')
from dual;

md5加密密码

create table user_test
(
    id   int,
    name varchar(10) not null default '',
    pwd  char(32)    not null default ''
);

insert into user_test
values (1, 'root', md5('123'));


select *
from user_test;


# 校验密码
select count(name)
from user_test
where name = 'root'
  and pwd = md5('123');

pasword


# 加密 mysql 自带加密
select password('@lzf123456LZF')
from dual;