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' identi

mysql用户创建授权及权限修改最先出现在Python成神之路。