mysql 远程访问数据库

--回收所有权限
REVOKE ALL PRIVILEGES,GRANT OPTION FROM "dbname"@"%";
--开启允许所有IP使用123的密码访问数据库
GRANT ALL PRIVILEGES ON dbname.* TO "dbname"@"%" IDENTIFIED BY "123" WITH GRANT OPTION;

--马上生效
FLUSH PRIVILEGES;