Re: problems connecting with Mysql

2008-10-20 Thread pantagruel

Thanks!

On Oct 20, 4:37 pm, "Karen Tracey" <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 20, 2008 at 10:23 AM, pantagruel <[EMAIL PROTECTED]>wrote:
>
>
>
>
>
> > Hi,
>
> > I can connect via the mysql console to the database, my service is
> > running.  however when I try to do syncdb from Django I get:
>
> > _mysql_exceptions.OperationalError: (2003,"Can't connect to MySQL
> > server on 'localhost' (10061)")
>
> > My current test Django settings.py says:
>
> > DATABASE_ENGINE = 'mysql'
> > DATABASE_NAME = 'dbname'
> > DATABASE_USER = 'root'            .
> > DATABASE_PASSWORD = 'thepassword'
> > DATABASE_HOST = ''
> > DATABASE_PORT = ''
>
> > (have not edited any of the rest because it should not be relevant as
> > I understand it - although time zone is wrong)
>
> > when I use the mysql console I do
>
> > mysql -u root -p
> > pass: thepassword
>
> > then
> > connect dbname
>
> > then status which tells me:
> > (some things left out as they seemed especially non-essential)
>
> > Current Database: dbname
> > Current User: [EMAIL PROTECTED]
> > Server Version: 5.0.67-community-nt MySQL Community Edition (GPL)
> > Protocol Version: 10
> > Connection: Named pipe: mysql
>
> mysql connected via a named pipe, not a TCP/IP connection.  For Django you
> need to use TCP/IP.  Run through the config wizard and where there's a
> checkbox for "Enable TCP/IP" you want to check it.
>
> Karen
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



problems connecting with Mysql

2008-10-20 Thread pantagruel

Hi,

I can connect via the mysql console to the database, my service is
running.  however when I try to do syncdb from Django I get:

_mysql_exceptions.OperationalError: (2003,"Can't connect to MySQL
server on 'localhost' (10061)")

My current test Django settings.py says:

DATABASE_ENGINE = 'mysql'
DATABASE_NAME = 'dbname'
DATABASE_USER = 'root'.
DATABASE_PASSWORD = 'thepassword'
DATABASE_HOST = ''
DATABASE_PORT = ''

(have not edited any of the rest because it should not be relevant as
I understand it - although time zone is wrong)

when I use the mysql console I do

mysql -u root -p
pass: thepassword

then
connect dbname

then status which tells me:
(some things left out as they seemed especially non-essential)

Current Database: dbname
Current User: [EMAIL PROTECTED]
Server Version: 5.0.67-community-nt MySQL Community Edition (GPL)
Protocol Version: 10
Connection: Named pipe: mysql
Server Characterset: utf8 (all characters set to utf8)

I am running on Windows currently.

Best Regards,
Bryan Rasmussen


--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---