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.
