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

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
" h. y) L! {: u+ Z- {; AQuery OK, 0 rows affected (0.012 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
  X( @' L% {+ O9 G$ [3 ~Query OK, 0 rows affected (0.028 sec)


, J9 w2 J( |6 I  P5 m( b+ \& x

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.004 sec)
& I* ]( }7 e: k+ o& w0 A4 l: r
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)

添加root本地登录，和相应地址登录。
MariaDB [mysql]> flush privileges;
# M$ N& z# _4 ^; J1 `- p/ GQuery OK, 0 rows affected (0.001 sec)