Ok, I got it working. And by working, I mean I got it to sync, I imported
the database.json into mysql, and when I runserver everything is there as
it should be.
So, many thanks to all my gracious and more senior django users for your
patient guidance and assistance.
A note to all newbies who may be following along and reading this days,
weeks, and years from now: Do yourself a favor and READ the documentation,
DON'T just scan it looking for a quick answer. You are bound to miss
something important.
Turns out that for all my struggling with a db name for mysql, all that
came after I had changed the settings.py to mysql. In other words, I didn't
think to go back and put the name I came up with, django_1, in settings.py.
But that was not enough. Now I had to also take off the
'--database=django_1' as that was unnecessary and maybe confusing django.
Once I did that, it all worked.
But don't worry, I'm sure I'll be back soon enough with some other
issues..... :-)
On Wed, Feb 5, 2014 at 7:44 PM, Ariel E. Isidro <ar...@asherama.com> wrote:
> 1. before exiting mysql, you should grant permission to a user,i.e.
> grant all privileges on django_1.* to username@'localhost' identified by
> 'userpassword'
> replace username, userpassword with your own
> 2. exit mysql console
> 3. modify settings.py to add your username, password, host (localhost),
> and port (3306)
> 4. run python manage.py syncdb
>
>
> On Thu, Feb 6, 2014 at 7:52 AM, Drew Ferguson <d...@afccommercial.co.uk>wrote:
>
>> Hi
>>
>> Just like SQLlite, you tell Django where the MySQL database is in
>> settings.py
>>
>> At the top you should have something like
>>
>> DATABASES = {
>> 'default': {
>> 'ENGINE': 'django.db.backends.mysql',
>> 'NAME': 'django_1', # Or path to database file if using sqlite3.
>> # 'USER': '',
>> # 'PASSWORD': '',
>> # 'HOST': '', # Empty for localhost
>> # 'PORT': '', # Set to empty string for default.
>> }
>> }
>>
>>
>> On Wed, 5 Feb 2014 16:38:59 -0600
>> Malik Rumi <malik.a.r...@gmail.com> wrote:
>>
>> > mysql> CREATE DATABASE django_1;
>> >
>> > Query OK, 1 row affected (0.24 sec)
>> >
>> > mysql> SHOW DATABASES;
>> >
>> > +--------------------+
>> >
>> > | Database |
>> >
>> > +--------------------+
>> >
>> > | information_schema |
>> >
>> > | django_1 |
>> >
>> > | mysql |
>> >
>> > | performance_schema |
>> >
>> > | test |
>> >
>> > +--------------------+
>> >
>> > 5 rows in set (0.31 sec)
>> --
>> Drew Ferguson
>> AFC Commercial
>> http://www.afccommercial.co.uk
>>
>> --
>>
>> 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/20140205235235.53a238b1%40blacktav.fergiesontour.org
>> .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> *Ariel E. Isidro*
> Backup your important files, click here <http://db.tt/7cLLR7V/>
>
> DISCLAIMER: This message is for the designated recipient only and may
> contain confidential and/or privileged information. If you have received it
> in error, please delete it and advise the sender immediately. You should
> not copy or use it for any other purpose, nor disclose its contents to any
> other person.
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Django users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/django-users/zpNqaA2Fji8/unsubscribe.
> To unsubscribe from this group and all its topics, 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/CAECOjiaW4jswaift33tcdTJc5DBwFYJhRKyZPmhn7FToC8QUvw%40mail.gmail.com
> .
>
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
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/CAKd6oBxrfndqFf0t7vOsXrnTzWP5_UMYbeZr3RYvdri2jSu%3Dug%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
