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)

1 D& [4 Y- a' ]( }  l, TMariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
5 S$ f: o" D4 ~; g5 s8 z! ~Query OK, 0 rows affected (0.028 sec)

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.004 sec)
/ g3 [6 g+ n: x9 ?, M
MariaDB [mysql]>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.002 sec)
3 l8 c/ k5 i' g& }+ A
. ~8 a, v/ K( I# C添加root本地登录，和相应地址登录。
- {# w4 [8 [2 \, X( eMariaDB [mysql]> flush privileges;
. s% j% {& t% w( P2 NQuery OK, 0 rows affected (0.001 sec)