pycharm连接MySQL数据库

快来打我* 2024-04-18 19:56 54阅读 0赞

使用pymysql库的时候，查找资料有下面几个，都是实用的，只是搜集了一下

1、链接：[https://blog.csdn.net/bobo553443/article/details/81383194][https_blog.csdn.net_bobo553443_article_details_81383194]

![20190911131017302.png][]

2、链接：[https://blog.csdn.net/u014417138/article/details/83052962][https_blog.csdn.net_u014417138_article_details_83052962]

还有用到MySQL的环境变量的配置，这篇文章我只用了环境配置的方法

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70][]

3、链接：[https://blog.csdn.net/coding\_life\_ssc/article/details/79491958][https_blog.csdn.net_coding_life_ssc_article_details_79491958]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 1][]

4、一开始出现报错，是由于文件名与库名相同，都命名成了PyMysql，命名成sql也不行，换成1就可以了。password里面改成自己当时设置的密码。如果没有pymysql库，我上一篇里面有怎么添加库

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 2][]

5、能在之前安装Mysql的时候，用Workbench可以看到自己刚刚创建的表

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 3][]

[https_blog.csdn.net_bobo553443_article_details_81383194]: https://blog.csdn.net/bobo553443/article/details/81383194
[20190911131017302.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/22a72a2f104b4f028188048268b86e8e.png
[https_blog.csdn.net_u014417138_article_details_83052962]: https://blog.csdn.net/u014417138/article/details/83052962
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/ffe6ce47d08040408b1fa03875b53d4e.png
[https_blog.csdn.net_coding_life_ssc_article_details_79491958]: https://blog.csdn.net/coding_life_ssc/article/details/79491958
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/923b2becbbb8441dab0ba7560020762d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/410350b12da242d588fbbde872c6824d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1eGlhbmdkZW1pbmc_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/cf135731984541d8b2358bef5419798c.png