Re: mysqldb help! Can't connect to MySQL server error...

mdsmoke, do yourself a favor. You have exposed your password and the user name of your db; change your password.  Also, best practices for using databases, is create an administrative login insead of using 'root'.  Its much easier for a nasty malicious person or organisation to guess (root) than it is for them to guess a random 'user name' 

As far as your topic issue, I'm not sure.  I have the same issue.  I'll let you know when I figure this out too.  

On Sunday, August 2, 2009 9:16:49 PM UTC-4, mdsmoker wrote:

when running python manage.py syncdb I got the following errors...

C:\DJANGO~1\mysite>python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "c:\django-trunk\django\core\management\__init__.py", line 362,
in execut
e_manager
    utility.execute()
  File "c:\django-trunk\django\core\management\__init__.py", line 303,
in execut
e
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "c:\django-trunk\django\core\management\base.py", line 195, in
run_from_a
rgv
    self.execute(*args, **options.__dict__)
  File "c:\django-trunk\django\core\management\base.py", line 221, in
execute
    self.validate()
  File "c:\django-trunk\django\core\management\base.py", line 249, in
validate
    num_errors = get_validation_errors(s, app)
  File "c:\django-trunk\django\core\management\validation.py", line
67, in get_v
alidation_errors
    connection.validation.validate_field(e, opts, f)
  File "c:\django-trunk\django\db\backends\mysql\validation.py", line
15, in val
idate_field
    db_version = connection.get_server_version()
  File "c:\django-trunk\django\db\backends\mysql\base.py", line 297,
in get_serv
er_version
    self.cursor()
  File "c:\django-trunk\django\db\backends\__init__.py", line 81, in
cursor
    cursor = self._cursor()
  File "c:\django-trunk\django\db\backends\mysql\base.py", line 281,
in _cursor
    self.connection = Database.connect(**kwargs)
  File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74,
in Connect
    return Connection(*args, **kwargs)
  File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line
170, in __in
it__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL
server on 'lo
calhost' (10061)")

I have mysqldb 1.2.2 installed w/out errors.  I think I'm just missing
something pretty simple.  If it helps, this is what my settings.py
looks like...

DATABASE_ENGINE = 'mysql'           # 'postgresql_psycopg2',
'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = 'mysitedb'             # Or path to database file if
using sqlite3.
DATABASE_USER = 'root'             # Not used with sqlite3.
DATABASE_PASSWORD = 'blue33'         # Not used with sqlite3.
DATABASE_HOST = ''             # Set to empty string for localhost.
Not used with sqlite3.
DATABASE_PORT = '3036'             # Set to empty string for default.
Not used with sqlite3.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/1OFQu6KwVwMJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.