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

admin

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

% u& \4 h; W5 K& U* T' ]" ^
, F& M, O3 i# BMariaDB [(none)]>  select distinct(User) from mysql.user;
+-------------+
5 Q% s/ J0 J9 I& J| User        |
+-------------+
| mariadb.sys |
. A$ o1 y8 {  g( ^| mysql       |
| root        |
+-------------+
3 rows in set (0.003 sec)
7 V4 b8 y7 p/ I6 }; l
MariaDB [(none)]> create user victor@'%' identified by 'victzzzz';
5 D# W  G3 i6 z7 L" ]/ ?' hQuery OK, 0 rows affected (0.003 sec)

( W' [: C2 r& x6 v1 w! s- qMariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'%' identified by 'victzzzz';
Query OK, 0 rows affected (0.001 sec)
- k8 Y2 t; Z8 x- n8 j, G
MariaDB [(none)]> grant ALL PRIVILEGES on restflask.* to victor@'localhost' identified by 'victzzzz';
7 t2 o6 E/ E# F1 W% V& M2 K9 [Query OK, 0 rows affected (0.002 sec)



MariaDB [(none)]> create user victor@'%' identified by 'victxxxx;
- g; v8 I! T! G7 rQuery OK, 0 rows affected (0.003 sec)
) H& r' a. W4 W9 o/ s$ Y
& Z1 g& N8 c' q8 Z# L# a9 JMariaDB [(none)]> create user victor@'localhost' identified by 'victxxxx';
Query OK, 0 rows affected (0.001 sec)
& C' z* ]" M2 J7 X( c1 O% n

, P) _! A( s) g

/ v$ R2 M6 X: c1 X+ [/ R6 p7 I# j8 G. `
: }8 t5 l1 p7 c3 N1 z& c% }$ D

admin

MariaDB [(none)]> create database restflask ;
5 L9 {% ?/ M7 w: q  JQuery OK, 1 row affected (0.001 sec)
+ A3 c) S( E% D2 J9 T

admin

测试连接 带ip地址访问：
  C2 P* @: h; F& V' W! M. U mysql -u victor -p
Enter password:
2 F0 P( P) n0 P* u% y+ J) kWelcome to the MariaDB monitor.  Commands end with ; or \g.
' O+ E. B: W3 \7 hYour MariaDB connection id is 16
0 U+ b, a0 t; m- }, bServer version: 10.5.22-MariaDB MariaDB Server
# }- X" P" n% g' f( q$ r1 L; a
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 P$ c- W4 _- i) b
MariaDB [(none)]> show databases;
+--------------------+
2 g3 j# ]' K$ c5 n. || Database           |
+--------------------+
| information_schema |
1 z! R. W' b2 L. b0 o+ v5 ^% {| restflask          |
! V: S  a  s$ @* S+--------------------+
4 T# d2 G6 Y# E+ y& Z2 rows in set (0.001 sec)
( [( [) T7 |3 z8 W1 g
MariaDB [(none)]> use restflask
; m/ ^3 }  W9 B% t1 gDatabase changed
6 K* A1 S; D+ }# g1 U1 n" M+ HMariaDB [restflask]> show tables;
Empty set (0.000 sec)

5 |; U1 i, x# [& I2 EMariaDB [restflask]> exit
- I" @( {4 O2 b0 D5 NBye
[root@python-flask mysqlclient-2.2.4]# mysql -u victor -p -h 192.168.13.131
0 p# C0 v9 S6 sEnter 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
1 e: a* \3 M& V, S: e) g
* p! O2 ~. G8 X0 RCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
2 E( v0 |) g) C, ~# N9 R
  }# k' a3 {) l) [# M# d# qMariaDB [(none)]> exit
Bye

admin

MariaDB [(none)]>  create user victor@'%' identified by 'xxxx';
. a* Q* c) m, WQuery 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)

MariaDB [(none)]> grant ALL PRIVILEGES on testflask.* to victor@'localhost' identified by 'xxxx';
+ H( [' w, |/ ^0 d& O7 mQuery OK, 0 rows affected (0.002 sec)
. o9 e9 [! `6 D7 b4 |

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
    -> ;
+ u8 |2 x- ?3 A# V* v2 e) |6 W2 |. p+-----------+--------------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                                  |
0 w+ [, l: W- F/ a# Z, u, P$ A, {* i+-----------+--------------------------------------------------------------------------------------------------+
| testflask | CREATE DATABASE `testflask` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
* U) {+ A, `' j* K* g/ v+-----------+--------------------------------------------------------------------------------------------------+
. H8 }+ J, t/ i- T, @* R# u1 row in set (0.001 sec)