mysql 新建远程用户

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 所有数据库所有表

GRANT ALL PRIVILEGES ON xinchuanbo.* TO 'zzs'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 开通用户：zzs 密码：123456 数据库 xinchuanbo (远程操作)
GRANT ALL PRIVILEGES ON xinchuanbo.* TO 'zzs'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION; (本机操作) 两个同时需要

GRANT ALL PRIVILEGES ON ditui.* TO 'ditui'@'192.168.44.82' IDENTIFIED BY 'ditui888' WITH GRANT OPTION;