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

admin

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


4 J1 Q2 o- g* ?  v* HMariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
| User        |
+-------------+
; W) O- [3 H- z: Z; w| mariadb.sys |
| mysql       |
| root        |
+-------------+
3 rows in set (0.003 sec)

6 J' I! q) }- O' u  x& rMariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
/ _1 ~& F" g: p9 l; j' bQuery OK, 0 rows affected (0.003 sec)

6 i# x8 [' u7 B: n  MMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.001 sec)

: l- ~) m5 a% d5 mMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
. D2 I4 ^8 m2 L1 ZQuery OK, 0 rows affected (0.002 sec)


2 Z+ {: u5 Q5 o' Y; Z" h, I
MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
1 R" J( {' t$ dQuery OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
Query OK, 0 rows affected (0.001 sec)

: |) g0 m. r3 g5 `1 j8 C



' E; c- ^7 c! r3 q7 g' f& h
  b; F  ]4 e- m* G9 G

admin

MariaDB [(none)]> create database restflask ;
  d& h7 o2 `' O: c/ @4 t( Y* zQuery OK, 1 row affected (0.001 sec)
2 o" w6 s8 e- i0 v7 j

admin

测试连接 带ip地址访问：
mysql -u victor -p
' W% {1 Z% o# G. s# t1 DEnter password:
# C. b# L5 [! IWelcome to the MariaDB monitor.  Commands end with ; or \g.
. T9 q3 R" m' X! f6 g; [( vYour MariaDB connection id is 16
3 U0 v' O: B6 h% Y) s, tServer version: 10.5.22-MariaDB MariaDB Server

$ v, g1 @. g( h. C" A: ZCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
3 `5 ~" I0 g6 e; m* o0 O- C+--------------------+
# w! T0 Z! f$ d| information_schema |
| restflask          |
8 {/ C" ^' m% {# K+--------------------+
+ X$ G* g  U: I' H! J2 rows in set (0.001 sec)

; @6 c* Y. q$ [7 wMariaDB [(none)]> use restflask
0 E+ C9 u# c8 T: `: G% o5 H1 lDatabase changed
# O  x4 @+ E  EMariaDB [restflask]> show tables;
" h0 M6 _# R+ \+ u$ ~Empty set (0.000 sec)
* b- V- N6 k& L; I* U: S' ?* A% D
MariaDB [restflask]> exit
: E0 E: U- j; b1 {" PBye
/ J: X, U  v: C% w  T! u2 M! N[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
Enter password:
  S, j7 w3 J! l4 Y: P" f) j* N+ tWelcome to the MariaDB monitor.  Commands end with ; or \g.
  I3 n# z0 g" f8 S, I8 c7 ZYour 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.
5 r  C  O+ j+ F/ n4 S
MariaDB [(none)]> exit
Bye
/ {- J5 Q; S! ^' q

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';
5 h) ]8 o  ^  S: V1 |  MQuery OK, 0 rows affected (0.001 sec)

8 r6 w; O( P# |: z- b) N* TMariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
) ]" D: |, ]) C/ \0 A5 B: BQuery OK, 0 rows affected (0.002 sec)

admin

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

admin

MariaDB [(none)]> show create database testflask
# }+ S/ V1 g0 p. J1 j0 b6 w( `    -> ;
4 u" T0 E7 j  u% ~  S6 d4 i% ]% u/ r9 o: N+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
2 a3 \! N' M! f  `+-----------+--------------------------------------------------------------------------------------------------+
1 I* A; S* H1 J$ B$ o1 row in set (0.001 sec)
4 p8 U2 ~/ P: U+ t4 E5 Q: x