Hmm, placed the above setting in local_settings.py for name, user and password but not I have nothing on the web pages...it's as though i have a brand new app... O.o
On Dec 6, 1:59 pm, jc <[email protected]> wrote: > In my settings.py file I have > > DATABASE_ENGINE = 'mysql' # 'postgresql', 'mysql', 'sqlite3' > or 'ado_mssql'. > # The following variables should be configured in your > local_settings.py file > DATABASE_NAME = 'mydatabasename' # Or path to database > file if using sqlite3. > DATABASE_USER = 'myusername' # Not used with sqlite3. > DATABASE_PASSWORD = 'mypassword' # Not used with sqlite3. > DATABASE_HOST = '' # Set to empty string for localhost. > Not used with sqlite3. > DATABASE_PORT = '' # Set to empty string for default. Not > used with sqlite3. > > I also went over to my local_settings.py file and changed: > DATABASE_NAME = os.path.join(DIRNAME, 'mydatabasename.db') > > ran python manage.py syncdb and I got: > _mysql_exceptions.OperationalError: (1044, "Access denied for user > 'myusername'@'localhost' to database '/home/j3/satchmo/store/ > mydatabasename.db'") > > j. > > On Dec 6, 1:22 pm, "Brian O'Connor" <[email protected]> wrote: > > > > > > > > > i think you're still using the database name simple.db > > > that's generally not how it works for mysql. you usually have a server, > > with a username and a password. > > > On Mon, Dec 6, 2010 at 1:13 PM, jc <[email protected]> wrote: > > > I tried to dump the sqlite data, change settings.py to use my MySQL db > > > then run python manage.py syncdb but I keep getting this error: > > > _mysql_exceptions.OperationalError: (1044, "Access denied for user > > > 'username'@'localhost' to database '/home/username/satchmo/store/ > > > simple.db'") > > > > So I was thinking of simply using MySQL by default and bypass the > > > migrating issue. Is this possible? > > > > When going some of the Django tutorials, all I did was syncdb in the > > > beginning and I've never had a problem so I'm not sure what my issue > > > is here. > > > > thanks again for the help, > > > j. > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Satchmo users" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<satchmo-users%2bunsubscr...@goog > > > legroups.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/satchmo-users?hl=en. > > > -- > > Brian O'Connor -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
