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+unsubscr...@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.
