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