Mysql
Lovehanxiaoyan
这个作者很懒,什么都没留下…
展开
-
django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required;
在项目的__init__.py里添加import pymysqlpymysql.version_info = (1, 4, 13, "final", 0)pymysql.install_as_MySQLdb()原创 2020-11-13 16:41:09 · 171 阅读 · 0 评论 -
(1062, “Duplicate entry ‘xxx‘ for key ‘xxx“)
修改或删除索引原创 2020-10-13 18:12:03 · 570 阅读 · 0 评论 -
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full comm
1、终端输入一下命令PATH="$PATH":/usr/local/mysql/bin/mysql_config2、安装mysqlclientpip install mysqlclient原创 2020-07-29 17:54:25 · 614 阅读 · 0 评论 -
Mysql之开启远程访问权限
1、进入到数据库1)mysql -uroot -p密码2)use mysql;2、 查询用户表命令:select User,authentication_string,Host from user3、给root用户开启远程访问权限1)GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' 这里的mysq...原创 2020-02-17 10:45:48 · 147 阅读 · 0 评论 -
centos安装mysql
1、安装mysql wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm yum -y install mysql-community-server2、启动syst...原创 2020-02-17 04:33:35 · 139 阅读 · 0 评论 -
Django之数据裤迁移--python No migrations to apply
一:删除子应用下migrations文件夹下的迁移文件二:进入数据库找到django_migrations的表,删除该app名字的所有记录。三:执行迁移命令python manage.py makemigrationspython manage.py migrate...原创 2019-12-11 09:32:21 · 354 阅读 · 0 评论