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

admin

mysql/mariadb创建用户并指定连接地址：
, W* g8 D( [0 k8 lcreate user xxx@'localhost' identified by '******';


create user xxx@'%' identified by '******';
5 ?! l$ |  b9 ?) F% C7 L
: y. P! g; Z! P3 A6 R! \( [
给数据库权限以及地址访问：
grant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

) z$ B. c- Z4 I9 a刷新下表空间，生效：
: ~  @. f; T" a flush privileges;

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
. i1 N! n- e7 t2 m+----------------------------------+
| query                            |
+----------------------------------+
| User: 'root'@'%';                |
4 z5 w+ \$ a% V6 w1 r% s| User: 'root'@'127.0.0.1';        |
| User: 'root'@'192.168.13.130';   |
1 Z" e2 o6 L5 R6 x) C| User: 'root'@'::1';              |
. }3 k7 E8 u5 u( y| User: 'root'@'desktop-4mm3380';  |
( [* h# k# G9 a4 e  z| User: 'mariadb.sys'@'localhost'; |
: H. v/ C8 j# ^  ]| User: 'root'@'localhost';        |
+----------------------------------+

admin

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

- c1 \# U+ i( f, Z; o/ X7 r: fgrant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
Query OK, 0 rows affected (0.003 sec)  

* [8 M, S. c, N8 [$ [* C- n
grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
Query OK, 0 rows affected (0.005 sec)
' E5 L2 P0 @! x