Socket not found

Socket not found

am 09.10.2011 10:21:18 von Peter Schrock

--000e0cd1ff3ecd2e9f04aed95b5d
Content-Type: text/plain; charset=ISO-8859-1

I just loaded and built three different versions of mysql and all three
versions have given me the same results. When trying to change the password
to root, this is what I get:

../mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Help please.

Peter

--000e0cd1ff3ecd2e9f04aed95b5d--

Re:Socket not found

am 09.10.2011 10:51:16 von Andrew Moore

--000e0cd47d5af99c7f04aed9c630
Content-Type: text/plain; charset=ISO-8859-1

Hey Peter,

2 options;

Check the socket key-value in the my.cnf file under the client section.
Explicitly tell mysqladmin what one to use with the relevant cmd line
option. See the documentation for syntax.

Hth

Andrew
On 9 Oct 2011 09:21, "Peter Schrock" wrote:

> I just loaded and built three different versions of mysql and all three
> versions have given me the same results. When trying to change the password
> to root, this is what I get:
>
> ./mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
> (2)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
>
> Help please.
>
> Peter
>

--000e0cd47d5af99c7f04aed9c630--

Re: Socket not found

am 09.10.2011 11:00:32 von javad bakhshi

--2132688063-852007059-1318150832=:40509
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi, I had the same problem recently restart the server so it can creat=
e your socket again and it should be all right.   Best regards,=0A=
Javad ________________________________=0AFrom: Andrew Moore omydna@gmail.com>=0ATo: Peter Schrock =0ACc: mysql=
@lists.mysql.com=0ASent: Sunday, October 9, 2011 10:51 AM=0ASubject: Re:Soc=
ket not found Hey Peter, 2 options; Check the socket key-val=
ue in the my.cnf file under the client section.=0AExplicitly tell mysqladmi=
n what one to use with the relevant cmd line=0Aoption. See the documentatio=
n for syntax. Hth Andrew=0AOn 9 Oct 2011 09:21, "Peter Schrock" <=
peter.schrock@gmail.com> wrote: > I just loaded and built three differ=
ent versions of mysql and all three=0A> versions have given me the same res=
ults. When trying to change the password=0A> to root, this is what I get:=
=0A>=0A> ./mysqladmin: connect to server at 'localhost' failed=0A> error: '=
Can't connect to local MySQL server through socket=0A> '/tmp/mysql.sock'=0A=
> (2)'=0A> Check that mysqld is running and that the socket: '/tmp/mysql.so=
ck' exists!=0A>=0A> Help please.=0A>=0A> Peter=0A>
--2132688063-852007059-1318150832=:40509--

Re: Socket not found

am 09.10.2011 11:08:44 von Reindl Harald

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



Am 09.10.2011 11:00, schrieb javad bakhshi:
> Hi,
>=20
> I had the same problem recently restart the server so it can create you=
r socket=20
> again and it should be all right

/tmp/ is a really bad location because tmpwatch is killing old files ther=
e
and a mysqld usually runs for weeks - no idea why this is the upstream
default and why mysqld does not recognize this and restore the file

fedora is using /var/lib/mysql/mysql.sock as configure-option and all
applications like php, dbmail... are also compiled fpr this location


--------------enig04F1492FF246EAA2FC14927A
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/

iEYEARECAAYFAk6RZJwACgkQhmBjz394AnlsNACgjKocjzyR82SZ5JEIQ0QT qzz5
R7wAnRC0Sbrxz5i1HbBAXLEbh31nu4vz
=BFeI
-----END PGP SIGNATURE-----

--------------enig04F1492FF246EAA2FC14927A--