I have a virtualenv with Python 3.4, Django 1.7 and MySQL installed on Windows 7.
-- I also have the MySQL / Python adapter installed and the database settings in settings.py:
DATABASES = {
'default': {
'NAME': 'mydb',
'ENGINE': 'mysql.connector.django',
'USER': 'root',
'PASSWORD': 'fishy1777',
}
}
When I do a syncdb I get the following errors:
(landy) C:\landy\cresta>python manage.py syncdb
Traceback (most recent call last):
File "C:\landy\lib\site-packages\django\db\backends\__init__.py", line 133, in
ensure_connection
self.connect()
File "C:\landy\lib\site-packages\django\db\backends\__init__.py", line 122, in
connect
self.connection = self.get_new_connection(conn_params)
File "C:\landy\lib\site-packages\mysql\connector\django\base.py", line 590, in
get_new_connection
cnx = mysql.connector.connect(**conn_params)
File "C:\landy\lib\site-packages\mysql\connector\__init__.py", line 157, in co
nnect
return MySQLConnection(*args, **kwargs)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 122, in
__init__
self.connect(**kwargs)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 431, in
connect
self._open_connection()
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 398, in
_open_connection
self._ssl)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 187, in
_do_auth
self._auth_switch_request(username, password)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 224, in
_auth_switch_request
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1049 (42000): Unknown database 'mydb'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "C:\landy\lib\site-packages\django\core\management\__init__.py", line 385
, in execute_from_command_line
utility.execute()
File "C:\landy\lib\site-packages\django\core\management\__init__.py", line 354
, in execute
django.setup()
File "C:\landy\lib\site-packages\django\__init__.py", line 21, in setup
apps.populate(settings.INSTALLED_APPS)
File "C:\landy\lib\site-packages\django\apps\registry.py", line 108, in popula
te
app_config.import_models(all_models)
File "C:\landy\lib\site-packages\django\apps\config.py", line 197, in import_m
odels
self.models_module = import_module(models_module_name)
File "C:\Python34\lib\importlib\__init__.py", line 104, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 2231, in _gcd_import
File "<frozen importlib._bootstrap>", line 2214, in _find_and_load
File "<frozen importlib._bootstrap>", line 2203, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 1200, in _load_unlocked
File "<frozen importlib._bootstrap>", line 1129, in _exec
File "<frozen importlib._bootstrap>", line 1448, in exec_module
File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed
File "C:\landy\lib\site-packages\django\contrib\auth\models.py", line 40, in <
module>
class Permission(models.Model):
File "C:\landy\lib\site-packages\django\db\models\base.py", line 125, in __new
__
new_class.add_to_class('_meta', Options(meta, **kwargs))
File "C:\landy\lib\site-packages\django\db\models\base.py", line 300, in add_t
o_class
value.contribute_to_class(cls, name)
File "C:\landy\lib\site-packages\django\db\models\options.py", line 166, in co
ntribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length(
))
File "C:\landy\lib\site-packages\django\db\__init__.py", line 40, in __getattr
__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "C:\landy\lib\site-packages\django\db\utils.py", line 243, in __getitem__
conn = backend.DatabaseWrapper(db, alias)
File "C:\landy\lib\site-packages\mysql\connector\django\base.py", line 534, in
__init__
self.ensure_connection()
File "C:\landy\lib\site-packages\django\db\backends\__init__.py", line 133, in
ensure_connection
self.connect()
File "C:\landy\lib\site-packages\django\db\utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\landy\lib\site-packages\django\utils\six.py", line 549, in reraise
raise value.with_traceback(tb)
File "C:\landy\lib\site-packages\django\db\backends\__init__.py", line 133, in
ensure_connection
self.connect()
File "C:\landy\lib\site-packages\django\db\backends\__init__.py", line 122, in
connect
self.connection = self.get_new_connection(conn_params)
File "C:\landy\lib\site-packages\mysql\connector\django\base.py", line 590, in
get_new_connection
cnx = mysql.connector.connect(**conn_params)
File "C:\landy\lib\site-packages\mysql\connector\__init__.py", line 157, in co
nnect
return MySQLConnection(*args, **kwargs)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 122, in
__init__
self.connect(**kwargs)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 431, in
connect
self._open_connection()
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 398, in
_open_connection
self._ssl)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 187, in
_do_auth
self._auth_switch_request(username, password)
File "C:\landy\lib\site-packages\mysql\connector\connection.py", line 224, in
_auth_switch_request
raise errors.get_exception(packet)
django.db.utils.ProgrammingError: (1049, "1049 (42000): Unknown database 'mydb'"
, '42000')
There is a schema named "mydb" in the MySQL workbench.
Any ideas?
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/ca68e107-5b0c-4d2f-ae64-25eed96d2cf4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment