django如何连接mysql 数据库(For windows11)？

1.在setting中设置：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': name of your database,
        'USER': username,
        'PASSWORD': password,
        'HOST':'localhost',
        'PORT':'',
    }
}

2.安装mysql

3.安装mysqlclient: pip install mysqlclient

4.在mysql command line client中写入：

mysql -u root -p;

5.创建数据库

CREATE DATABASE 'name of your database';

6.创建数据库用户

CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';

7.授权用户

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';