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

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.012 sec)
- H$ o4 x; D, B7 L$ z7 _
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.028 sec)
# j5 g. m* }7 ~0 R" b3 {- h! i
" U* g9 V$ |& ]& `& c4 b! j
* h0 K% @1 k8 Z  v3 {0 w

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
  q% n! x: m1 @/ ]% gQuery OK, 0 rows affected (0.004 sec)
7 i4 l, U0 j7 B9 u- R- u" d
7 q$ |! e( }- c; |9 t( QMariaDB [mysql]>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
+ [  o3 ?' h# LQuery OK, 0 rows affected (0.002 sec)

添加root本地登录，和相应地址登录。
MariaDB [mysql]> flush privileges;
2 ]$ N$ a* {. U6 B* i$ @' N  G) }& x5 ~Query OK, 0 rows affected (0.001 sec)