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

admin

创建mysql用户并创建对应的访问库
' z, u& f9 C$ O, G+ o. \

MariaDB [(none)]>  select distinct(User) from mysql.user;
! X+ z- N1 B& P6 P6 y* E+-------------+
5 h( P2 V: ~6 l8 {! I) _| User        |
/ I3 ?5 Q- d2 d; Z* \+ Z1 l) D+-------------+
| mariadb.sys |
| mysql       |
| root        |
+-------------+
3 rows in set (0.003 sec)

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

% E1 u! L  W- b1 X4 j% r( U( EMariaDB [(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';
Query OK, 0 rows affected (0.002 sec)

# w$ y1 h  [1 ]) Q9 C; e

MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
Query OK, 0 rows affected (0.003 sec)
6 z1 q2 R4 n2 j0 ?% f1 Q; C( h
MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
Query OK, 0 rows affected (0.001 sec)

8 v/ h7 s8 e% z8 p+ c3 Y! b, i- |1 l


% P  S1 r% F' J8 V4 Y0 W: O

admin

MariaDB [(none)]> create database restflask ;
  W: C9 K2 c: H1 h% s! S# VQuery OK, 1 row affected (0.001 sec)
, h% d3 _  R5 T0 V% H1 G

admin

测试连接 带ip地址访问：
mysql -u victor -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
# o, w! h/ \, V8 R# M9 MServer version: 10.5.22-MariaDB MariaDB Server

# O0 c$ \* ]6 _Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
3 ]! L/ i3 C  |0 k3 r6 K; U/ f
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

# x* K2 p7 p0 C9 J( ?MariaDB [(none)]> show databases;
+--------------------+
' s! K' n9 @  `1 n# Z( I. c| Database           |
  n* ?7 h6 ^* S/ Z1 {* I+--------------------+
| information_schema |
7 X* S4 h+ G5 @1 z+ \6 ~6 v# O4 \7 i| restflask          |
8 [& i9 k/ u8 r% ?0 }( g5 y+--------------------+
2 rows in set (0.001 sec)

MariaDB [(none)]> use restflask
Database changed
MariaDB [restflask]> show tables;
Empty set (0.000 sec)

! S2 A- @4 N4 _  _& l* ~MariaDB [restflask]> exit
Bye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
+ H! T3 l% T+ g0 c6 W2 z- VServer version: 10.5.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
0 c8 H2 k% n6 F; h
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
0 H+ [! i2 H: E0 p( x+ u7 q# s' _
MariaDB [(none)]> exit
- O) M! {( O% n/ F0 [% ~- k9 OBye

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
Query OK, 0 rows affected (0.004 sec)
3 ?$ x9 s1 Z  o9 l! ~0 C8 w
6 W' l# r: y9 K' ~4 ZMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'%' identified by 'xxxx';
' P$ L0 K; E: |6 i5 |% ]Query OK, 0 rows affected (0.001 sec)
$ G2 ?* ~; ?+ Z9 b
MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.002 sec)

admin

MariaDB [(none)]> CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ ;
/ O$ U) l3 m# H: ~6 T) q- EQuery OK, 1 row affected (0.005 sec)
) l5 ^* `" H; x3 j

admin

MariaDB [(none)]> show create database testflask
    -> ;
) Z( S2 j1 M, Z; q5 m9 b+-----------+--------------------------------------------------------------------------------------------------+
, u8 l1 _! Q9 W# S  h| Database  | Create Database                                                                                  |
+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
+-----------+--------------------------------------------------------------------------------------------------+
' `/ F1 Z. v' t4 d% |9 K/ Y1 row in set (0.001 sec)
/ Q9 I2 c- Y7 f" c7 [