创建mysql用户并创建对应的访问库

admin

创建mysql用户并创建对应的访问库
+ K6 a8 u4 I4 Z6 f( [+ T; J

MariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
| User        |
+-------------+
' T  W* _! d# K6 O: ?| mariadb.sys |
7 x, G0 ?( j" T- u- [# H| mysql       |
1 E* I: b) k% [' u| root        |
  E; G- f( I6 F# D( g2 e8 C+-------------+
3 rows in set (0.003 sec)
9 u/ ~% Y; h: V  P9 k. h4 S
3 x, @+ S9 U5 v# ]9 N' ^MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.003 sec)
1 K% L) S3 o$ A2 H1 \
" _0 }( R8 V3 `. X8 D& XMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
7 X4 Q1 I9 U) G) a7 bQuery OK, 0 rows affected (0.001 sec)
; ^  t- S3 Y" I- E, y
' ^& H! s! E7 f' BMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
Query OK, 0 rows affected (0.002 sec)

. g! K4 o: }4 ^  T2 q$ H

MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
! Z% [/ G% }! x! ]Query OK, 0 rows affected (0.003 sec)

9 T1 R8 j$ ?$ G& V- r4 _MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
! l! F# e: W) c9 ^2 x0 Q( @& J* sQuery OK, 0 rows affected (0.001 sec)
, R. B; a$ n2 H; r. I
$ G$ m" e, [  G7 ?
4 I8 V  m" d; h& T. F3 S
  P& _; c1 P, ?: J0 n  }; q
0 l! g& e- N3 Q" W
9 }5 }0 n( m/ j7 `8 i- E/ y

admin

MariaDB [(none)]> create database restflask ;
. g6 v' j7 Y& J; Z5 ?& ~2 eQuery OK, 1 row affected (0.001 sec)
4 d" F% h! i% L8 e) U5 w& s$ ^

admin

测试连接 带ip地址访问：
+ u0 i1 L% s  u mysql -u victor -p
1 G# J3 d' q, HEnter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
& G' N( u5 a1 p3 oYour MariaDB connection id is 16
0 g5 O& E/ B3 bServer version: 10.5.22-MariaDB MariaDB Server

; O% z1 N7 z% c0 y, M$ pCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
" Q2 T+ t. Z1 R( R! H$ p- T! u
2 }% y# }" i: n, E7 D: ~! T$ YType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
1 _& N7 a& v! ?8 m| Database           |
+--------------------+
2 {" A6 C" ~! Q6 t| information_schema |
& D+ i( J4 E0 l/ f| restflask          |
: W& B6 s: Y5 w/ o+--------------------+
2 `& T7 x( A, C) A7 k$ `5 f% Y2 rows in set (0.001 sec)
; B) @$ P- N- j
MariaDB [(none)]> use restflask
Database changed
$ D* B. m7 I: W+ j" B# F0 O$ d; PMariaDB [restflask]> show tables;
' t4 E& d7 `" O7 x* iEmpty set (0.000 sec)
3 Z6 d! {, r$ t
0 ?/ Y; _) D1 s0 q( P6 |MariaDB [restflask]> exit
Bye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
3 T# @& p/ v4 HEnter password:
9 R: m; i3 C  ]2 d' E5 U/ OWelcome to the MariaDB monitor.  Commands end with ; or \g.
" @) Z$ ]3 q2 T& x( bYour MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server
0 M6 y4 n- |) m5 @
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

' n( B8 a+ S  o4 l6 D, T; Z4 t/ IMariaDB [(none)]> exit
# Q+ v+ x2 R/ X$ w% a9 tBye

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
% H  M$ L: \& P2 n9 JQuery OK, 0 rows affected (0.004 sec)
, Y) Y, g/ Y+ Z: g: f( v5 A, @
0 Z8 {+ Z* E9 e+ m! E+ U& ?/ m! k/ dMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
( h7 O2 }1 B# w+ Q1 u+ U, O3 uQuery OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
% J% S- M: P. H5 \5 u) a2 tQuery OK, 0 rows affected (0.002 sec)
' E& z, |3 Q% t: `

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
Query OK, 1 row affected (0.005 sec)
7 d- }, ^; j% U. b

admin

MariaDB [(none)]> show create database testflask
& u6 C" t* ?" A$ T    -> ;
" U5 b; p2 H9 ?9 w3 c+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
) A  `! W+ T) u, d; S) K$ T$ ]+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
9 h) W8 [& @' I4 W6 \: f+-----------+--------------------------------------------------------------------------------------------------+
* z, U. p# ?! Q1 row in set (0.001 sec)
: M" }3 e, _% d$ k0 k7 Z; a2 V, u