Can"t connect to MySQL server on "127.0.0.1" (111)

Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:10:25 von xPol

I have been using my local dictionary for years, accessing from web browser,
pointing to http://localhost:9000/

Probably my fault, since i have been tinkering a little with my settings. As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)

Any ideas, what to check?

I am using linux/opensuse 11.4

Thank you
----p


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:14:19 von Reindl Harald

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

Did you make any change in the my.cnf?
What does "netstat --numeric-hosts --notrim --programs -u -t" say?
What is the content of your my.cnf?

Am 02.04.2011 17:10, schrieb xPol:
> I have been using my local dictionary for years, accessing from web bro=
wser,=20
> pointing to http://localhost:9000/
>=20
> Probably my fault, since i have been tinkering a little with my setting=
s. As=20
> i try to connect, i get=20
> Can't connect to MySQL server on '127.0.0.1' (111)
>=20
> Any ideas, what to check?
>=20
> I am using linux/opensuse 11.4


--------------enig3BA02EC4C2EDDB4A974E6395
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 Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2XPUsACgkQhmBjz394AnkUngCfaFKAbGBvC5YOstTJtyTq bECL
KKEAn1C96h+jcUuDhITbQ5OXYNxEk3UA
=xUGm
-----END PGP SIGNATURE-----

--------------enig3BA02EC4C2EDDB4A974E6395--

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:14:21 von Andrew Moore

--00504502cb2825d83a049ff0fbb4
Content-Type: text/plain; charset=ISO-8859-1

I think you'll need to give us a bit more to go on. I presume this is a web
based app?

What have you changed? Has the MySQL daemon stopped? What have you changed?


On Sat, Apr 2, 2011 at 4:10 PM, xPol wrote:

> I have been using my local dictionary for years, accessing from web
> browser,
> pointing to http://localhost:9000/
>
> Probably my fault, since i have been tinkering a little with my settings.
> As
> i try to connect, i get
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> Any ideas, what to check?
>
> I am using linux/opensuse 11.4
>
> Thank you
> ----p
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomydna@gmail.com
>
>

--00504502cb2825d83a049ff0fbb4--

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:31:58 von xPol

Andrew Moore wrote:

> I think you'll need to give us a bit more to go on. I presume this is a
> web based app?

yes

>
> What have you changed? Has the MySQL daemon stopped? What have you
> changed?

from 'ps' i get
3545 0.0 0.1 194816 3292 ? Sl 13:58 0:08 /usr/sbin/mysqld --
defaults-file=/home/xpol/.local/share/akonadi//mysql.conf --
datadir=/home/xpol/.local/share/akonadi/db_data/ --
socket=/home/xpol/.local/share/akonadi/socket-ambi.site/mysq l.socket

So the demon appears to be running
I do not think mysql conf files have been changed by me


thank you

--p


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:36:08 von xPol

Reindl Harald wrote:

> Did you make any change in the my.cnf?
> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
> What is the content of your my.cnf?
>

Here incluede

thank you
----p

--
(xpol) % netstat --numeric-hosts --notrim --programs -u -t
~ (17:32-Sat 2)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
PID/Program name
tcp 0 0 10.121.243.241:38315 74.125.77.109:smtp
TIME_WAIT -
tcp 0 0 127.0.0.1:50793 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 127.0.0.1:57336 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 10.121.243.241:53924 74.125.232.152:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:53925 74.125.232.152:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:53894 74.125.232.152:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:35673 209.85.227.189:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:35672 209.85.227.189:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:48554 209.85.149.105:www-http
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:35666 209.85.227.189:https
TIME_WAIT -
tcp 0 0 10.121.243.241:35667 209.85.227.189:https
TIME_WAIT -
tcp 0 0 10.121.243.241:53926 74.125.232.152:https
ESTABLISHED 6252/firefox
tcp 0 0 127.0.0.1:52722 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 127.0.0.1:48856 127.0.0.1:52722
ESTABLISHED 6767/GoogleTalkPlug
tcp 0 0 127.0.0.1:48856 127.0.0.1:50793
ESTABLISHED 6767/GoogleTalkPlug
tcp 0 0 127.0.0.1:48856 127.0.0.1:57336
ESTABLISHED 6767/GoogleTalkPlug
tcp 0 0 10.121.243.241:54324 80.91.229.10:nntp
ESTABLISHED 11402/knodeo10783.s

---
(xpol) % cat /mnt/etc/my.cnf | grep -v "^#"
~ (17:34-Sat 2)

[client]
port = 3306
socket = /var/run/mysql/mysql.sock


[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
datadir = /var/lib/mysql
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M


log-bin=mysql-bin

binlog_format=mixed

server-id = 1




[safe_mysqld]
log-error = /var/log/mysql/mysqld.log
socket = /var/run/mysql/mysql.sock

!include_dir /etc/mysql

[mysqldump]
socket = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log






-----


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 17:51:07 von Reindl Harald

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

please do not only post outputs, read them and try to understand
before press send - "not all processes could be identified, non-owned pro=
cess
info will not be shown, you would have to be root to see it all." in
the ouptput says that all afterwards is useless

"netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the mac=
hine
where mysql is running! alterante: "telnet 127.0.0.1 3306"

"/mnt/etc/my.cnf" is really your active mysql-config?
normally "/etc/my.cnf" is used, even if /etc/ is a own
disk/partition you should never mount it as /mnt/etc/
and managing with symlinks - mount it directly to /etc

i would assume something like "skip-networking" in your
config if connection fails

anyways this mysql-config ma contain some includes
because the line "!include_dir /etc/mysql"

Am 02.04.2011 17:36, schrieb xPol:
> Reindl Harald wrote:
>=20
>> Did you make any change in the my.cnf?
>> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
>> What is the content of your my.cnf?
>>
>=20
> Here incluede
>=20
> thank you=20
> ----p
>=20
> --
> (xpol) % netstat --numeric-hosts --notrim --programs -u -t =
=20
> ~ (17:32-Sat 2)=20
> (Not all processes could be identified, non-owned process info
> will not be shown, you would have to be root to see it all.)
> Active Internet connections (w/o servers)
> Proto Recv-Q Send-Q Local Address Foreign Address Sta=
te =20
> PID/Program name =20
> tcp 0 0 10.121.243.241:38315 74.125.77.109:smtp =20
> TIME_WAIT - =20
> tcp 0 0 127.0.0.1:50793 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 127.0.0.1:57336 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 10.121.243.241:53924 74.125.232.152:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:53925 74.125.232.152:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:53894 74.125.232.152:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:35673 209.85.227.189:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:35672 209.85.227.189:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:48554 209.85.149.105:www-http=20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:35666 209.85.227.189:https =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:35667 209.85.227.189:https =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:53926 74.125.232.152:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 127.0.0.1:52722 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:52722 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:50793 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:57336 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
> tcp 0 0 10.121.243.241:54324 80.91.229.10:nntp =20
> ESTABLISHED 11402/knodeo10783.s=20
>=20
> ---
> (xpol) % cat /mnt/etc/my.cnf | grep -v "^#" =
=20
> ~ (17:34-Sat 2)=20
>=20
> [client]
> port =3D 3306
> socket =3D /var/run/mysql/mysql.sock
>=20
>=20
> [mysqld]
> port =3D 3306
> socket =3D /var/run/mysql/mysql.sock
> datadir =3D /var/lib/mysql
> skip-locking
> key_buffer_size =3D 16M
> max_allowed_packet =3D 1M
> table_open_cache =3D 64
> sort_buffer_size =3D 512K
> net_buffer_length =3D 8K
> read_buffer_size =3D 256K
> read_rnd_buffer_size =3D 512K
> myisam_sort_buffer_size =3D 8M
>=20
>=20
> log-bin=3Dmysql-bin
>=20
> binlog_format=3Dmixed
>=20
> server-id =3D 1
>=20
>=20
>=20
>=20
> [safe_mysqld]
> log-error =3D /var/log/mysql/mysqld.log
> socket =3D /var/run/mysql/mysql.sock
>=20
> !include_dir /etc/mysql
>=20
> [mysqldump]
> socket =3D /var/run/mysql/mysql.sock
> quick
> max_allowed_packet =3D 16M
>=20
> [mysql]
> no-auto-rehash
>=20
> [myisamchk]
> key_buffer_size =3D 20M
> sort_buffer_size =3D 20M
> read_buffer =3D 2M
> write_buffer =3D 2M
>=20
> [mysqlhotcopy]
> interactive-timeout
>=20
> [mysqld_multi]
> mysqld =3D /usr/bin/mysqld_safe
> mysqladmin =3D /usr/bin/mysqladmin
> log =3D /var/log/mysqld_multi.log
>=20
>=20
>=20
>=20
>=20
>=20
> -----
>=20
>=20

--=20

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


--------------enig9D137438794FF6D5446D74FA
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 Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2XResACgkQhmBjz394AnlngwCgmljA1jSEjKfMAS/XQkAK iEMF
bmwAoJUuUcUXVVtt9Q5k87vqJDDRyr5c
=xRAE
-----END PGP SIGNATURE-----

--------------enig9D137438794FF6D5446D74FA--

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 18:21:14 von xPol

Reindl Harald wrote:

> please do not only post outputs, read them and try to understand
> before press send - "not all processes could be identified, non-owned
> process info will not be shown, you would have to be root to see it all."
> in the ouptput says that all afterwards is useless
>
> "netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the
> machine where mysql is running! alterante: "telnet 127.0.0.1 3306"

sorry, i have re-enterd the command as root - here incuded

>
> "/mnt/etc/my.cnf" is really your active mysql-config?
> normally "/etc/my.cnf" is used, even if /etc/ is a own
> disk/partition you should never mount it as /mnt/etc/
> and managing with symlinks - mount it directly to /etc
>

you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that
file system to compare with /etc/my.cnf
They are the same, however.

Here included also /etc/mysqlaccess.conf

> i would assume something like "skip-networking" in your
> config if connection fails

it is there, but commented out:
/etc/my.cnf:#skip-networking

>
> anyways this mysql-config ma contain some includes
> because the line "!include_dir /etc/mysql"
>
/
That dir contains: /etc/mysql/default_plugins.cnf
its contents is here included

thank you
----p

1-----
% ° netstat --numeric-hosts --notrim --programs -u -t
~ (18:09-Sat 2)
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
PID/Program name
tcp 0 0 10.121.243.241:60577 74.125.232.149:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:54207 74.125.232.114:www-http
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:49545 85.86.166.196:7168
TIME_WAIT -
tcp 0 0 10.121.243.241:53173 74.125.232.150:https
TIME_WAIT -
tcp 0 0 127.0.0.1:50793 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 127.0.0.1:57336 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 10.121.243.241:39556 209.85.227.189:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:60576 74.125.232.149:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:39551 209.85.227.189:https
TIME_WAIT -
tcp 0 0 10.121.243.241:41089 83.233.30.55:ipsec-nat-t
TIME_WAIT -
tcp 0 0 10.121.243.241:39550 209.85.227.189:https
TIME_WAIT -
tcp 0 0 10.121.243.241:52758 83.51.48.124:44909
TIME_WAIT -
tcp 0 0 127.0.0.1:52722 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp 0 0 127.0.0.1:48856 127.0.0.1:52722
ESTABLISHED 6767/GoogleTalkPlug
tcp 0 0 10.121.243.241:39555 209.85.227.189:https
ESTABLISHED 6252/firefox
tcp 0 0 10.121.243.241:35365 82.56.169.37:19907
TIME_WAIT -
tcp 0 0 10.121.243.241:57283 80.91.229.10:nntp
ESTABLISHED 12106/knodec10783.s
tcp 0 0 10.121.243.241:44552 74.125.232.150:https
ESTABLISHED 6252/firefox
tcp 0 0 127.0.0.1:48856 127.0.0.1:50793
ESTABLISHED 6767/GoogleTalkPlug
tcp 0 0 127.0.0.1:48856 127.0.0.1:57336
ESTABLISHED 6767/GoogleTalkPlug

2 ----
(xpol) % ° cat /etc/mysqlaccess.conf | grep -v "^#"
~ (18:20-Sat 2)


#$Param{'host'} = '';
$Param{'user'} = 'nobody';
$Param{'db'} = 'test';
$Param{'password'} = 'foobar';
$Param{'debug'} = 0;

if ($CMD) {
$Param{'superuser'} = 'root';
$Param{'rhost'} = 'localhost';
$Param{'spassword'} = '';
$Param{'brief'} = 1;
}

if ($CGI) {
$Param{'superuser'} = 'root';
$Param{'rhost'} = 'localhost';
$Param{'spassword'} = '';
$Param{'table'} = 1;
}

1; #to make require happy

3------
(xpol) % ° cat /etc/mysql/default_plugins.cnf
~ (18:20-Sat 2)
[server]
plugin-load=blackhole=ha_blackhole.so
plugin-load=federated=ha_federated.so
plugin-load=archive=ha_archive.so

-----


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 18:50:38 von Reindl Harald

--------------enigCF5CE2ACFDD0BFD13FFFB6B1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Please "netstat --numeric-hosts --notrim --programs -u -t -l"
In my first answer i forgot the -l

Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld

the easiest test is however

> [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> 5.5.10-logï¿=BDK]qC7,t'��a4~Agb949^QXmys ql_native_p=
assword

if there is no connection we should find out why
debug simply the web-app user on a local terminal
to get error messages with more details as "failed"

> [harry@srv-rhsoft:~]$ mysql -h 127.0.0.1 -u myuser -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using =
password: NO)

this example says more as "failed" bceause we see that connection
is possible but authentication fails


Am 02.04.2011 18:21, schrieb xPol:
> Reindl Harald wrote:
>=20
>> please do not only post outputs, read them and try to understand
>> before press send - "not all processes could be identified, non-owned
>> process info will not be shown, you would have to be root to see it al=
l."
>> in the ouptput says that all afterwards is useless
>>
>> "netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the
>> machine where mysql is running! alterante: "telnet 127.0.0.1 3306"
>=20
> sorry, i have re-enterd the command as root - here incuded
>=20
>>
>> "/mnt/etc/my.cnf" is really your active mysql-config?
>> normally "/etc/my.cnf" is used, even if /etc/ is a own
>> disk/partition you should never mount it as /mnt/etc/
>> and managing with symlinks - mount it directly to /etc
>>
>=20
> you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted th=
at=20
> file system to compare with /etc/my.cnf
> They are the same, however.=20
>=20
> Here included also /etc/mysqlaccess.conf
>=20
>> i would assume something like "skip-networking" in your
>> config if connection fails
>=20
> it is there, but commented out:
> /etc/my.cnf:#skip-networking
>=20
>>
>> anyways this mysql-config ma contain some includes
>> because the line "!include_dir /etc/mysql"
>>
> /
> That dir contains: /etc/mysql/default_plugins.cnf=20
> its contents is here included
>=20
> thank you
> ----p
>=20
> 1-----=20
> % ° netstat --numeric-hosts --notrim --programs -u -t =
=20
> ~ (18:09-Sat 2)=20
> Active Internet connections (w/o servers)
> Proto Recv-Q Send-Q Local Address Foreign Address Sta=
te =20
> PID/Program name =20
> tcp 0 0 10.121.243.241:60577 74.125.232.149:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:54207 74.125.232.114:www-http=20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:49545 85.86.166.196:7168 =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:53173 74.125.232.150:https =20
> TIME_WAIT - =20
> tcp 0 0 127.0.0.1:50793 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 127.0.0.1:57336 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 10.121.243.241:39556 209.85.227.189:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:60576 74.125.232.149:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:39551 209.85.227.189:https =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:41089 83.233.30.55:ipsec-nat-t=20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:39550 209.85.227.189:https =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:52758 83.51.48.124:44909 =20
> TIME_WAIT - =20
> tcp 0 0 127.0.0.1:52722 127.0.0.1:48856 =20
> ESTABLISHED 6752/npviewer.bin =20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:52722 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
> tcp 0 0 10.121.243.241:39555 209.85.227.189:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 10.121.243.241:35365 82.56.169.37:19907 =20
> TIME_WAIT - =20
> tcp 0 0 10.121.243.241:57283 80.91.229.10:nntp =20
> ESTABLISHED 12106/knodec10783.s=20
> tcp 0 0 10.121.243.241:44552 74.125.232.150:https =20
> ESTABLISHED 6252/firefox =20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:50793 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
> tcp 0 0 127.0.0.1:48856 127.0.0.1:57336 =20
> ESTABLISHED 6767/GoogleTalkPlug=20
>=20
> 2 ----
> (xpol) % ° cat /etc/mysqlaccess.conf | grep -v "^#" =
=20
> ~ (18:20-Sat 2)=20
>=20
>=20
> #$Param{'host'} =3D '';
> $Param{'user'} =3D 'nobody';
> $Param{'db'} =3D 'test';
> $Param{'password'} =3D 'foobar';
> $Param{'debug'} =3D 0;
>=20
> if ($CMD) {
> $Param{'superuser'} =3D 'root';
> $Param{'rhost'} =3D 'localhost';
> $Param{'spassword'} =3D '';
> $Param{'brief'} =3D 1;
> }
>=20
> if ($CGI) {
> $Param{'superuser'} =3D 'root';
> $Param{'rhost'} =3D 'localhost';
> $Param{'spassword'} =3D '';
> $Param{'table'} =3D 1;
> }
>=20
> 1; #to make require happy
>=20
> 3------
> (xpol) % ° cat /etc/mysql/default_plugins.cnf =
=20
> ~ (18:20-Sat 2)=20
> [server]
> plugin-load=3Dblackhole=3Dha_blackhole.so
> plugin-load=3Dfederated=3Dha_federated.so
> plugin-load=3Darchive=3Dha_archive.so
>=20
> -----
>=20
>=20

--=20

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


--------------enigCF5CE2ACFDD0BFD13FFFB6B1
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 Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2XU94ACgkQhmBjz394AnloHACeMsoiW45+5yKtcyaMCX7R DHXZ
uN8An0lLYXahYdMftJ/Qx+1YGukpz5b2
=AdyC
-----END PGP SIGNATURE-----

--------------enigCF5CE2ACFDD0BFD13FFFB6B1--

Re: Can"t connect to MySQL server on "127.0.0.1" (111)

am 02.04.2011 19:14:09 von xPol

Reindl Harald wrote:

> Please "netstat --numeric-hosts --notrim --programs -u -t -l"
> In my first answer i forgot the -l


i will check according to your suggstions
If i find still in troubles, i will let you know

thank you
---p


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org