替换mysql中某个字段的某些内容
UPDATE member SET nickname=REPLACE(nickname, '牛牛', '****') WHERE nickname LIKE '%牛牛%';
select Host,User,Password from user; 查看,HOST如果是%,是允许任何ip连接
grant all on *.* to admin@'%' identified by '123456' with grant option;
flush privileges