YES) on mysql admin MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu"
--wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Please provide the output of the below query. Select user, host, password from mysql.user; Thanks Vikas Shukla Mail Sent from my Windows Phone From: Reindl Harald Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38 To: mysql@lists.mysql.com Subject: Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin *your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that= host* http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html Am 13.01.2014 20:38, schrieb =C3=89rico: > no connections outside command line are being accepted . I have connected > through command line , but not using eclipse for example ... it gets the > same error from the web app >=20 > my apache and pages are in the same computer that mysql >=20 > I am not getting password issues.. otherwise I would not connect through > command line >=20 > 2014/1/13 shawn l.green <shawn.l.gr...@oracle.com> >=20 >> On 1/13/2014 1:49 PM, =C3=89rico wrote: >> >>> Hi >>> >>> didn't work >>> >>> look ... isn't this something related to this : >>> >>> are you using "localhost" or "127.0.0.1" in the web-application >>> root@localhost !=3D root@127.0.0.1 =3D different users >>> >>> localhost: Unix-Socket >>> 127.0.0.1: TCP >>> >>> ... >>> >>> since I am not able to stabilsh a connection even with using eclipse ..= . >>> >>> my /etc/hosts file : >>> >>> ## >>> 127.0.0.1 localhost >>> 255.255.255.255 broadcasthost >>> ::1 localhost >>> #fe80::1%lo0 localhost >>> 127.0.0.1 ericomtxmacbookpro.local >>> #127.0.0.1 mysqld >>> >>> >> The thing to remember is that 'localhost' or '127.0.0.1' is where the >> server believes the connection is coming from. The password you must be >> using in your client connection attempt must match the one used on the >> server for the mysql user 'root'@'localhost' or you will not authenticat= e. >> >> You also need to remember that if your .php page is on a different >> machine, it is not connecting to the same mysqld that you have running i= n >> your development machine (your personal environment). Your .PHP page is >> trying to connect to the one running on its host machine. That user 'roo= t' >> may have an entirely different password. >> >> Your programs are connecting fine. If they didn't you would get a >> different message. They are failing to authenticate which means that the >> mysqld they are connecting to does not recognize the password you are us= ing >> for the account you are trying to authenticate as. --wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
