复制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. |
喜欢
讨厌