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

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
: c$ J8 f; Q. e% tQuery OK, 0 rows affected (0.012 sec)

. N' y' @1 h  d+ b% P4 {MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
9 V: u( C- e3 f  P# sQuery OK, 0 rows affected (0.028 sec)
* o% E1 B* a- B4 }* N, z/ }, J
  d9 j3 Z$ w! N$ T9 C: Q6 H  C0 _- _+ R

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
7 {3 j) A; O. }" `Query OK, 0 rows affected (0.004 sec)

0 x) D/ ]# m, vMariaDB [mysql]>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
8 M, C. `1 w5 l. ~  M$ H/ W: GQuery OK, 0 rows affected (0.002 sec)
: J0 H" I7 o: a" Z  Q; q" {
添加root本地登录，和相应地址登录。
" Q, q7 ?/ Y: n: r, VMariaDB [mysql]> flush privileges;
& n; l. N: G0 z8 v; j- qQuery OK, 0 rows affected (0.001 sec)