You seem to be accessing 'mygodb' from your django config, for which so...@localhost might not have permissions. Is this the case?
Sincerely, Saketh On Thu, Jul 23, 2009 at 12:42 PM, Sonal Breed <sonal.br...@gmail.com> wrote: > > Hi all, > > I am migrating my project from sqlite3 to mysql. > Installed mysql and mysqldb on my machine and executed following: > > mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 > Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> CREATE DATABASE django_db; > Query OK, 1 row affected (0.01 sec) > > mysql> GRANT ALL ON django_db.* TO 'sonal'@'localhost' IDENTIFIED BY > 'sonal'; > Query OK, 0 rows affected (0.03 sec) > > mysql> quit > Bye > > In settings.py > DATABASE_ENGINE = 'mysql' # 'postgresql_psycopg2', > 'postgresql', 'mysql', 'sqlite3' or 'ado_mssql'. > DATABASE_NAME = 'mygodb' # Or path to database file if > using sqlite3. > DATABASE_USER = 'sonal ' # Not used with sqlite3. > DATABASE_PASSWORD = 'sonal' # 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. > > user sonal is already created in mysql with password sonal. > > And the error message is > > /var/lib/python-support/python2.6/MySQLdb/__init__.py:34: > DeprecationWarning: the sets module is deprecated > from sets import ImmutableSet > ... > ... > _mysql_exceptions.OperationalError: (1045, "Access denied for user > 'sonal '@'localhost' (using password: YES)") > > > Thanks in advance, > Sonal > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
