django2.2连接mysql遇到的坑(亲测)

た入场券 2023-10-06 10:02 18阅读 0赞

1、mysql数据库配置

![format_png][]

2、首先需要建一个myweb数据库

3、执行数据库迁移命令makemigrations

python manage.py makemigrations MySite

报错：

![format_png 1][]

主要是说没有安装mysql客户端；但是明明安装了，因为没有mysql那个包，只有pymysql

需要在项目的目录下的\_\_init\_\_.py 添加如下代码；此目录C:\\Users\\28277\\Desktop\\MyWebs\\Lib\\site-packages\\django\\db\\backends\\mysql 下的\_\_init\_\_.py

import pymysql
    pymysql.install_as_MySQLdb()

![format_png 2][]

4、继续执行makemigrations迁移命令，又报错

![format_png 3][]

mysql版本太低了，进入C:\\Users\\28277\\Desktop\\MyWebs\\Lib\\site-packages\\django\\db\\backends\\mysql\\base.py 文件

![format_png 4][]

35,36行需要注释掉，然后就不会因为版本而报错，具体啥版本问题是否更新mysql不懂

注释掉后：

![format_png 5][]

5、继续执行迁移命令，还是报错了；

进入C:\\Users\\28277\\Desktop\\MyWebs\\lib\\site-packages\\django\\db\\backends\\mysql\\operations.py

![format_png 6][]

decode 改为encode

修改后如下：

![format_png 7][]

6、继续执行迁移命令，正确

![format_png 8][]

来源:[https://www.cnblogs.com/hanwenlin/p/10677026.html][https_www.cnblogs.com_hanwenlin_p_10677026.html]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE0NTk0MzMwNy0xMzgwMjEwNjkzLnBuZw?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDEzMDU0NS0xOTA4MjM3MTcxLnBuZw?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDQxMzY4NS02NTYyMDY2OTMucG5n?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDUxMDU3MC0xMDAyMjYwNTUyLnBuZw?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDYyMjkwMy0xODQzNjY3MjI4LnBuZw?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDcyNjMyNS0xOTQ3NzU4MzY3LnBuZw?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDg1Mjc0Ni03OTA0NDkyOTYucG5n?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MDkyNzg5Mi0xNDgyNDg2NDE4LnBuZw?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTM0MzQ3MC8yMDE5MDQvMTM0MzQ3MC0yMDE5MDQwOTE1MTAxMDM4NC0xMDU3NTExNDIzLnBuZw?x-oss-process=image/format,png
[https_www.cnblogs.com_hanwenlin_p_10677026.html]: https://www.cnblogs.com/hanwenlin/p/10677026.html