Path: csiph.com!usenet.pasdenom.info!dedibox.gegeweb.org!gegeweb.eu!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Wed, 15 Aug 2012 18:52:29 -0700 (PDT)
In-Reply-To: <mailman.3320.1345049888.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> <502bba24$0$6979$e4fe514c@news2.news.xs4all.nl> <878vdgp4c6.fsf@dpt-info.u-strasbg.fr> <mailman.3320.1345049888.4697.python-list@python.org>
User-Agent: G2/1.0
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
Precedence: list
Message-ID: <mailman.3338.1345082589.4697.python-list@python.org>
Lines: 80
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:27134

=E5=9C=A8 2012=E5=B9=B48=E6=9C=8816=E6=97=A5=E6=98=9F=E6=9C=9F=E5=9B=9BUTC+=
8=E4=B8=8A=E5=8D=8812=E6=97=B658=E5=88=8607=E7=A7=92=EF=BC=8CDennis Lee Bie=
ber=E5=86=99=E9=81=93=EF=BC=9A
> On Wed, 15 Aug 2012 17:22:49 +0200, Alain Ketterlin
>=20
> <alain@dpt-info.u-strasbg.fr> declaimed the following in
>=20
> gmane.comp.python.general:
>=20
>=20
>=20
> > Hans Mulder <hansmu@xs4all.nl> writes:
>=20
> >=20
>=20
Right=EF=BC=81
> > > On 15/08/12 15:30:26, nepaul wrote:
>=20
> > >> The code:
>=20
> > >> import MySQLDB
>=20
> > >> strCmd =3D "user =3D 'root', passwd =3D '123456', db =3D 'test', hos=
t =3D 'localhost'"
>=20
> > >>=20
>=20
> > >>=20
>=20
> > >>=20
>=20
> > >> _mysql_exceptions.OperationalError: (2005, "Unknown MySQL server hos=
t 'user =3D 'root',
>=20
> > >> passwd =3D '123456', db =3D 'test', host =3D 'localhost'' (11004)")
>=20
> > >
>=20
> > > This message means that the MySQL connector cannot find 'localhost'.
>=20
> >=20
>=20
> > No, it means that connect received a single string "user =3D 'root'..."
>=20
> > instead of a set of individual keyword parameters, and took the whole
>=20
> > string to be the name of the host (its first parameter). Of course,
>=20
> > there is no host with such a name.
>=20
> >=20
>=20
> > The solution is to parse the string into individual values, and pass
>=20
> > these in the correct order.
>=20
>=20
>=20
> 	MySQLdb code itself recommends to always use keyword parameters, so
>=20
> the order shouldn't be significant... (and when one sees the list of
>=20
> optional keywords, using null commas to space positional arguments would
>=20
> be insane)
>=20
>=20
>=20
> 	Parsing that string into separate fields (preferably a dictionary so
>=20
> **conectitems could be used) OTOH is critical.
>=20
>=20
>=20
> --=20
>=20
> 	Wulfraed                 Dennis Lee Bieber         AF6VN
>=20
>         wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/