syncdb error with Mysql database on Windows 7

118 views
Skip to first unread message

Daniel Grace

unread,
Sep 24, 2014, 3:23:34 PM9/24/14
to django...@googlegroups.com
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?

Daniel Grace

unread,
Sep 27, 2014, 8:58:05 AM9/27/14
to django...@googlegroups.com
For the record I solved this, I was mistaken there was no "mydb" schema in MySQL.  I created this schema and ran the "syncdb" command without any problems.

olek.russ

unread,
Jan 25, 2015, 3:04:42 AM1/25/15
to django...@googlegroups.com
  I also followed note for create schema  ( have watched https://www.youtube.com/watch?v=EL39BGSUkzw video in addition )  and got success.

Carlos Andre

unread,
Jan 25, 2015, 4:10:38 PM1/25/15
to django...@googlegroups.com
install PyMySQL, after create a user e a databases in mysql terminal;
e.g:1º)create user 'root'@'localhost' identified by 'fish1777';
2º) create database Mydb;
3º) grant all privileges on Mydb.* to 'root'@'localhost' identified by 'fish1777';

use syncdb.

2015-01-25 6:04 GMT-02:00 olek.russ <olek...@gmail.com>:
  I also followed note for create schema  ( have watched https://www.youtube.com/watch?v=EL39BGSUkzw video in addition )  and got success.

--
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...@googlegroups.com.
To post to this group, send email to django...@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/6adc4236-3c88-4a9c-9762-ba29a491bedb%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages