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

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
( J  h; U7 I9 }3 t  `Query OK, 0 rows affected (0.012 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.028 sec)


3 z. {' F# d" w5 y9 }6 s8 t; M! J

admin

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
  x. Y. A1 X0 SQuery OK, 0 rows affected (0.004 sec)

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)
, L- Q; s) ]1 R9 |) \" b
" N* ^$ ]& Y- ?7 k( [添加root本地登录，和相应地址登录。
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)