mysql/mariadb数据库创建用户以及远程登录create user

admin

mysql/mariadb创建用户并指定连接地址：
create user xxx@'localhost' identified by '******';
0 P# ^& r; M1 p2 h

create user xxx@'%' identified by '******';

. v# ?* O. s6 |; K2 f- i
给数据库权限以及地址访问：
* I7 U& ?( {; Q( Vgrant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

刷新下表空间，生效：
+ \' G* z0 }7 b. r) `: N flush privileges;
3 i8 z* l! K% z

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
5 b$ D; Y" P; r/ Z3 U) l, h5 O+----------------------------------+
& b1 r$ E% E0 n8 n" h. {  x1 e| query                            |
+----------------------------------+
6 z/ y$ M5 \) U$ n* a| User: 'root'@'%';                |
, `+ H$ j9 t. [| User: 'root'@'127.0.0.1';        |
; T# A. i; n6 @| User: 'root'@'192.168.13.130';   |
" w; [/ ?$ T- {5 {| User: 'root'@'::1';              |
9 ]2 j0 D- U$ X1 Q% D: Y, ^) g| User: 'root'@'desktop-4mm3380';  |
) x+ h# ~$ ^9 B8 o. r  l  || User: 'mariadb.sys'@'localhost'; |
| User: 'root'@'localhost';        |
+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
Query OK, 0 rows affected (0.014 sec)
+ U+ R: }2 w7 L. h) T# ?
grant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
: g' ], v+ q' _$ tQuery OK, 0 rows affected (0.003 sec)  

8 ~: a9 e  H0 C6 a, w* @& y
grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
& j2 h4 v# ^8 j, _4 ]Query OK, 0 rows affected (0.005 sec)
  C9 z1 i2 i& J! A