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;
Reproduced please indicate the author and the source, and error a link to this page.
text link:
//xiaochun.zrlog.com/188.html