MySQL在开发中常用的一些技巧,可以起到事半功倍的效果!
允许MySQL远程访问:
```
grant all privileges on *.* to 'root'@'192.168.1.%' identified by '123456' with grant option;
flush privileges;
```
*注:在设置允许远程访问需要先关闭防火墙*
### > ***MySQL底层运行机制***
![](https://box.kancloud.cn/85eadba924590a14fc772c58dfe70027_851x549.png)