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

admin

创建mysql用户并创建对应的访问库
  ~6 j6 a5 P( O# |/ `* {0 o
  y0 o7 M  S  E$ E, A: v- E
* s# p4 B- B/ X; IMariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
, H; W: x3 ?- f- l| User        |
+-------------+
  [' I8 W, K  @" N* R! V| mariadb.sys |
4 d3 ^) }3 y& j1 t8 x| mysql       |
| root        |
+-------------+
) L* R5 t( N  T7 m6 x+ ~& z3 V3 rows in set (0.003 sec)
  J' ^" j* M( r' E7 B1 d$ G
MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.003 sec)

* _! w' G/ Z$ lMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
! n1 K2 e( h) r% X- V- OQuery OK, 0 rows affected (0.001 sec)
# f% \2 D" {# Z* \
MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
. B) q& t' f8 L- R- w6 l! B. Z& F5 vQuery OK, 0 rows affected (0.002 sec)

; k& F+ \, R& w2 s& ~
7 m7 Y4 A2 Z! h4 W
3 {8 B3 K, C4 bMariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
8 `& _) x% ~- I; fQuery OK, 0 rows affected (0.003 sec)
  q8 x+ a# D( t% {& O
MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
) d1 v9 m( y, m( o" h7 sQuery OK, 0 rows affected (0.001 sec)
& K. v- {! B" ?) E

4 q* Q/ [) {/ Y4 F( ?/ s- q

/ N5 ]% O8 B+ _
3 l0 E. t( ]0 z: X+ }

admin

MariaDB [(none)]> create database restflask ;
; v8 K" J: c6 F9 N. o+ ]Query OK, 1 row affected (0.001 sec)

admin

测试连接 带ip地址访问：
' D2 c' L! |2 K: | mysql -u victor -p
Enter password:
% v. P! ?( C. s, w$ CWelcome to the MariaDB monitor.  Commands end with ; or \g.
: Z/ b2 O1 M! d  @# Z4 X6 {Your MariaDB connection id is 16
Server version: 10.5.22-MariaDB MariaDB Server

* m& ^9 W0 P3 xCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
0 G, H# W* f6 v4 B5 a: ]$ t  d& v
0 R* o+ F  g$ qType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
* {1 S6 L  v2 M% `5 j# o" J9 ?+--------------------+
| Database           |
+--------------------+
9 K9 G( ]$ O3 ^' w1 |3 ?| information_schema |
| restflask          |
+--------------------+
9 V2 z" s9 R7 O# l1 C) _2 rows in set (0.001 sec)
1 i' s8 t$ t& [( M& E
9 ]- A4 E$ G2 d; J% g/ XMariaDB [(none)]> use restflask
+ s5 U7 ~" t8 [( |! p* MDatabase changed
8 @# E$ k3 g! \7 m3 i$ |2 QMariaDB [restflask]> show tables;
Empty set (0.000 sec)

MariaDB [restflask]> exit
! r4 @. w% x, ]) J6 jBye
5 W- j5 z4 Z) u9 I9 t* s$ r( d/ }; K[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
! `" O2 y1 B( k* B/ W+ PWelcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
0 V; T. I# [* L8 }/ p8 a* |Server version: 10.5.22-MariaDB MariaDB Server
" e3 _! N. i$ U; d* o
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
' w# w/ P( b, i7 ?5 e8 v/ s
. A7 `- w; s. y  A" HType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
2 D  a" `( c, o; E, n
MariaDB [(none)]> exit
! M6 W# |: L+ P$ SBye

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.004 sec)
2 M7 K! I6 t! P( t" z+ Q
1 X3 |% x; D: @0 c9 H9 PMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
0 h) }" U8 {, u0 O9 R3 XQuery OK, 0 rows affected (0.001 sec)
) d+ _: o2 i/ d! n& k3 O% S
$ c" ^0 B, W8 o4 c/ a$ l8 r: VMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.002 sec)

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
$ e$ @. e0 ]" K, h- }. b2 kQuery OK, 1 row affected (0.005 sec)

admin

MariaDB [(none)]> show create database testflask
4 X7 Q$ x$ m) K$ i  o, t    -> ;
- E" c- r6 F: P% @& h+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
+ `2 u- I1 e$ ~+ b+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)