在完成mariadb的搭建后，在端口与防火墙均为正常的情况下，出现了1130- Host xxx is not allowed to connect to this MariaDb server 的情况。笔者在网络上寻找了许久，最终发现了是因为授权的问题，使得连接权限受阻。所以，我们在这里，只需要进入数据库中，给予其权限即可。具体解决代码如下：[root@localhost ~]# mysql ....

文章 2022-12-11 来自：开发者社区

Python 连接MariaDB的一些小问题Cant connect to MySQL server

今天拿python写了一个后台连接MySQL（MariaDB）的页面，不过没想到居然会出现一个“被拒绝”的问题。pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([WinError 10061] 由于目标计算机积极拒绝，无法连接。)")当然，使用的是pymysql库了，我连接的是....

共有7条

< 1 >

跳转至： GO

更新时间 2024-02-27 09:45:15

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

云数据库MariaDB版您可能感兴趣

产品推荐

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1x.zTocVl614jSZKPXXaGjpXa-200-200.png","contentLink":"https://www.aliyun.com/product/rds/mariadb","title":"云数据库 MariaDB 版","des":"支持包括 MySQL InnoDB 等多种存储引擎，为不同需求的用户提供灵活的选择。具有Oracle兼容性、同城多可用区部署、支持多种存储引擎、企业级数据库特性等优势。","link1":"https://rdsnext.console.aliyun.com/rdsList/cn-hangzhou/basic/","btn1":"产品控制台","link2":"https://rdsbuy.console.aliyun.com/create/rds/MariaDB","btn2":"立即购买","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/90333.html?spm=5176.12145306.1240827.con1.2c2922a4M2YATS","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"数据库上云优选","firstContentLink":"https://www.aliyun.com/activity/database/bestoffers","lastContentLink":"https://help.aliyun.com/zh/rds/apsaradb-rds-for-mariadb/cloud-database-rds-mysql-postgresql-mariadb-package-year-on-month-full-range-of-specifications-price-reduction","lastContentName":"RDS 官网折扣大降价"}},{"infoName":"产品入门","infoContent":{"firstContentName":"帮助文档","lastContentName":"快速入门","firstContentLink":"https://help.aliyun.com/product/26090.html","lastContentLink":"https://help.aliyun.com/document_detail/90334.htm"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/90339.html","firstContentName":"连接 MariaDB 实例","lastContentLink":"","lastContentName":""}},{"infoName":"客户案例","infoContent":{"firstContentName":"数据库客户案例合集","lastContentName":"","firstContentLink":"https://www.aliyun.com/database/case","lastContentLink":""}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"mPaaS 小程序","bannerContent":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。<br>不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","contentTitle":"提供即开即用的端上体验","homePageLink":"https://common-buy.aliyun.com/?spm=5176.14673561.J_8751524360.2.56702709BussF3&commodityCode=mpaas_beta#/open","homePageName":"免费试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1x.zTocVl614jSZKPXXaGjpXa-200-200.png","contentLink":"https://www.aliyun.com/product/rds/mariadb","title":"云数据库 MariaDB 版","des":"支持包括 MySQL InnoDB 等多种存储引擎，为不同需求的用户提供灵活的选择。具有Oracle兼容性、同城多可用区部署、支持多种存储引擎、企业级数据库特性等优势。","link1":"https://rdsnext.console.aliyun.com/rdsList/cn-hangzhou/basic/","btn1":"产品控制台","link2":"https://rdsbuy.console.aliyun.com/create/rds/MariaDB","btn2":"立即购买","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/90333.html?spm=5176.12145306.1240827.con1.2c2922a4M2YATS","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"数据库上云优选","firstContentLink":"https://www.aliyun.com/activity/database/bestoffers","lastContentLink":"https://help.aliyun.com/zh/rds/apsaradb-rds-for-mariadb/cloud-database-rds-mysql-postgresql-mariadb-package-year-on-month-full-range-of-specifications-price-reduction","lastContentName":"RDS 官网折扣大降价"}},{"infoName":"产品入门","infoContent":{"firstContentName":"帮助文档","lastContentName":"快速入门","firstContentLink":"https://help.aliyun.com/product/26090.html","lastContentLink":"https://help.aliyun.com/document_detail/90334.htm"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/90339.html","firstContentName":"连接 MariaDB 实例","lastContentLink":"","lastContentName":""}},{"infoName":"客户案例","infoContent":{"firstContentName":"数据库客户案例合集","lastContentName":"","firstContentLink":"https://www.aliyun.com/database/case","lastContentLink":""}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"mPaaS 小程序","bannerContent":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。<br>不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","contentTitle":"提供即开即用的端上体验","homePageLink":"https://common-buy.aliyun.com/?spm=5176.14673561.J_8751524360.2.56702709BussF3&commodityCode=mpaas_beta#/open","homePageName":"免费试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}}

云数据库 MariaDB 版

支持包括 MySQL InnoDB 等多种存储引擎，为不同需求的用户提供灵活的选择。具有Oracle兼容性、同城多可用区部署、支持多种存储引擎、企业级数据库特性等优势。

产品控制台

立即购买

产品文档