django - How to deal with this ERROR (1049, "Unknown database '/users/ohyunjun/work/astral/mysql'") -

in django settings.py, set databases option way

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',     } } 

and executed command

python manage.py syncdb

but failed error

  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", line 127, 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' name of database. mysql, need manually create database too. let's say, if run:

$ mysql -u root -p  mysql> create database mydb; query ok, 1 row affected (0.02 sec) 

your configuration should be:

databases = {     'default': {         'engine': 'django.db.backends.mysql',         'name': 'mydb',         'user': 'root',         'password': 'sp153426',         'host': '127.0.0.1',         'port': '3306',     } }