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

2011-04-02 Thread 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.

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

2011-04-02 Thread Reindl Harald
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..

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

2011-04-02 Thread 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 > > "net

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

2011-04-02 Thread Reindl Harald
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 --pr

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

2011-04-02 Thread 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

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

2011-04-02 Thread 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 -- defau

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

2011-04-02 Thread Andrew Moore
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, > poin

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

2011-04-02 Thread Reindl Harald
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 browser, > pointing to http://localhost:9000/ >

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>it sounds like you need to look at, and potentially cleanup (or make >your mysql access entries match) what's in the inverse-map record for >the IPnumbers of your machines. >when you connect mysql takes the IPnumber on the inbound connection, >looks it up in DNS and then checks the result against

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>Note that if you set the password by directly editing (UPDATE) the >mysql.user table like this, you will have to run FLUSH PRIVILEGES; Thank you. That solved the problem connecting from the mysql client. It changed the problem connecting via the 'Test' button from the ODBC Administrator, t

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM: MySQL 5.0.12, P2P Microsoft network I cannot get the manual's instructions (24.1.9.6) to work for connecting from a mysql client on a windows machine to a mysql server running on another windows ma

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread SGreen
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM: > MySQL 5.0.12, P2P Microsoft network > > I cannot get the manual's instructions (24.1.9.6) to work for > connecting from a mysql client on a windows machine to a mysql > server running on another windows machine (xp and w2kpr

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-29 Thread [EMAIL PROTECTED]
7;ll let you know if connecting from the laptop works. chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 6:40 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'loc

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
ednesday, January 28, 2004 4:15 PM To: N. Chris Frost Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'localhost' (10061) I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread Brian Harris
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

Re: Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
Roger and Johannes, The default did have the "skip-networking" on. I commented that out as you advised, and it worked like a Charm!! I'm pretty excited to be able to have that working now. I really really appreciate the prompt reply and the consideration that you both took in your replies.

Re: Can't connect to MySQL server

2004-01-10 Thread Roger Baklund
* Aaron Gerber > I'm new to the list, hope this is the correct mailing list. It is. :) > I have a new installation of MySQL 4.0.16. Default binary installation > (apt-get). It's running on linux (morphix .4). > > Locally, I can connect to the MySQL server > > mysql -h localhost -p You are not

Re: Can't connect to MySQL server

2004-01-10 Thread Johannes Franken
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]: > Locally, I can connect to the MySQL server [...] > but I can't connect if I put in the IP address (locally or remotely) Maybe mysqld is configured to listen on its unix domain socket only? This is the default for Debian. Remove the li

Re: Can't connect to MySQL server on '[server]' (10061) - unix & tcp/ip sockets

2003-10-28 Thread Victoria Reznichenko
"Ben Darlow" <[EMAIL PROTECTED]> wrote: > > I've recently set up a new linux box and installed MySQL 4 (for the > record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no > problems connecting using phpMyAdmin, but when I try to connect remotely > using MySQL Control Center or SQLyo

re: Can't connect to MySQL server & Access denied for root

2003-01-14 Thread Egor Egorov
On Monday 13 January 2003 14:21, Adrian Bucur wrote: > I removed an old mysql version and I installed a new one on a machine > running Suse 8.1 Linux. > shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm > sh

RE: Can't connect to MySQL server & Access denied for root

2003-01-13 Thread Loren McDonald
Sounds like the same problem I'm having (for which I'm still stumped and don't know what has caused it): table mysql.user is read only. Test this by logging into mysql and using the GRANT or REVOKE statements. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfM

Re: Can't connect to MYSQL Server

2001-04-04 Thread B. van Ouwerkerk
>When I type mysql from the command prompt ... an error occured : > ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061) >What is the problem? >Hanan Don't send me a copy of your message.. I'll get mine from the list.. Did you follow all instructions as found in the manual and from