Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #27100

Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host

Path csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path <xs.nepaul@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.008
X-Spam-Evidence '*H*': 0.98; '*S*': 0.00; 'exist.': 0.09; 'to:addr:comp.lang.python': 0.09; 'wrong,': 0.09; 'cc:addr:python- list': 0.10; 'suggest': 0.11; '"unknown': 0.16; '"user': 0.16; "'test',": 0.16; 'wrote:': 0.17; 'file.': 0.20; 'trying': 0.21; 'import': 0.21; 'cc:2**0': 0.23; 'work.': 0.23; 'cc:no real name:2**0': 0.24; 'host': 0.24; 'cc:addr:python.org': 0.25; 'header:In-Reply-To:1': 0.25; 'header:User-Agent:1': 0.26; "doesn't": 0.28; 'subject:: (': 0.29; "i'm": 0.29; "skip:' 10": 0.30; 'skip:_ 30': 0.32; 'knowledge': 0.33; 'code:': 0.33; 'received:google.com': 0.34; 'server': 0.35; 'list': 0.35; 'received:209.85': 0.35; 'but': 0.36; 'data.': 0.36; 'xml': 0.37; 'received:209': 0.37; 'subject:: ': 0.38; 'mark': 0.38; 'sure': 0.38; 'more': 0.63; 'subject:skip:_ 30': 0.84
Newsgroups comp.lang.python
Date Wed, 15 Aug 2012 07:53:50 -0700 (PDT)
In-Reply-To <mailman.3312.1345040537.4697.python-list@python.org>
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=113.106.106.98; posting-account=gm5T0QoAAADsrQB6lKn4dmNQxJ9E7E9m
References <6a5212e3-4ff9-4cec-afe5-8b81e231eb67@googlegroups.com> <mailman.3312.1345040537.4697.python-list@python.org>
User-Agent G2/1.0
X-Google-Web-Client true
X-Google-IP 113.106.106.98
MIME-Version 1.0
Subject Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host
From nepaul <xs.nepaul@gmail.com>
To comp.lang.python@googlegroups.com
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding quoted-printable
Cc python-list@python.org
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.12
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Message-ID <mailman.3315.1345042433.4697.python-list@python.org> (permalink)
Lines 46
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1345042433 news.xs4all.nl 6926 [2001:888:2000:d::a6]:34413
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:27100

Show key headers only | View raw

在 2012年8月15日星期三UTC+8下午10时23分24秒，Mark Lawrence写道：
> On 15/08/2012 14:30, nepaul wrote:
> 
> > The code:
> 
> > import MySQLDB
> 
> > strCmd = "user = 'root', passwd = '123456', db = 'test', host = 'localhost'"
> 
> >
> 
> > _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host 'user = 'root', passwd = '123456', db = 'test', host = 'localhost'' (11004)")
> 
> >
> 
> 
> 
> My highly paid team of consultants suggest that you're trying to connect 
> 
> to a MySQL server host that doesn't exist.  However I'm sure that people 
> 
> on this list with more knowledge of MySQLDB than my consultants will be 
> 
> able to give you more detailed data.
> 
> 
> 
> -- 
> 
> Cheers.
> 
> 
> 
> Mark Lawrence.

if i use MySQLdb.connect(strCmd) -> wrong, but if use MySQLdb.connect(user = 'root', passwd = '123456', db = 'test', host = 'localhost'),it work. and the strCmd is read from a xml file.

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

_mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 06:30 -0700
  Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host Mark Lawrence <breamoreboy@yahoo.co.uk> - 2012-08-15 15:23 +0100
    Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 07:53 -0700
    Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 07:53 -0700
  Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host Hans Mulder <hansmu@xs4all.nl> - 2012-08-15 17:02 +0200
    Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host Alain Ketterlin <alain@dpt-info.u-strasbg.fr> - 2012-08-15 17:22 +0200
      Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 09:50 -0700
      Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-08-15 12:58 -0400
        Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 18:52 -0700
        Re: _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host nepaul <xs.nepaul@gmail.com> - 2012-08-15 18:52 -0700

csiph-web