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

admin

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

8 p( _  {8 T: n1 q* l7 ?
0 x9 ^- ?$ v2 Y0 |! T: K% F2 FMariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
- j- w- |& F% w, n; e; q# r# E| User        |
/ N0 i) a6 j" d' l7 j7 ^( ?4 [+-------------+
9 h9 G1 \- G( Z) p7 a| mariadb.sys |
| mysql       |
| root        |
+-------------+
3 rows in set (0.003 sec)
+ I- V# [  t, L( J, P, K
MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
- ~- b0 j- b$ h* BQuery OK, 0 rows affected (0.003 sec)
' Y9 ?( \! Y) [7 S8 Y
MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
9 }7 X  K; g8 l, s; XQuery OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
6 g" I  X' o& ?9 s4 Z) |6 aQuery OK, 0 rows affected (0.002 sec)

, s% r0 |3 }$ E! r7 E8 R* f" K
7 w% \" B# D+ ?
MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
  ~" b3 z; o; T% YQuery OK, 0 rows affected (0.003 sec)

7 f( M& L& P( m5 m" xMariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
1 `7 S0 l& K, J0 Y/ n  wQuery OK, 0 rows affected (0.001 sec)
8 j% q  P# u7 Z9 p7 m4 h5 o- }
9 Q9 h! V! d0 ]5 [

4 N3 o/ C" z" l3 c* k$ y$ D7 {+ `3 W$ Z


3 y! `& b1 ]% D; c( w  B

admin

MariaDB [(none)]> create database restflask ;
( e3 x+ ?& J2 ZQuery OK, 1 row affected (0.001 sec)
' d. t7 t! B  m+ z5 T6 c) {

admin

测试连接 带ip地址访问：
& `( z# i% ]3 H0 T* t. ? mysql -u victor -p
( f3 \" D) p6 R. D6 A2 Z' q( y3 TEnter password:
$ b/ D% \" U  S" E" o& zWelcome to the MariaDB monitor.  Commands end with ; or \g.
, G* o1 M" l8 n! e8 S7 OYour MariaDB connection id is 16
" t8 j3 Y, H6 e+ a4 O) m& i8 KServer version: 10.5.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

) _% A7 H) b# zType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
3 R7 r5 |5 H+ j$ k' x8 Y. v- ?| information_schema |
$ L3 }, n) F5 N1 n8 _2 V& b  ?0 K| restflask          |
, {7 r3 _2 T) G  i' f' m: P+--------------------+
2 rows in set (0.001 sec)

MariaDB [(none)]> use restflask
8 i5 a5 Y' P7 B- kDatabase changed
MariaDB [restflask]> show tables;
& x' B0 I! w1 |Empty set (0.000 sec)
. x8 }9 C+ N  c: O4 L( z
0 q+ {, b8 c4 P' g# s8 PMariaDB [restflask]> exit
Bye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
& l" l( o3 U4 i# d6 Q% D+ C2 vWelcome to the MariaDB monitor.  Commands end with ; or \g.
. x0 u6 m, P1 S3 RYour MariaDB connection id is 17
9 T6 o6 ~: R" G3 R5 gServer version: 10.5.22-MariaDB MariaDB Server

1 M$ J3 g* M/ V3 G' HCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
4 p- ~5 R/ b" k; ?3 D  n, `/ G
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
& Z+ L6 x8 O8 Y( w
& P' @9 g$ Z) uMariaDB [(none)]> exit
Bye

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.004 sec)

5 Q, d; t# k$ }. @7 }" _MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
8 p1 E! `3 D1 c( d5 f* SQuery OK, 0 rows affected (0.001 sec)

MariaDB [(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 */ ;
  ~0 Z, l5 o+ b9 ^& V. P3 IQuery OK, 1 row affected (0.005 sec)

admin

MariaDB [(none)]> show create database testflask
    -> ;
+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
. @7 S* n4 }5 h5 i+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
( U  d* Q! B0 V7 x' ~( ?6 Q% m+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
; C+ A/ X- o" f0 o0 B9 [1 W0 d) {