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

admin

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

9 t8 d& ~. t- J5 G; S/ _) u
MariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
9 z! z# \: q2 z& Q) k| User        |
+-------------+
6 d8 [4 ]. u/ ]! U8 O% u. [6 S8 h| mariadb.sys |
% N. ]* T# U, ]  O6 V| mysql       |
% m7 C. P2 z( }+ J/ U| root        |
. V/ T* A: M+ S+-------------+
; Z3 t2 B+ s) p' @! Q: y3 ~* S) q6 D3 rows in set (0.003 sec)
, v) l- ]( v3 c  A
% ~9 I( R  S4 \) I* YMariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
% y6 D9 M8 x1 e( V# {Query OK, 0 rows affected (0.003 sec)

' a4 f- g6 q( s  WMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.001 sec)
- m5 r+ z3 h6 X* s% [9 H9 F
: W0 [, [3 D/ F1 Y3 o2 z8 h: uMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
Query OK, 0 rows affected (0.002 sec)
3 U( l2 R! z( q& s; {' W
3 R- r* H& {/ M2 a. g  g
! d0 L% N+ w* X( f. Z
9 d" Z( g3 V) t- a8 E" fMariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
5 m4 [. M5 X0 v1 _+ [, w9 RQuery OK, 0 rows affected (0.003 sec)
: R# j. J# i2 \3 V
MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
" H/ l8 S. `9 C! y, Y# G4 f5 EQuery OK, 0 rows affected (0.001 sec)


9 J8 Q7 s- o# D& E+ @7 J  g* ^6 i
1 W1 L% H) N; U3 ^- u
  R! R( f. J% ?' {6 T7 T
! ?3 v9 Z4 Z& r0 c/ N8 ^

admin

MariaDB [(none)]> create database restflask ;
2 P" y' K& G2 |" j& o( v/ w0 yQuery OK, 1 row affected (0.001 sec)
; j, h* L9 D# N7 h& I$ Z9 a

admin

测试连接 带ip地址访问：
mysql -u victor -p
+ }9 O- l, C0 |Enter password:
2 V3 _' x% E( _4 o8 ~Welcome to the MariaDB monitor.  Commands end with ; or \g.
+ V, ^. ?, _" Y, U7 q3 p8 kYour MariaDB connection id is 16
6 v/ D  [7 n0 k( G+ @' eServer version: 10.5.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
( q( k9 u5 f0 Q% x: L
4 E! `3 O2 |( dType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
& [/ W4 O" ]& i/ o+--------------------+
1 B1 {. h/ w9 h& K1 W| Database           |
8 D/ V3 v( B6 s+--------------------+
) S# Y% A6 R+ i& S! ?3 K| information_schema |
) S0 o& }: y' R1 B  w| restflask          |
+--------------------+
5 ~, `4 P9 X+ S: r% D2 rows in set (0.001 sec)

8 P# B/ Q3 M3 ]9 P4 A; v6 V3 `& M2 nMariaDB [(none)]> use restflask
) i4 E& U- t1 @  F$ u$ PDatabase changed
MariaDB [restflask]> show tables;
Empty set (0.000 sec)
2 }, F$ X. J6 Y' D
MariaDB [restflask]> exit
Bye
  P; S) l# v3 b8 j/ J[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
' P2 {7 A3 ^0 j6 g" o  B" @Enter password:
  I% I2 g: d5 ]% [Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server
1 I, H# y% R! y9 f# t- [, \! `
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

2 P' x( U' Z, _  C5 W4 m" eType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit
  z( w# k) C( i. S4 v% h- z2 q7 |" ~Bye
, |4 I6 I/ Q; |, N5 p0 O' {6 }

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
4 Y3 z+ D  d- ^8 h/ O- g; jQuery OK, 0 rows affected (0.004 sec)
# p# J& t* W& D7 y+ Z
8 W% m6 x: ~* b, e& h6 D. LMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.001 sec)
1 v; d  n6 y4 ~% U
MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
( D8 o: t: ~; VQuery OK, 0 rows affected (0.002 sec)
; `% z5 V: [- g2 {8 A. _* ?; A8 v

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
3 P! b9 B( z* a1 ^Query OK, 1 row affected (0.005 sec)

admin

MariaDB [(none)]> show create database testflask
    -> ;
6 h: F+ @6 }# \" j4 s# l( Y+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
3 |. g+ O( ^+ i  t; e& v+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
' ]8 R0 l1 W4 f  l* V' z+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
  ^5 i" o" l  R, M' G6 b8 H