如何处理这个错误(1049,“未知数据库”/ users / ohyunjun / wor

发布时间：2020-12-12 16:32:33 所属栏目：MsSql教程来源：网络整理

导读：在Django settings.py中,我以这种方式设置数据库选项 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql','NAME': os.path.join(BASE_DIR,'mysql'),'USER': 'root','PASSWORD': 'sp153426','HOST': '127.0.0.1','PORT': '3306',}} 我执行了这

在Django settings.py中,我以这种方式设置数据库选项

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql','NAME': os.path.join(BASE_DIR,'mysql'),'USER': 'root','PASSWORD': 'sp153426','HOST': '127.0.0.1','PORT': '3306',}
}

我执行了这个命令

python manage.py syncdb

但是失败了这个错误

File "manage.py",line 10,in <module>
    execute_from_command_line(sys.argv)
  File "/Library/Python/2.7/site-packages/django/core/management/__init__.py",line 399,in execute_from_command_line
    utility.execute()
  File "/Library/Python/2.7/site-packages/django/core/management/__init__.py",line 392,in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Library/Python/2.7/site-packages/django/core/management/base.py",line 242,in run_from_argv
    self.execute(*args,**options.__dict__)
  File "/Library/Python/2.7/site-packages/django/core/management/base.py",line 285,in execute
    output = self.handle(*args,**options)
  File "/Library/Python/2.7/site-packages/django/core/management/base.py",line 415,in handle
    return self.handle_noargs(**options)
  File "/Library/Python/2.7/site-packages/django/core/management/commands/syncdb.py",line 57,in handle_noargs
    cursor = connection.cursor()
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py",line 160,in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py",line 132,in _cursor
    self.ensure_connection()
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py",line 127,in ensure_connection
    self.connect()
  File "/Library/Python/2.7/site-packages/django/db/utils.py",line 99,in __exit__
    six.reraise(dj_exc_type,dj_exc_value,traceback)
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py",in ensure_connection
    self.connect()
  File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py",line 115,in connect
    self.connection = self.get_new_connection(conn_params)
  File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py",line 435,in get_new_connection
    conn = Database.connect(**conn_params)
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.6-intel.egg/MySQLdb/__init__.py",line 81,in Connect
    return Connection(*args,**kwargs)
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.6-intel.egg/MySQLdb/connections.py",line 187,in __init__
    super(Connection,self).__init__(*args,**kwargs2)
django.db.utils.OperationalError: (1049,"Unknown database '/users/ohyunjun/work/astral/mysql'")

解决方法

‘NAME’是数据库的名称.使用MySQL,您也需要手动创建数据库.假设你运行：

$mysql -u root -p

mysql> CREATE DATABASE mydb;
Query OK,1 row affected (0.02 sec)

你的配置应该是：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql','NAME': 'mydb',}
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!