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 -~----------~----~----~----~------~----~------~--~---
