MySQL修改账号的IP限制条件

复制mysql> GRANTSELECTON MyDB.* TO LimitIP@192.168.% IDENTIFIED BYLimitIP;  Query OK,修限制 0 rows affected (0.01 sec)  mysql> GRANTINSERT ,UPDATE,DELETEON MyDB.kkk TO LimitIP@192.168.%;  Query OK, 0 rows affected (0.00 sec)  mysql>   mysql> flush privileges;  Query OK, 0 rows affected (0.00 sec)  mysql>   mysql> show grants for LimitIP@192.168.%;  +----------------------------------------------------------------------------------------------------------------+ | Grants for LimitIP@192.168.%                                                                                   |  +----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TOLimitIP@192.168.% IDENTIFIED BYPASSWORD*72DDE03E02CC55A9478A82F3F4EBE7F639249DEC |  | GRANTSELECTON `MyDB`.* TOLimitIP@192.168.%                                                              |  | GRANTINSERT, UPDATE, DELETEON `MyDB`.`kkk` TOLimitIP@192.168.%                                          |  +----------------------------------------------------------------------------------------------------------------+ 3 rowsinset (0.00 sec)  mysql>  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.

本文地址：http://www.bzuk.cn/html/166a8699747.html