id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
5024	"""Passwd"" is invalid option in MySQL option file; must use ""Password"""	ispivey@…	nobody	"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:[[BR]]
django trunk from svn on Jul 31st[[BR]]
Ubuntu Feisty Fawn[[BR]]
mysql-server 5.0.38-0[[BR]]
mysqldb 1.2.1-p2-4[[BR]]


"		closed	Documentation	dev		fixed	mysql database sprintsept14	sander.dijkhuis@…	Ready for checkin	1	0	0	0	0	0