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

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
* f' s* ^7 }& @5 TQuery OK, 0 rows affected (0.012 sec)
. l- k- C- l3 {' b' g
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
6 v. l. g6 ]: b0 P# j. qQuery OK, 0 rows affected (0.028 sec)
4 @' t6 k. @% C* K/ d

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.004 sec)
; P8 w- p. O3 v5 I# N- U
MariaDB [mysql]>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
5 a, e1 t9 Z+ z$ AQuery OK, 0 rows affected (0.002 sec)

# Z% p" E: `7 u% a- ^7 h添加root本地登录，和相应地址登录。
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)