mysql数据库创建用户赋予权限

-- 创建用户
create user 'username'@'%' IDENTIFIED by 'password';

-- 给用户权限
GRANT ALL PRIVILEGES on weather.* to 'weather'@'%';