3. Flash build barrage micro movie website – install MySQL database and configuration

Time:2021-6-3

Baidu cloud search, search all kinds of information: http://www.lqkweb.com

Search the Internet disk for all kinds of information: http://www.swpan.cn

Flash builds micro movie video website

Online demo address:http://movie.tbquan.cn

Install database connection dependency package

Installation packageflask-sqlalchemy

pip install flask-sqlalchemy

pip list
Package          Version
---------------- -------
Click            7.0
Flask            1.0.2
Flask-SQLAlchemy 2.3.2
itsdangerous     0.24
Jinja2           2.10
MarkupSafe       1.0
pip              18.1
setuptools       40.4.3
SQLAlchemy       1.2.12
Werkzeug         0.14.1
wheel            0.32.1

Chinese document

http://www.pythondoc.com/flas…

View configuration key:http://www.pythondoc.com/flas…

3. Flash build barrage micro movie website - install MySQL database and configuration

Connection format

MySQL: mysql://username:[email protected]/mydatabase

Creating MySQL database

Download MySQL

https://dev.mysql.com/downloa…

Here’s the latest version8.0

MySQL Community Server

Learn to download the community version

Install MySQL

3. Flash build barrage micro movie website - install MySQL database and configuration

3. Flash build barrage micro movie website - install MySQL database and configuration

3. Flash build barrage micro movie website - install MySQL database and configuration

To open the start menuMySQL 8.0 Command Line ClientVerify normal installation

Enter password: root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> \s
--------------
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe  Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)

Connection id:          11
Current database:
Current user:           [email protected]
SSL:                    Cipher in use is DHE-RSA-AES128-GCM-SHA256
Using delimiter:        ;
Server version:         8.0.12 MySQL Community Server - GPL
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Uptime:                 2 min 20 sec

Threads: 2  Questions: 23  Slow queries: 0  Opens: 147  Flush tables: 2  Open tables: 123  Queries per second avg: 0.164
--------------

If in CMDmysqlThe command doesn’t work. You need to add environment variablesPathAdd inC:\Program Files\MySQL\MySQL Server 8.0\bin\, which is the installation directory of MySQL

Then you can log in through the following command

mysql -uroot -p
Enter password: root