Django 2.0 入门与实践---- 第14章笔记 (四)_creating test database for alias default'... got a-优快云博客

本文详细介绍了Django2.0中通用视图系统的使用，并记录了解决在创建测试数据库时遇到的数据库访问权限问题的过程。通过调整MySQL用户权限，成功解决了‘Access denied for user’的错误，确保了Django应用能够正常运行。

Django 2.0 入门与实践---- 第14章笔记 (四)

page175
page180
page183
page185

通用视图系统

遇到一个错误:
Creating test database for alias ‘default’…
Got an error creating the test database: (1044, “Access denied for user ‘cat’@’%’ to database ‘test_cat_db’”)

在这里插入图片描述

这个错误不知道怎么解决

mysql -u cat -p

show databases;

GRANT ALL PRIVILEGES ON test_django_mysite.* TO admin@localhost IDENTIFIED BY ‘mypassword’;

create user ‘cat’@’%’ identified by ‘123456’;
create database cat_db DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
grant all privileges on cat_db.* to cat@’%’ ;
flush privileges;

解决方法：

参考网址:
https://www.jianshu.com/p/73fb45b9da73

在这里插入图片描述

mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'cat'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
service mysql restart

在这里插入图片描述

class Question(models.Model):
    question_text = models.CharField(max_length=200)
    pub_date = models.DateTimeField('date published')
    
    def was_published_recently(self):
        #return self.pub_date >= timezone.now() - datetime.timedelta(days=1)
        now = timezone.now()
        return now - datetime.timedelta(days=1) <= self.pub_date <= now 
        
        
    def __str__(self):
        return self.question_text

在这里插入图片描述

参考网址

https://www.cnblogs.com/tinywan/p/6641780.html

mysql 赋给root用户权限 grant all privileges on
grant all on *.* to root@'%' identified by 'root' with grant option;

flush privileges;
刷新flush privileges;然后重启mysql，通过/etc/init.d/mysql restart命令
/etc/init.d/mysql restart　　-- 重启Mysql