I followed the instructions in the tutorial and at http://www.djangoproject.com/documentation/databases/ for configuring MySQL to work with Django using an option file. When trying to start the server with 'python manage.py runserver', the server threw an exception. The root exception was:
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")
When I changed the password line in my option file from "passwd = XXX" to "password = XXX", the error disappeared and I was able to start the server. This was strange, because when running the mysql client from the shell I can use either option "passwd" or "password" to login. I've pasted the config files below with the passwords blanked out. Software versions below config files.
#settings.py
...
DATABASE_ENGINE = 'mysql'
DATABASE_OPTIONS = {
"init_command": "SET storage_engine=INNODB",
'read_default_file': '/home/ispivey/Code/django/mysql.cnf'
}
...
#mysql.cnf
[client]
database = testdb
user = root
passwd = XXXXX
default-character-set = utf8
Using:
django trunk from svn on Jul 31st
Ubuntu Feisty Fawn
mysql-server 5.0.38-0
mysqldb 1.2.1-p2-4
