grant all on *.* to 'account'@'192.168.0.%' identified by 'acc430'; 某网段的地址能看见6 @2 d: b# k" K8 H
( b) U3 g% @. w6 b0 _
grant ALL PRIVILEGES on hive.* to "huk"@"12.168.20.%" Identified by "QgRQUswB0";/ l# J4 u; U/ A/ Q* y
mysql> show grants; 5 f; ~" w) n0 M4 m* P% U2 U+----------------------------------------------------------------------------------------------------------------------------------------+ - [/ I8 J) r6 M| Grants for root@localhost | ' Y! }8 X7 b' Z+----------------------------------------------------------------------------------------------------------------------------------------+ 6 V0 w8 }/ [5 S) M+ i& h' O3 y| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |) }5 T6 x: ^' o" b: {2 \- K% e
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | " H ?6 g/ f V% P- e: A+----------------------------------------------------------------------------------------------------------------------------------------+ 0 U! a1 Y+ T! K3 T' V- w+ u1 u2 rows in set (0.00 sec)
发表于 2018-7-6 11:21:04