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

--马上生效
FLUSH PRIVILEGES;