
数据库
小小蒲公英
博主长期熬夜加班身体抱恙,转行健康领域了
展开
-
Manjaro 下安装MySQL
安装sudo pacman -S mysql配置#初始化sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql#启动sudo systemctl start mariadb#设置密码mysql_secure_installation#设置开机启动sudo systemctl enable mysqld原创 2021-08-30 10:19:58 · 425 阅读 · 0 评论 -
Manjaro系统安装 postgresql 数据库(源码安装)
1.下载postgresql-11.2.tar.gz2.解压tar -xvzf postgresql-11.2.tar.gz3.进入解压目录 cd postgresql-11.24.检测安装平台的目标特征./configure --prefix=/opt/postgresql5.编译make6.安装sudo make install7.添加用户&新用户相关...原创 2019-02-26 15:13:28 · 2483 阅读 · 0 评论 -
ServerSelectionTimeoutError: localhost:27017: [Errno 111] Connection refused
原码import pymongoimport datetimeclient=pymongo.MongoClient() #建立连接db=client.papers #获取数据库collection=db.books # 获取集合#插入文档book={ "author":"Mike", "text":"My first book!", ...原创 2018-08-10 17:28:57 · 6228 阅读 · 1 评论 -
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: css_templates
报错 File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__ return self._execute_and_instances(context) File "/home/as/anaconda3/e...原创 2018-01-22 20:40:28 · 15158 阅读 · 10 评论 -
ImportError: No module named 'MySQLdb'
报错Traceback (most recent call last): File "/home/as/anaconda3/envs/superset/bin/superset", line 12, in <module> from superset.cli import manager File "/home/as/anaconda3/envs/superse...原创 2018-01-22 20:17:15 · 1952 阅读 · 0 评论 -
MySQL管理
登录mysql -u root -p退出exit;quit;\q;列出数据库SHOW DATABASES;创建数据库create database 数据库名;删除数据库DROP DATABASE 数据库名;选择数据库use 数据库名;创建表create table 表名称;原创 2018-01-21 08:35:31 · 182 阅读 · 0 评论 -
ModuleNotFoundError: No module named 'ConfigParser'
问题:Complete output from command python setup.py egg_info: Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pip-build-c_y6ttgr/MySQL-py...原创 2017-12-01 08:15:39 · 6955 阅读 · 0 评论 -
ubuntu安装python MySQLdb
sudo apt-get install python-pipsudo apt-get install libmysqlclient-devsudo pip install mysql-python原创 2017-11-19 23:45:46 · 805 阅读 · 0 评论 -
Linux安装MySQL
sudo apt-get install mysql-serverapt-get install mysql-clientsudo apt-get install libmysqlclient-dev登入mysql -u root -p原创 2017-11-19 10:56:33 · 202 阅读 · 0 评论