最实用最常用的mysql语句汇总

1.sql命令替换字符串方法
update giftvote_item set img1 = REPLACE(img1,'http://te1ad213fasdf.qq.zlcm8.com','http://twhfdsg.sf3rs.douxueyuan.xyz') where img1 like 'http://te1ad213fasdf.qq.zlcm8.com%';

如上，对 giftvote_item表中img1字段进行update操作，将字符串中

http://te1ad213fasdf.qq.zlcm8.com/8f86f9d55d314720a2adac37973b7b4f
替换为：

http://twhfdsg.sf3rs.douxueyuan.xyz/8f86f9d55d314720a2adac37973b7b4f

------------------------------------------------------------------------------

2.sql命令修改root密码（mysql 5.7.221）

update mysql.user set authentication_string=password('123456') where user='root' ; 
flush privileges;

3.mysql给root开启远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.2.1' IDENTIFIED BY '6c02d1f2426b2aca';  
flush privileges;