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]
> <javascript:>> 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] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> 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.
For more options, visit https://groups.google.com/d/optout.
