设置mysql允许外网访问

来源:互联网 发布:djvu阅读器 知乎 编辑:程序博客网 时间:2024/04/28 18:11
C:/>mysql -uroot -pEnter password: ******Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 2Server version: 5.1.22-rc-community-log MySQL Community Server (GPL)Type 'help;' or '/h' for help. Type '/c' to clear the buffer.mysql> grant all privileges on *.* to 'yourname'@'%' identified by 'youpasswd';   //密码为必填项Query OK, 0 rows affected (0.05 sec)mysql> flush privileges;Query OK, 0 rows affected (0.06 sec)重启mysql就可以外网访问了
原创粉丝点击