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

admin

创建mysql用户并创建对应的访问库
/ f9 A/ j, }) I) q

MariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
7 Q; i! D6 c, j! W  t) X0 m| User        |
+-------------+
+ r' I; R* r6 H) G| mariadb.sys |
1 O  I* ]7 i) G* r$ s% f| mysql       |
% I$ l( ^' {4 L| root        |
9 i0 {) _3 I0 W+-------------+
# S3 ]: T2 Z/ m7 ~3 rows in set (0.003 sec)
4 x5 k$ f- h$ ~& Q6 ^
% B" |1 W& l' s, bMariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.003 sec)
8 Y) Z* }$ e# m7 F% y7 j
MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.001 sec)

! O/ s5 J0 V# u0 j( P8 l9 o3 qMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
% |4 A4 j& Q' C9 [Query OK, 0 rows affected (0.002 sec)
- z6 I1 _3 v; a


6 Z3 n. x7 R2 u- F- L2 {9 IMariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
$ J7 h# j# c  P1 R) zQuery OK, 0 rows affected (0.003 sec)

8 j" \& r; ]6 c  ?# d$ |MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
6 Y2 Q' @' I1 b8 A% D) \Query OK, 0 rows affected (0.001 sec)

% x1 R! s! p+ Y$ {. Q" v5 _( ~4 l

0 z5 l. V# f) O4 q# X

0 o1 `1 r$ V( s7 P: M

admin

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

admin

测试连接 带ip地址访问：
5 U" Z4 O9 \2 m1 c mysql -u victor -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
' P! o; @7 A, ?5 H+ K4 RYour MariaDB connection id is 16
9 Y/ @; u: s) W$ o5 b$ g2 tServer version: 10.5.22-MariaDB MariaDB Server

0 o: W2 k3 N. n0 _Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
/ Y5 }; H* Y6 i  s, [2 r' S
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
4 e0 _- d" t9 H# P
MariaDB [(none)]> show databases;
1 Q8 t. ^3 r# ~- o- Q7 n+--------------------+
| Database           |
/ p* f# m2 [- c1 n+--------------------+
3 n% n3 a5 m- O& L% r6 E| information_schema |
| restflask          |
2 ^! d7 P$ m$ d) \5 M% T+--------------------+
( {4 V; p! L0 m) U( a% ?1 R3 @2 rows in set (0.001 sec)

: R0 U- ~  y3 J4 e$ g7 xMariaDB [(none)]> use restflask
Database changed
, l- Y/ s: ?* l# O; ZMariaDB [restflask]> show tables;
8 _; s& a( R1 @6 EEmpty set (0.000 sec)
, [) Z( V! k  I7 H/ |6 F" @. R
MariaDB [restflask]> exit
& F! F5 v7 V1 n6 n% [" K3 aBye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
. x* G0 k0 a" K# _3 REnter password:
; p3 g0 ^+ y7 _4 Z9 [, J' wWelcome to the MariaDB monitor.  Commands end with ; or \g.
( z6 X( D# b4 f! vYour MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server
: R9 {- u; f# a6 Z9 [0 ?; U1 H
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
) p+ O7 a  X( l  j
MariaDB [(none)]> exit
; a0 _4 B  F& fBye
& F$ S. l0 a# j0 i/ x

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
  i8 [) i- _& [9 v$ rQuery OK, 0 rows affected (0.004 sec)
5 B' l" d& c# Q4 A  U, T  a5 P
MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.001 sec)
: W, K5 A2 `7 z/ h$ D8 M" i8 u
8 |+ R0 J# ?$ z7 H; Z8 P* aMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
% W3 f6 {; Z! j0 l+ _3 F7 uQuery OK, 0 rows affected (0.002 sec)

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
5 e% Z: m% S# S: w9 q" NQuery OK, 1 row affected (0.005 sec)
" k' H1 X! Y: v! G, S& Y& R, t

admin

MariaDB [(none)]> show create database testflask
    -> ;
+-----------+--------------------------------------------------------------------------------------------------+
1 g- D- j# Y' u4 B( L6 Y5 M| Database  | Create Database                                                                                  |
+-----------+--------------------------------------------------------------------------------------------------+
! x3 K: E) |% I| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
% F5 ^3 b: y6 f4 F0 V/ i5 Q+-----------+--------------------------------------------------------------------------------------------------+
- Z, W* B+ M4 A& L6 l  u! l$ \; r6 u1 row in set (0.001 sec)