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

admin

mysql/mariadb创建用户并指定连接地址：
. u( t8 l" a4 Acreate user xxx@'localhost' identified by '******';

5 W" Q4 f% `" I) N7 ~, [+ |
; k$ W) G0 H, Ucreate user xxx@'%' identified by '******';


给数据库权限以及地址访问：
grant ALL PRIVILEGES on *.* to "xxx"@"localhost" Identified by"xxx";

. x: u4 T  c0 J- {4 T' m刷新下表空间，生效：
flush privileges;

admin

查看user表中用户的允许访问地址的：
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+----------------------------------+
& k! R- Y5 z" u4 m: {9 A| query                            |
+----------------------------------+
, p" i' k% m  r+ a& R| User: 'root'@'%';                |
: [6 q: A. G. ^& O6 k. Q4 P6 {| User: 'root'@'127.0.0.1';        |
| User: 'root'@'192.168.13.130';   |
| User: 'root'@'::1';              |
* Y. x# D7 @- p$ }8 Z| User: 'root'@'desktop-4mm3380';  |
| User: 'mariadb.sys'@'localhost'; |
) M4 V, W# }+ v% y| User: 'root'@'localhost';        |
+----------------------------------+

admin

create user victor@'%' identified by '123456';    示例
' h3 b, b6 j# `1 mQuery OK, 0 rows affected (0.014 sec)

grant ALL PRIVILEGES on *.* to "victor"@"%" Identified by"123456";   示例
Query OK, 0 rows affected (0.003 sec)  
: S0 z7 [4 {" S9 ~" `* l+ M

grant ALL PRIVILEGES on *.* to "victor"@"localhost" Identified by"123456";
3 a4 [( E" G7 ~+ r0 H5 |Query OK, 0 rows affected (0.005 sec)