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

admin

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

) s9 Y/ r& N, `: }9 d
; y9 S  G. i( B6 NMariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
1 y- W: e" ~4 j* O- [1 M: j: J| User        |
# J: u3 C8 B* y) z# c  n+-------------+
| mariadb.sys |
2 W; N. k: o1 v1 E9 _) V, i5 P| mysql       |
. V  C. G/ `( _| root        |
2 R' x4 t' k) [+-------------+
/ O* `. U0 t6 G3 rows in set (0.003 sec)
$ @" a5 a3 o' s0 ~# y
MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.003 sec)
8 G4 w9 A% D0 F7 @
8 E) e4 h* V( v# D" }MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
$ d; h, z: Y& {Query OK, 0 rows affected (0.002 sec)
2 k/ ~+ z! {3 T3 n! M

, e, n+ f* B9 f9 s, Q
MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
+ ?6 D& U7 q/ X0 A6 w8 A- NQuery OK, 0 rows affected (0.003 sec)
- _8 I, r0 D/ v+ w
, X  m' Y# m" h, k. ^MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
2 J# j6 P5 |: ^Query OK, 0 rows affected (0.001 sec)
% e/ T  p# ?9 |& f( U5 D4 o% q



' X; |! o! e( b7 T& p  v- q

admin

MariaDB [(none)]> create database restflask ;
Query OK, 1 row affected (0.001 sec)
4 e/ v' d# \5 h9 M

admin

测试连接 带ip地址访问：
mysql -u victor -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
/ q6 J4 e" g; \! D6 b& f% G( f# @Your MariaDB connection id is 16
0 d) u, E5 {- k$ VServer version: 10.5.22-MariaDB MariaDB Server
* N* N( @% i$ P9 d5 `, a' q1 ~
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
! _8 x  d1 f8 w( `0 q# e" x
6 e1 r, ]6 P; b$ `; uType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

9 }. a# e% ?. }, m5 _% eMariaDB [(none)]> show databases;
+--------------------+
2 v' \) r$ P4 X9 v1 K7 Y$ v| Database           |
+--------------------+
| information_schema |
| restflask          |
6 F$ |4 {6 z& v4 d5 O2 j% J8 Z+--------------------+
( S( h1 |6 R. [" D2 rows in set (0.001 sec)
( n  S& m, v- S' s
2 W4 b5 }8 Q. `2 D0 uMariaDB [(none)]> use restflask
1 j- R% I+ S# [% S- NDatabase changed
9 K# q$ V, U6 {. b, wMariaDB [restflask]> show tables;
! f' A9 v) S2 k6 t  bEmpty set (0.000 sec)

MariaDB [restflask]> exit
+ [3 r0 }3 X0 h7 G: B  lBye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
" [, f6 T$ t! a' JWelcome to the MariaDB monitor.  Commands end with ; or \g.
; m6 w$ N8 }- g. j( [( V/ C: wYour MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server

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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
/ A- U! Z2 t) E$ ?2 b6 @$ {7 s1 Z
9 F- N, t: t4 O$ E$ e0 e, |MariaDB [(none)]> exit
Bye
" O9 X) S* V  _3 X+ H

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.004 sec)
9 b8 |2 ^0 Y, z% n6 u
% O% s  ^1 Z9 @$ |6 [& pMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
. D+ {. N& b; F# v/ u4 F& SQuery OK, 0 rows affected (0.001 sec)
: ]4 }6 t! q0 R! R) Q7 Y2 c
MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.002 sec)
2 E8 F1 y$ {8 Z6 y9 h2 t4 C2 \9 D# x. V

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
% o9 Z1 |1 \$ x/ t% {2 ]+ ]Query OK, 1 row affected (0.005 sec)
) N! n2 b$ F1 W7 J$ r1 q% n2 L. p

admin

MariaDB [(none)]> show create database testflask
& i9 v' Y) o4 p: J) I, I1 b  L" w    -> ;
+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
0 K' \; N' ~6 A9 I4 h9 G! _* V+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
% g& A& R" C2 B" ?' n; D8 C+ G' \