This password doesn't belong to mysql. This belongs to your database 'hospital'.
On Wed, Aug 29, 2018 at 10:07 AM Sonali Vighne <[email protected]> wrote: > I have not set password to My MySQL server during installation > > On Tuesday, August 28, 2018 at 5:42:30 PM UTC+5:30, Mohammad Aqib wrote: >> >> 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/8fbc66ec-7a5e-44d7-afbc-96394037a228%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/8fbc66ec-7a5e-44d7-afbc-96394037a228%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Mohd Aqib Software Engineer 9873141865 -- 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/CAOh93ne%3DgmcGpBcRKnRQCyfzDQ%3DZa3xC2R3pe0sg3LSKJvOWZg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
