- 论坛徽章:
- 0
|
请问mySQL中如何给某一IP段的用户授权?
可能是你没有在@后加‘’吧!
mysql>; grant all on cx.* to ddd@'192.168.168.0/25' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql>; show grants for ddd@'192.168.168.0/25';
+-------------------------------------------------------------------------------------------------------------------+
| Grants for ddd@192.168.168.0/25 |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ddd'@'192.168.168.0/25' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |
| GRANT ALL PRIVILEGES ON `cx`.* TO 'ddd'@'192.168.168.0/25' |
+-------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec) |
|