mysql用户创建授权及权限修改

用户查看：

select host,user from mysql.user;
select user,host  from mysql.user;

mysql>rename   user  feng  to   newuser; 修改用户名
mysql>drop user newuser;  删除用户
mysql> revoke  select on dmc_db.*  from  zx_root;  回收权限
mysql> show grants for zx_root;  查看用户权限
mysql> set password for zx_root =password('xxxxxx');   更改密码
mysql> update  mysql.user  set  password=password('xxxx')  where user='otheruser'
修改mysql 远程ip
mysql> grant all privileges  on DBname.* to username@'127.0.0.1' identified by "密码";
mysql> rename user 'repl'@'xx.xx.xx.xx' to 'repl'@'10.%';  修改限制的登录IP, 直接改表ip会导致授权问题