grant all on *.* to 'account'@'192.168.0.%' identified by 'acc430'; 某网段的地址能看见; V4 @! O, c: _* H* T4 u5 }
; X& S+ Y8 I, \9 ?: {* h
grant ALL PRIVILEGES on hive.* to "huk"@"12.168.20.%" Identified by "QgRQUswB0";( o5 F! V3 |& E& Z, S, f5 Y
mysql> show grants;0 i3 |5 {) e. v/ `! W3 a6 W
+----------------------------------------------------------------------------------------------------------------------------------------+; d* r% n+ C# c* S [# J7 m
| Grants for root@localhost |; W8 U( A$ a& [
+----------------------------------------------------------------------------------------------------------------------------------------+7 J, @3 N/ D, m0 z4 m: q$ T5 O6 S
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION | b6 ^0 X' t( ^8 Z# u9 m" g4 E| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |5 I S# c. n& a- K ]7 h
+----------------------------------------------------------------------------------------------------------------------------------------+' D% u' d i* A6 h0 t
2 rows in set (0.00 sec)
发表于 2018-7-6 11:21:04