MySQL创建用户并授权

mysql> grant all privileges on *.* to pzk@localhost identified by ‘123456‘;  # 创建用户并授权
mysql> flush privileges;                                                    # 授权完要刷新权限，否则不会马上生效 
mysql> select user,host from mysql.user;                                     # 查看用户
mysql> show grants for pzk@localhost;                                        # 查看用户权限
mysql> delete from mysql.user where user=‘pzk‘;                              # 删除用户及用户权限