mysql
mysql
pillowss
这个作者很懒,什么都没留下…
展开
-
sqlalchemy 链接数据库,指定编码,解决密码含有特殊字符
from urllib.parse import quote_plus as urlquote connstr = "mysql+mysqldb://root:"+urlquote(“password”)+"@127.0.0.1:3306/dbname?charset=utf8" engine = create_engine(connstr,echo=True,max_overflow=5) https://blog.csdn.net/baixue6269/article/details/77712395原创 2021-06-21 11:16:22 · 398 阅读 · 0 评论 -
mogno连接
import pymongo def get_mongo(host, collection, port, db, user=None, password=None, auth=False): client = pymongo.MongoClient(host=host, port=port) if auth: client.admin.authenticate(user, password) db = client[db][collection] retur原创 2021-06-10 10:45:10 · 97 阅读 · 0 评论 -
安装mysql8
文章目录安装mysql设置mysql允许远程访问 安装mysql 执行下面三条命令 1、sudo apt-get install mysql-server 2、sudo apt-get install mysql-client 3、sudo apt-get install libmysqlclient-dev 打开数据库 mysql -uroot -p 设置mysql允许远程访问 sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 注释掉bind-address = 127原创 2020-11-05 12:16:33 · 76 阅读 · 0 评论