Set mysql password.
Without password how you can access mysql.
See
DATABASES = {
*'default'*: {
*'ENGINE'*: *'django.db.backends.mysql'*,
*'NAME'*: *'hospital'*,
*'USER'*: *'root'*,
*'PASSWORD'*: *'password'*,
*'HOST'*: *'localhost'*,
*'PORT'*: *'3306'*
On Tue, 28 Aug 2018, 5:37 pm Sonali Vighne, <[email protected]> wrote:
>
> I will paste full error and stack trace here.
>
> This is occurred when I am giving “python manage.py migrate” command
>
>
>
> Operations to perform:
>
> Apply all migrations: admin, auth, contenttypes, sessions
>
> Running migrations:
>
> Traceback (most recent call last):
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 83, in _execute*
>
> return self.cursor.execute(sql)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\mysql\base.py",
> line 71, in execute*
>
> return self.cursor.execute(query, args)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 250, in execute*
>
> self.errorhandler(self, exc, value)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
> line 50, in defaulterrorhandler*
>
> raise errorvalue
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 247, in execute*
>
> res = self._query(query)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 411, in _query*
>
> rowcount = self._do_query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 374, in _do_query*
>
> db.query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
> line 277, in query*
>
> _mysql.connection.query(self, query)
>
> _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near '(6) NOT NULL)' at line 1")
>
>
>
> The above exception was the direct cause of the following exception:
>
>
>
> Traceback (most recent call last):
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\recorder.py",
> line 55, in ensure_schema*
>
> editor.create_model(self.Migration)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\base\schema.py",
> line 312, in create_model*
>
> self.execute(sql, params or None)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\base\schema.py",
> line 133, in execute*
>
> cursor.execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 100, in execute*
>
> return super().execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 68, in execute*
>
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._execute)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 77, in _execute_with_wrappers*
>
> return executor(sql, params, many, context)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 85, in _execute*
>
> return self.cursor.execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\utils.py",
> line 89, in __exit__*
>
> raise dj_exc_value.with_traceback(traceback) from exc_value
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
> line 83, in _execute*
>
> return self.cursor.execute(sql)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\mysql\base.py",
> line 71, in execute*
>
> return self.cursor.execute(query, args)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 250, in execute*
>
> self.errorhandler(self, exc, value)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
> line 50, in defaulterrorhandler*
>
> raise errorvalue
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 247, in execute*
>
> res = self._query(query)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 411, in _query*
>
> rowcount = self._do_query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
> line 374, in _do_query*
>
> db.query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
> line 277, in query*
>
> _mysql.connection.query(self, query)
>
> django.db.utils.ProgrammingError: (1064, "You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near '(6) NOT NULL)' at line 1")
>
>
>
> During handling of the above exception, another exception occurred:
>
>
>
> Traceback (most recent call last):
>
> *File "D:\EclipsePython\DjangoMysql\manage.py", line 15, in <module>*
>
> execute_from_command_line(sys.argv)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\__init__.py",
> line 381, in execute_from_command_line*
>
> utility.execute()
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\__init__.py",
> line 375, in execute*
>
> self.fetch_command(subcommand).run_from_argv(self.argv)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py",
> line 316, in run_from_argv*
>
> self.execute(*args, **cmd_options)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py",
> line 353, in execute*
>
> output = self.handle(*args, **options)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py",
> line 83, in wrapped*
>
> res = handle_func(*args, **kwargs)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\commands\migrate.py",
> line 203, in handle*
>
> fake_initial=fake_initial,
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\executor.py",
> line 91, in migrate*
>
> self.recorder.ensure_schema()
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\recorder.py",
> line 57, in ensure_schema*
>
> raise MigrationSchemaMissing("Unable to create the django_migrations
> table (%s)" % exc)
>
> django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create
> the django_migrations table ((1064, "You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near '(6) NOT NULL)' at line 1"))
>
> Finished "*D:\EclipsePython\DjangoMysql\manage.py* migrate" execution.
>
>
>
>
>
>
>
>
>
>
>
> Setting.py
>
>
>
>
>
> INSTALLED_APPS = [
>
> *'django.contrib.admin'*,
>
> *'django.contrib.auth'*,
>
> *'django.contrib.contenttypes'*,
>
> *'django.contrib.sessions'*,
>
> *'django.contrib.messages'*,
>
> *'django.contrib.staticfiles'*,
>
> *'mysqlApp' #this is app created*
>
> ]
>
>
>
>
>
> DATABASES = {
>
> *'default'*: {
>
> *'ENGINE'*: *'django.db.backends.mysql'*,
>
> *'NAME'*: *'hospital'*,
>
> *'USER'*: *'root'*,
>
> *'PASSWORD'*: *''*,
>
> *'HOST'*: *'localhost'*,
>
> *'PORT'*: *'3306'*
>
>
> *models.py*
>
> *from django.db import models*
>
>
> *class Category(models.Model):*
>
> * name = models.CharField(max_length=128, unique=True)*
>
>
> * def __unicode__(self):*
>
> * return self.name <http://self.name>*
>
>
>
> *class Page(models.Model):*
>
> * category = models.ForeignKey(Category, on_delete=models.CASCADE,)*
>
> * title = models.CharField(max_length=128)*
>
> * url = models.URLField()*
>
> * views = models.IntegerField()*
>
>
> * def __unicode__(self):*
>
> * return self.title *
>
> On Tuesday, August 28, 2018 at 4:31:43 PM UTC+5:30, Jason wrote:
>>
>> sounds like you have some bad syntax in your models. can't diagnose any
>> further without the code.
>>
>> For future reference, when you ask for help, try to give all relevant
>> information in your question. All you give here is the error, but nothing
>> about the code that produces it, (the models).
>>
> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/007a5f21-6b96-4dc7-a8b2-41dc3afac8c1%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/007a5f21-6b96-4dc7-a8b2-41dc3afac8c1%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAOh93ndX09s6r0kX8V8diDN0RFQS-E5U61KukxQXc1EPe3aE3A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
