MySQL 创建用户并授权、 set命令修改用户密码 、使用mysqladmin命令修改root账户密码

1.创建用户并授权的语法：

grant  priv_type on databasename.tablename

to `user`@`host`[IDENTIFIED BY `password`]

[WITH GRANT OPTION]

grant select on myschool.view_student to

`student`@`localhost`;

2.使用set命令修改当前用户密码

set  password [FOR `username`@`host`]=

pssword("newpassword")

#修改当前用户密码

set password = password("0000");

#修改其他用户密码

set password FOR `teacher`@`localhost`=

password("8888");

3.使用mysqladmin命令修改root账户密码 

mysqladmin -u root -p password "1234"

Enter password:****