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

admin

mysql/mariadb创建用户并指定连接地址：
create user xxx@'localhost' identified by '******';
) o* {* E0 U4 H: H9 I0 E

* j. @( m% p" g+ tcreate user xxx@'%' identified by '******';
  c( M! m" X3 W9 V+ t# Z

9 ^1 Q7 p+ _. ]( i' U给数据库权限以及地址访问：
grant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

刷新下表空间，生效：
flush privileges;
0 n, X% d0 O; G' N+ h! E

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
6 g# J9 `7 p" e+----------------------------------+
; `6 S9 w+ i2 m- `7 V7 L7 B| query                            |
+----------------------------------+
0 l. U/ @! Q: M  h6 H% }| User: 'root'@'%';                |
| User: 'root'@'127.0.0.1';        |
4 G& P. J' {  _8 H+ e% O: p% Q| User: 'root'@'192.168.13.130';   |
| User: 'root'@'::1';              |
| User: 'root'@'desktop-4mm3380';  |
; E' N7 Q- v4 F" s) ]) y1 e# R| User: 'mariadb.sys'@'localhost'; |
6 j! c/ |! X# W9 I5 m5 F| User: 'root'@'localhost';        |
5 e* ^/ v4 s$ b$ D' J5 z0 `9 _, n+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
Query OK, 0 rows affected (0.014 sec)
2 ?( }' ]: [& z0 t- ~
* G: U+ G- [" A2 {# W  L. W' U" qgrant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
Query OK, 0 rows affected (0.003 sec)  

' r/ w/ o: S. F2 k
grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
- ~0 ~! F& d7 V8 R" JQuery OK, 0 rows affected (0.005 sec)
5 G- P& _; k, ^, y8 ^* q