From: Reindl Harald
Date: November 17 2011 2:11pm
Subject: Re: Can't run MySQL under Cygwin : connect to server at 'localhost'
 failed (only when using password)
List-Archive: http://lists.mysql.com/mysql/226317
Message-Id: <4EC515FD.9090007@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig62D7AA51F56CBAB1EDCC1999"

--------------enig62D7AA51F56CBAB1EDCC1999
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 17.11.2011 15:02, schrieb Franck Houssen:
> $ mysql -u dummy -p (when I hit "return" as a password =3D> connection =
OK)
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> mysql> show tables;
> ERROR 1046 (3D000): No database selected
> mysql> quit
> Bye
> =20
> $ mysql -u dummy -p (when I type a real password : dummy, YES... or any=
thing else)
> ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using p=
assword: YES) $=20

well this is not a connection problem
your permissions in the mysql-user-tables are wrong

remember that "localhost" is not the same as "127.0.0.1" and acess is
granted by user/host/password combinations or not since you have
in all permissions records a field for "host"



--------------enig62D7AA51F56CBAB1EDCC1999
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7FFf0ACgkQhmBjz394Anmj1QCeKdP9kwqQX2H+o1PedOidNO0t
jmIAn3w5Yv3wEHCPOyzxRImurWVsrNP3
=FYrD
-----END PGP SIGNATURE-----

--------------enig62D7AA51F56CBAB1EDCC1999--