mysql root用户增加远程和本地登录

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
- B1 [2 S5 H, q! p" G' VQuery OK, 0 rows affected (0.012 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
; X8 z  w) \4 P3 i7 U' A% [0 {Query OK, 0 rows affected (0.028 sec)


! I* k, ~( t' \+ d9 @

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
% f# e! `- Z) p) _Query OK, 0 rows affected (0.004 sec)
  |% t5 h& t! {# B$ K/ Y5 \
7 g) [0 ^; H2 O& _0 Z5 @1 rMariaDB [mysql]>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
+ N: y. Z* n  f' F. A3 J* ~3 IQuery OK, 0 rows affected (0.002 sec)
6 A5 J- j4 W, \5 M
添加root本地登录，和相应地址登录。
5 G8 i$ L6 D" h" i& Q. {3 ^" u: BMariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)