如何修改Mysql密码
Mysql用户密码采用md5加密函数加密(单向加密)
SELECT PASSWORD('root'); -- *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B
mysql数据库,用户配置 : user表
USE mysql;
SELECT * FROM USER;
修改密码
UPDATE USER SET PASSWORD=PASSWORD('123456') WHERE USER='root';
分配权限账户
GRANT select ,delete ON school.class TO 'user1'@'localhost' IDENTIFIED BY '123456';
select , delete -> 为user1用户分配的权限;
school.class -> 作用于 school数据库的class数据表;
IDENTIFIED BY '123456' -> 密码设置为 123456;