1.MySQL创建用户和授权

1.1创建用户

create user 'develop'@'%' identified by 'e16078588fee866d';
所有IP都可登录。

1.2授权该用户所有的数据库权限

GRANT ALL PRIVILEGES ON  *.* TO develop@'%' IDENTIFIED BY 'e16078588fee866d';

1.3授权该用户某个数据库的权限

grant all privileges on `testdb`.* to 'test'@'localhost' identified by '123456';