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

admin

mysql/mariadb创建用户并指定连接地址：
create user xxx@'localhost' identified by '******';
; b8 t& P' s. l9 I9 g4 p5 x1 V' v" v

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

& f3 u8 ~2 t8 H# o) |! v1 p/ K
8 s5 o4 F) t5 h( y9 x给数据库权限以及地址访问：
" O- S: _4 I6 \( Hgrant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

2 W; s: J# X$ p7 w* B4 u2 c刷新下表空间，生效：
) e/ s8 S- d: g1 _; D( j flush privileges;

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
8 B4 X1 h& K* q3 S3 C: T+----------------------------------+
# s6 ]2 @4 \. H8 }: U' ^, x2 S: y4 Z| query                            |
# ]$ B- v! ]2 n- M  u9 O" o4 b+----------------------------------+
| User: 'root'@'%';                |
/ m. D0 n6 |& i| User: 'root'@'127.0.0.1';        |
; v* R4 q4 F* e  b% J| User: 'root'@'192.168.13.130';   |
6 n/ B! d5 `3 c0 w& y0 k, @| User: 'root'@'::1';              |
' w1 C. s) b* Y  s- f* k7 i1 d% o| User: 'root'@'desktop-4mm3380';  |
| User: 'mariadb.sys'@'localhost'; |
& ~: ^+ R6 C! @8 q; O$ m9 z| User: 'root'@'localhost';        |
+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
3 b) i& y& S9 Z# O3 wQuery OK, 0 rows affected (0.014 sec)
: `/ C2 n$ N8 E0 W2 U0 p2 U
4 j0 ]# N, _2 y4 o, |, \grant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
Query OK, 0 rows affected (0.003 sec)  
2 N# D- c3 _, D  d6 l$ L2 `
* L" r. p  e3 Q, J2 r! q
grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
. q  [( ]) d1 PQuery OK, 0 rows affected (0.005 sec)
; _  y5 a# Q/ T; v* ?