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

admin

mysql/mariadb创建用户并指定连接地址：
* h2 U. C+ y  tcreate user xxx@'localhost' identified by '******';


; Z2 E' o' p6 t* \3 I8 O( Y+ A! E! Bcreate user xxx@'%' identified by '******';


给数据库权限以及地址访问：
, ?8 H' S! w+ [" Lgrant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

刷新下表空间，生效：
flush privileges;
0 q- m4 X9 I4 z0 [7 T

admin

查看user表中用户的允许访问地址的：
7 V3 L$ G" X7 Y& n5 SSELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
8 s- T: w8 S2 ~5 ?+----------------------------------+
) A. k; j* N9 M+ v) f7 i| query                            |
+----------------------------------+
| User: 'root'@'%';                |
| User: 'root'@'127.0.0.1';        |
| User: 'root'@'192.168.13.130';   |
) F% B9 e' x; S* n$ T5 f& m| User: 'root'@'::1';              |
' v& i& ^3 [) d( h9 H  ~| User: 'root'@'desktop-4mm3380';  |
: H' V6 g4 Y) U! c0 p! e7 G| User: 'mariadb.sys'@'localhost'; |
; i$ e# }5 [0 c1 c; N7 Q! J| User: 'root'@'localhost';        |
8 L4 K1 `( k: S1 n: K+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
Query OK, 0 rows affected (0.014 sec)
( D8 ?$ |! I" V. d* C
grant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
* m# M- y5 g  w! `$ V1 S) m5 mQuery OK, 0 rows affected (0.003 sec)  
9 i" ^1 B$ h( w& z; ?3 o# H
5 c+ g9 T8 b& g* M6 R
$ W8 [/ U  {' P6 Tgrant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
Query OK, 0 rows affected (0.005 sec)
: \2 q! O% d+ m