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

admin

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

. a4 n# [4 ~; d5 H$ t
MariaDB [(none)]>  select distinct(User) from mysql.user;
. Z+ P) H' A6 @/ F1 G+-------------+
| User        |
7 g8 z. f7 |2 ?" ^" H+-------------+
| mariadb.sys |
( ~7 r: {4 M( U2 e/ _' L; D0 v: J| mysql       |
* g" u- r* B! q! D. R( {7 u0 f. J| root        |
+-------------+
3 rows in set (0.003 sec)

MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
3 \8 j( c2 c6 n' |3 {3 a9 q0 PQuery OK, 0 rows affected (0.003 sec)

+ }/ r) X5 `( oMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
; }% Z5 y1 ~- s/ S+ @- c3 S( ZQuery OK, 0 rows affected (0.001 sec)
( V0 M* I- y7 F
MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
) _; j  a8 |' [- o8 eQuery OK, 0 rows affected (0.002 sec)
, h  T# `) z* j3 I" y/ p' U  U
2 B6 d  p- i+ r2 [4 M/ x

( @9 u9 `+ {- Q9 dMariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
: W5 z+ ^9 g# N7 ?, HQuery OK, 0 rows affected (0.003 sec)

2 m( [4 o& I, q) wMariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
9 E6 B$ w& r' }/ bQuery OK, 0 rows affected (0.001 sec)
6 ~& c' r  c; G4 _2 t- P. v  n. b4 Y
8 q9 U" c# g4 D2 j* @+ k

) O& I$ p$ M" l$ |& P

7 U4 z* g; d' F

admin

MariaDB [(none)]> create database restflask ;
Query OK, 1 row affected (0.001 sec)

admin

测试连接 带ip地址访问：
. p  ]/ p$ R; n* o* h mysql -u victor -p
8 t5 \* L* f6 e% u  B) j; \; x. HEnter password:
8 {1 B) y2 ?% g( q1 J7 ^  [7 SWelcome to the MariaDB monitor.  Commands end with ; or \g.
6 y8 F2 u3 m6 @5 `. N- s" `, s% EYour MariaDB connection id is 16
$ P" n1 |; i# {4 i3 j, ]4 K2 Z' N2 SServer version: 10.5.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
, t5 s- i8 |, i7 `" z! b1 M! J
& {. r1 ~; }  }6 N6 qType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
, V- o% S! F% x: `: `6 O
MariaDB [(none)]> show databases;
7 P* w& E+ v, S$ x, y* U7 Z+--------------------+
| Database           |
) w$ ^' ^1 m' ^& \* I+--------------------+
| information_schema |
* g/ b2 i; d3 k5 @4 J| restflask          |
6 o6 [4 _- }6 v, t' o4 ~& p7 n+--------------------+
2 rows in set (0.001 sec)
  h: e/ V$ l7 @  Y3 Y3 a$ o
MariaDB [(none)]> use restflask
' k' D( K5 Y# dDatabase changed
MariaDB [restflask]> show tables;
+ Z8 W" b3 ?4 WEmpty set (0.000 sec)

MariaDB [restflask]> exit
Bye
9 h" b, S& B, B! u- W- ?8 N[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
/ y& R% p% v$ \) U! EWelcome to the MariaDB monitor.  Commands end with ; or \g.
0 ~0 q! k1 y7 w& Z8 J& DYour MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
9 I6 c0 j3 R1 [
8 I! \3 ?5 q- r5 J9 aType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

# P8 {; i! A6 {( IMariaDB [(none)]> exit
! U0 v6 E" Q% Z3 K3 tBye

admin

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

MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
7 n: O4 w& S& s6 {7 wQuery OK, 0 rows affected (0.001 sec)
$ }  o! r) E6 e
  M# J- Z0 M8 K* t; e: s2 o$ M8 Q! @4 b# KMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
( a8 r; E: ^. `( g% f1 q# t. L* w* rQuery OK, 0 rows affected (0.002 sec)

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
$ A6 H5 K% |8 N7 {( R  ?* zQuery OK, 1 row affected (0.005 sec)
% r5 S+ E& v7 \

admin

MariaDB [(none)]> show create database testflask
    -> ;
+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
, z) A( G1 x9 k. @$ U$ h* y3 U1 E" K+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
7 k5 v3 G* `' O- O7 g: M+-----------+--------------------------------------------------------------------------------------------------+
6 s7 m% U1 V: E: Z4 k1 row in set (0.001 sec)
  |# ~+ W/ F; `- a& b8 h8 s% ~