Mysql给外网IP授权访问

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'58.221.44.174' IDENTIFIED BY 'njqt123456' WITH GRANT OPTION;

root:是数据库用户名

njqt123456:是数据库密码

58.221.44.174:是要授权的外网ip

posted @ 2020-07-28 11:05  一叶青川  阅读(355)  评论(0编辑  收藏  举报