用户查看:
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会导致授权问题