select version() //查看msql版本
//创建用户名zidongzhan,密码zidongzhan,只读权限的用户,可任意ip访问(%标识任意ip,localhost只能本机)
GRANT Select ON climate.* TO zidongzhan@'%' IDENTIFIED BY "zidongzhan";
//刷新权限
flush privileges;
select version() //查看msql版本
//创建用户名zidongzhan,密码zidongzhan,只读权限的用户,可任意ip访问(%标识任意ip,localhost只能本机)
GRANT Select ON climate.* TO zidongzhan@'%' IDENTIFIED BY "zidongzhan";
//刷新权限
flush privileges;