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

admin

创建mysql用户并创建对应的访问库
2 v0 L3 R7 T! Q- T, Q2 P2 M

MariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
| User        |
+-------------+
| mariadb.sys |
2 V: C& Q& i  B| mysql       |
4 ~4 U' J; t$ S. U: J) U| root        |
+-------------+
5 P; \/ ]0 ?* @: s* v9 h3 rows in set (0.003 sec)

3 X5 R$ C2 X0 _* ?1 nMariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
1 A5 ?+ D+ p0 L; Z( m3 v0 JQuery OK, 0 rows affected (0.003 sec)
- D' U/ e7 x$ N
$ J0 o5 s5 e! x; H) YMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
% f/ g+ |2 Q) ~' M3 Z- S, h) x- bQuery OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
& v8 ^3 R9 }+ L& j$ v5 ^Query OK, 0 rows affected (0.002 sec)
' t' x  k' ~0 A4 A


2 `/ `' G- J' c8 VMariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
2 v2 s5 v  A, z4 \Query OK, 0 rows affected (0.003 sec)
6 D& ^; u0 I1 S. v/ `$ H+ j( m
MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
$ l2 h2 B" U* K# u+ ~9 E+ {; `Query OK, 0 rows affected (0.001 sec)
6 u2 H2 A) P& ~& g7 q

3 S* v) y& M: w! s
2 p) \1 J( K; q2 k) q8 z, t/ N7 u4 G; c
) D6 H+ N" P6 I1 ?0 k$ u' k
+ O& s. U; P& D( u
; M' w# s/ r, P" A! a

admin

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

admin

测试连接 带ip地址访问：
mysql -u victor -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
+ a& H$ d* ]4 SServer version: 10.5.22-MariaDB MariaDB Server

7 e% s" \3 r3 m) a# H7 i; j: N, U# yCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
# \% o+ G2 O! T: r! u4 G* Y* \
MariaDB [(none)]> show databases;
+--------------------+
2 l9 A; [4 N: \7 d| Database           |
+--------------------+
| information_schema |
! t; K) o1 n5 A/ b, m| restflask          |
) @& ^+ F: `5 G2 U- k, Z/ ^+--------------------+
2 rows in set (0.001 sec)
6 A1 u+ P( x. o9 V; W# c
MariaDB [(none)]> use restflask
Database changed
+ A1 f' c: V7 E6 cMariaDB [restflask]> show tables;
& s- ]% \2 r! A  iEmpty set (0.000 sec)

% H- N6 Y4 W7 ~MariaDB [restflask]> exit
# |/ S2 A7 j9 k% ^% a% `Bye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
# U7 `6 m) G  X/ ?+ u/ OEnter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
Server version: 10.5.22-MariaDB MariaDB Server
: c) Y' W7 e9 `& Z9 R% c
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
( n  I' X5 X( V
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1 ~' o0 v  e2 s, ?( R$ n6 k
2 O" @+ T  g) i: W* tMariaDB [(none)]> exit
, j7 A* [. C% e% f8 q# o* `Bye

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';
Query OK, 0 rows affected (0.001 sec)
- d+ [, z* N7 O0 N
% R* R; {5 F/ }0 T* U7 t- V& ~2 j* |MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.002 sec)
* _) F9 b/ _1 ^4 C- ?* R& x+ c) d

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
4 g( f7 h6 K2 t- fQuery OK, 1 row affected (0.005 sec)
# @' S5 M- S/ C# ^1 w. \8 \6 Y

admin

MariaDB [(none)]> show create database testflask
    -> ;
+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
& C0 N; t, \9 ]  m- `; P& R+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
9 B+ f% V% u( S( I) Z# C6 i6 V+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)