Basically your database setting should look something like this (depending on what version of django you are using, more recent ones have a slightly new syntax but still essentially the same): DATABASE_ENGINE = 'mysql' # 'postgresql', 'mysql', 'sqlite3' or 'ado_mssql'. # The following variables should be configured in your local_settings.py file DATABASE_NAME = 'name_of_mysql_database' # Or path to database file if using sqlite3. DATABASE_USER = 'mysql_username' # Not used with sqlite3. DATABASE_PASSWORD = 'mysql_username_password' # Not used with sqlite3. DATABASE_HOST = '' # Set to empty string for localhost. Not used with sqlite3. DATABASE_PORT = '' # Leave blank for default/standard settings
You have to create a database in mysql (generally this can be done through some sort of web interface but it also is possible to do it at the command line) and a user who has access to the database. Sqlite is a database in a file, in this case simple.db, mysql on the other hand relies no a mysql database server. Generally it is easy to create mysql databases through most hosts. -Josh On Dec 6, 10:22 am, "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%[email protected]> > > . > > 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.
