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

admin

mysql/mariadb创建用户并指定连接地址：
( l/ y9 m+ X! c3 t+ Zcreate user xxx@'localhost' identified by '******';
0 h: O+ y( e- Q
; _+ u3 N) X& o0 ^; s
create user xxx@'%' identified by '******';
) y7 o/ Y8 i4 X3 H7 d

7 w) Q( r- y3 k+ R! y( x# y& E给数据库权限以及地址访问：
grant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";
% L! F& Z3 k7 C+ p6 I9 I3 r, ^
8 X& u) d0 p2 e$ ?2 v5 J0 X2 t. w* k刷新下表空间，生效：
flush privileges;

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+----------------------------------+
2 X3 Y9 `  l. X9 |6 i* L| query                            |
. {+ w- P" o' g( W: p% ~. [+----------------------------------+
| User: 'root'@'%';                |
  h$ W& T5 z% H0 Y4 d, w| User: 'root'@'127.0.0.1';        |
| User: 'root'@'192.168.13.130';   |
% T9 D3 U( K, M2 H) l* {1 L- u| User: 'root'@'::1';              |
) a1 X# a! c9 k: t* U| User: 'root'@'desktop-4mm3380';  |
  X' u5 v% i5 h4 G1 I| User: 'mariadb.sys'@'localhost'; |
| User: 'root'@'localhost';        |
+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
Query OK, 0 rows affected (0.014 sec)

8 W/ f3 Y/ u$ m4 O1 e" J) Pgrant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
" G2 ~2 s# M+ q7 yQuery OK, 0 rows affected (0.003 sec)  

( s) `( _7 q2 i# k1 S! D! v
# i2 H1 M% N* h) @8 e* _grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
Query OK, 0 rows affected (0.005 sec)
  d: Y7 Q) n4 z0 d9 ?$ H) U