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

admin

mysql/mariadb创建用户并指定连接地址：
create user xxx@'localhost' identified by '******';
2 t9 r* a3 `% u6 Q/ Y

9 \3 X' L  U7 K  u) f+ Vcreate user xxx@'%' identified by '******';


, @8 I, G" k2 [给数据库权限以及地址访问：
7 S( l3 {3 V+ }/ j+ j1 M6 egrant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

/ {$ G( ^/ C0 w1 R9 R0 j2 V刷新下表空间，生效：
flush privileges;
! ^- z$ z% A. A$ ?' I* W. O

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
) I" v% ^2 O# B/ O7 v1 `+----------------------------------+
6 \- ?. {$ D$ s. r. a, ?9 C7 [- d* p* z| query                            |
+----------------------------------+
| User: 'root'@'%';                |
| User: 'root'@'127.0.0.1';        |
( I5 N- D1 R' k, q1 V: \; c: v: k| User: 'root'@'192.168.13.130';   |
% _, R8 V4 ~0 n# A% k+ J2 ~5 H' \| User: 'root'@'::1';              |
| User: 'root'@'desktop-4mm3380';  |
& L1 y1 i" P  B  b: M| User: 'mariadb.sys'@'localhost'; |
| User: 'root'@'localhost';        |
+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
Query OK, 0 rows affected (0.014 sec)
, I( T4 r: }" j
! l+ ^% _1 X6 ^9 igrant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
8 Z1 C7 M; L0 d6 q9 Z  y# y# bQuery OK, 0 rows affected (0.003 sec)  

7 |$ i9 P* N& J" w4 g1 f, A$ g
grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
! C8 a4 H4 {' t4 MQuery OK, 0 rows affected (0.005 sec)
& l+ {  Y; W1 s  k1 ]