Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

2013-06-13 Thread lx
hi all:
  I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
 mysql -h 192.168.27.72 -u root -p

the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)

#
mysql select host, user, password from user;
+-+--+---+
| host| user | password
 |
+-+--+---+
| localhost   | root | 023c30696e164488
 |
| vps192168027072 | root |
  |
| 127.0.0.1   | root |
  |
| localhost   |  |
  |
| vps192168027072 |  |
  |
| localhost   | monty| 0fc756bc026507b2
 |
| %   | monty| 0fc756bc026507b2
 |
| localhost   | gdnscenter   | 184a22a73852ad5b
 |
| %   | gdns_replication | 2dbc2f8719c4ffcd
 |
| %   | root | 023c30696e164488
 |
| 192.168.23.73   | root |
*EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 |
| 0.0.0.0 | root |
*EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 |
+-+--+---+
12 rows in set (0.00 sec)
#

And in 192.168.27.72
#
service iptables status
Firewall is stopped.
#

and there are not bind-address  and skip_networking in my.cnf 。


I have installed the mysql in this way:
#
yum -y install mysql-server

#vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set = utf8


[mysql]
default-character-set = utf8


[root@sample ~]# chkconfig mysqld on
[root@sample ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off


chattr -i /etc/group
chattr -i /etc/passwd
chattr -i /etc/shadow
chattr -i /etc/gshadow
useradd mysql
chattr +i /etc/group
chattr +i /etc/passwd
chattr +i /etc/shadow
chattr +i /etc/gshadow


chown mysql /var/run/mysqld/

cd /var/lib/mysql
chown mysql -R *
cd �C


mysql_install_db --user=mysql --ldata=/var/lib/mysql


[root@sample ~]# /etc/rc.d/init.d/mysqld start

#


Thank you


Re: Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

2013-06-13 Thread Johan De Meersman
Assuming Linux, check where it's listening using netstat -lptn.

lx lxlenovos...@gmail.com wrote:
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
 mysql -h 192.168.27.72 -u root -p

the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72'
(111)

#
mysql select host, user, password from user;
+-+--+---+
| host| user | password
 |
+-+--+---+
| localhost   | root | 023c30696e164488
 |
| vps192168027072 | root |
  |
| 127.0.0.1   | root |
  |
| localhost   |  |
  |
| vps192168027072 |  |
  |
| localhost   | monty| 0fc756bc026507b2
 |
| %   | monty| 0fc756bc026507b2
 |
| localhost   | gdnscenter   | 184a22a73852ad5b
 |
| %   | gdns_replication | 2dbc2f8719c4ffcd
 |
| %   | root | 023c30696e164488
 |
| 192.168.23.73   | root |
*EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 |
| 0.0.0.0 | root |
*EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 |
+-+--+---+
12 rows in set (0.00 sec)
#

And in 192.168.27.72
#
service iptables status
Firewall is stopped.
#

and there are not bind-address  and skip_networking in my.cnf 。


I have installed the mysql in this way:
#
yum -y install mysql-server

#vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set = utf8


[mysql]
default-character-set = utf8


[root@sample ~]# chkconfig mysqld on
[root@sample ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off


chattr -i /etc/group
chattr -i /etc/passwd
chattr -i /etc/shadow
chattr -i /etc/gshadow
useradd mysql
chattr +i /etc/group
chattr +i /etc/passwd
chattr +i /etc/shadow
chattr +i /etc/gshadow


chown mysql /var/run/mysqld/

cd /var/lib/mysql
chown mysql -R *
cd –


mysql_install_db --user=mysql --ldata=/var/lib/mysql


[root@sample ~]# /etc/rc.d/init.d/mysqld start

#


Thank you

-- 
Sent from Kaiten Mail. Please excuse my brevity.

Re: Connect to MySQL server from a c++ application

2012-06-08 Thread Simon Walter


On 06/08/2012 01:55 AM, Claudio Nanni wrote:

Hi,

you guys don't like the official API?

http://dev.mysql.com/downloads/connector/c/



That's C isn't it? I think there is also a C++ connector. I'm interested 
to hear how that performs. It seems like a waste of time to write a 
bunch of wrappers for the C connector.



--
simonsmicrophone.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Connect to MySQL server from a c++ application

2012-06-08 Thread Claudio Nanni
Simon,

yes it is C,

C++ here:  http://dev.mysql.com/downloads/connector/cpp/

I did not work with this libraries and to be honest I do not know about
their performances,

If you have the chance it would be extremely useful for the community
having some tests done with both APIs.

Cheers

Claudio

2012/6/8 Simon Walter si...@gikaku.com


 On 06/08/2012 01:55 AM, Claudio Nanni wrote:

 Hi,

 you guys don't like the official API?

 http://dev.mysql.com/**downloads/connector/c/http://dev.mysql.com/downloads/connector/c/


 That's C isn't it? I think there is also a C++ connector. I'm interested
 to hear how that performs. It seems like a waste of time to write a bunch
 of wrappers for the C connector.


 --
 simonsmicrophone.com


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql




-- 
Claudio


Re: Connect to MySQL server from a c++ application

2012-06-07 Thread Simon Walter


On 06/07/2012 12:29 PM, Lars Nilsson wrote:


On Wed, Jun 6, 2012 at 10:41 PM, Simon Waltersi...@gikaku.com  wrote:

However, memory leaks are not acceptable. So I am open to suggestions. What
do other c++ programmers use?


I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
Commercial and not open source, but it's cross-platform and supports a
dozen or so different databases.



It looks nice. I'm looking for something open source. I'm fine using one 
of the SQL connectors. I just need to know which one works. How does 
SQLAPI++ connect to MySQL? Is it thread safe?


--
simonsmicrophone.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Connect to MySQL server from a c++ application

2012-06-07 Thread Lars Nilsson
On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote:
 On 06/07/2012 12:29 PM, Lars Nilsson wrote:
 I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
 Commercial and not open source, but it's cross-platform and supports a
 dozen or so different databases.

 It looks nice. I'm looking for something open source. I'm fine using one of
 the SQL connectors. I just need to know which one works. How does SQLAPI++
 connect to MySQL? Is it thread safe?

It loads the libmysqlclient dll/so libraries under the hood, mapping
each database client library's particular function set to its own
internal function pointers. I believe it to be thread-safe (pthread
mutexes on Linux/Unix, Windows relies on mutex/critical section
objects). Instances of SAConnection objects should probably not be
used across threads simultaneously though (usual caveats when doing
multi-threaded programming apply, etc).

I do like the high-level abstraction of the databases, and the use of
exceptions for errors so every statement doesn't need to have a check
to see if it was successful (just wrap your sequence of operations in
a try/catch as makes sense for the application). I know it reduced my
database-specific lines of code quite a bit when I changed a MySQL
specific program to using SQLAPI++.

If one need to, it is always possible to get a native database handle
out that can be used with the database-specific API (at which point
your program would have to be linked with the required
database-specific client libraries, and so on), but it is not
something I have really needed personally. If at all possible, I stay
in the realm of SQLAPI++ which makes my program independent of the
database libraries (implies I do not use native handles). It means I
can compile my program without having Oracle installed for instance,
and as long as a user has some means of configuring my program so that
SA_Oracle_Client is passed to a connection object (mapping from string
to the enum value or whatever else make sense), it should just work,
given a proper connection string (as long as one handles the special
cases properly as outlined in database specific notes for the classes
and methods, etc)

I'm sorry if I sound like a sales person for SQLAPI++. I have no
relation to it, just a satisfied user.

Lars Nilsson

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Connect to MySQL server from a c++ application

2012-06-07 Thread Claudio Nanni
Hi,

you guys don't like the official API?

http://dev.mysql.com/downloads/connector/c/

Cheers

Claudio

2012/6/7 Lars Nilsson chamael...@gmail.com

 On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote:
  On 06/07/2012 12:29 PM, Lars Nilsson wrote:
  I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
  Commercial and not open source, but it's cross-platform and supports a
  dozen or so different databases.

  It looks nice. I'm looking for something open source. I'm fine using one
 of
  the SQL connectors. I just need to know which one works. How does
 SQLAPI++
  connect to MySQL? Is it thread safe?

 It loads the libmysqlclient dll/so libraries under the hood, mapping
 each database client library's particular function set to its own
 internal function pointers. I believe it to be thread-safe (pthread
 mutexes on Linux/Unix, Windows relies on mutex/critical section
 objects). Instances of SAConnection objects should probably not be
 used across threads simultaneously though (usual caveats when doing
 multi-threaded programming apply, etc).

 I do like the high-level abstraction of the databases, and the use of
 exceptions for errors so every statement doesn't need to have a check
 to see if it was successful (just wrap your sequence of operations in
 a try/catch as makes sense for the application). I know it reduced my
 database-specific lines of code quite a bit when I changed a MySQL
 specific program to using SQLAPI++.

 If one need to, it is always possible to get a native database handle
 out that can be used with the database-specific API (at which point
 your program would have to be linked with the required
 database-specific client libraries, and so on), but it is not
 something I have really needed personally. If at all possible, I stay
 in the realm of SQLAPI++ which makes my program independent of the
 database libraries (implies I do not use native handles). It means I
 can compile my program without having Oracle installed for instance,
 and as long as a user has some means of configuring my program so that
 SA_Oracle_Client is passed to a connection object (mapping from string
 to the enum value or whatever else make sense), it should just work,
 given a proper connection string (as long as one handles the special
 cases properly as outlined in database specific notes for the classes
 and methods, etc)

 I'm sorry if I sound like a sales person for SQLAPI++. I have no
 relation to it, just a satisfied user.

 Lars Nilsson

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql




-- 
Claudio


Re: Connect to MySQL server from a c++ application

2012-06-07 Thread Baron Schwartz
There is also libdrizzle.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Connect to MySQL server from a c++ application

2012-06-07 Thread Lars Nilsson
On Thu, Jun 7, 2012 at 12:55 PM, Claudio Nanni claudio.na...@gmail.com wrote:
 Hi,

 you guys don't like the official API?

 http://dev.mysql.com/downloads/connector/c/

 Cheers

 Claudio

Personally? Not really.

For instance, memory leaks are not acceptable according to Simon's
expressed desire.

SQLAPI++ allows me to completely avoid explicit memory/resource
allocation, if I put things on the stack.

class Foo { int x; std::string y; }
typedef std::mapint, Foo FooV;

FooV vFoo;

try
{
  SAConnection db(db, user, password);
  SACommand cmd(db);

  cmd.setCommandText(SELECT id, name FROM foo);
  cmd.Execute();

  while (cmd.FetchNext())
  {
Foo foo;
foo.x = cmd.Field(1).asLong();
foo.y = (const char *)cmd.Field(2).asString();
vFoo[foo.x] = foo;
  }
}
catch (SAException e)
{
  std::cerr  Failure:   (const char *)e.ErrText();
}

Using MySQL's API I'd need to make sure I close connections I open,
free result sets I get back, etc. SQLAPI++ perform these operations
behind the scenes for me when objects are created/initialized and
destroyed. If I happen to use pointers for some of these instead of
putting them on the stack, the ball is back in my court again to make
sure I don't lose track of something.

This is my personal preference. YMMV.

Lars Nilsson

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Connect to MySQL server from a c++ application

2012-06-06 Thread Simon Walter


What is the most stable and performant way to connect to a MySQL server 
from a c++ application?


I've been using libmyodbc via unixODBC running under Debian squeeze. 
Suffice it to say, I am sorely disappointed. First of all the libmyodbc 
driver that's included with Debian is quite old. However, even after 
building and utilizing the latest version, there are still memory leaks 
in the driver.


I'm not stuck on using ODBC. Though it's nice to be able to is use an 
ODBC library so that I can connect to various DBs without having to 
learn new APIs. There is also the benefit of being able to change 
databases without much effort.


However, memory leaks are not acceptable. So I am open to suggestions. 
What do other c++ programmers use?


(note: I know this is probably not the place to ask this, but the 
libmyodbc mailing is dead as a door nail with people's auto-responders 
going off like a digital ghost town. :/)


Thanks,

Simon

--
simonsmicrophone.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Connect to MySQL server from a c++ application

2012-06-06 Thread Lars Nilsson
On Wed, Jun 6, 2012 at 10:41 PM, Simon Walter si...@gikaku.com wrote:
 However, memory leaks are not acceptable. So I am open to suggestions. What
 do other c++ programmers use?

I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
Commercial and not open source, but it's cross-platform and supports a
dozen or so different databases.

One of the example programs (without comments and the wrapping try/catch block)

con.Connect(test, tester, tester, SA_Oracle_Client);
cmd.setConnection(con);
cmd.setCommandText(
Insert into test_tbl(fid, fvarchar20) values(:1, :2));
cmd.Param(1).setAsLong() = 2;
cmd.Param(2).setAsString() = Some string (2);
cmd.Execute();
cmd  (long)3  Some string (3);
cmd.Execute();
con.Commit();

Simply replace SA_Oracle_Client with SA_MySQL_Client, etc, and you'll
be working against MySQL. Only requirement is that the dll/so
libraries for each database you want to connect to are installed
properly.

Lars Nilsson

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



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

2011-04-02 Thread 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=arch...@jab.org



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



signature.asc
Description: OpenPGP digital signature


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 xtek...@gmail.com 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=eroomy...@gmail.com




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 --
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/mysql.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=arch...@jab.org



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  
 
~ (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   
tcp0  0 10.121.243.241:3831574.125.77.109:smtp  
TIME_WAIT   -   
tcp0  0 127.0.0.1:50793 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 127.0.0.1:57336 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 10.121.243.241:5392474.125.232.152:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:5392574.125.232.152:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:5389474.125.232.152:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:35673209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:35672209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:48554209.85.149.105:www-http 
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:35666209.85.227.189:https
TIME_WAIT   -   
tcp0  0 10.121.243.241:35667209.85.227.189:https
TIME_WAIT   -   
tcp0  0 10.121.243.241:5392674.125.232.152:https
ESTABLISHED 6252/firefox
tcp0  0 127.0.0.1:52722 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 127.0.0.1:48856 127.0.0.1:52722 
ESTABLISHED 6767/GoogleTalkPlug 
tcp0  0 127.0.0.1:48856 127.0.0.1:50793 
ESTABLISHED 6767/GoogleTalkPlug 
tcp0  0 127.0.0.1:48856 127.0.0.1:57336 
ESTABLISHED 6767/GoogleTalkPlug 
tcp0  0 10.121.243.241:5432480.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=arch...@jab.org



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 --programs -u -t -l as ROOT on the machine
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:
 
 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   
 tcp0  0 10.121.243.241:3831574.125.77.109:smtp  
 TIME_WAIT   -   
 tcp0  0 127.0.0.1:50793 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 127.0.0.1:57336 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 10.121.243.241:5392474.125.232.152:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:5392574.125.232.152:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:5389474.125.232.152:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:35673209.85.227.189:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:35672209.85.227.189:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:48554209.85.149.105:www-http 
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:35666209.85.227.189:https
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:35667209.85.227.189:https
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:5392674.125.232.152:https
 ESTABLISHED 6252/firefox
 tcp0  0 127.0.0.1:52722 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 127.0.0.1:48856 127.0.0.1:52722 
 ESTABLISHED 6767/GoogleTalkPlug 
 tcp0  0 127.0.0.1:48856 127.0.0.1:50793 
 ESTABLISHED 6767/GoogleTalkPlug 
 tcp0  0 127.0.0.1:48856 127.0.0.1:57336 
 ESTABLISHED 6767/GoogleTalkPlug 
 tcp0  0 10.121.243.241:5432480.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
 
 
 
 
 
 
 -
 
 

-- 

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/



signature.asc
Description: OpenPGP digital signature


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
 
 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   
tcp0  0 10.121.243.241:6057774.125.232.149:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:5420774.125.232.114:www-http 
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:4954585.86.166.196:7168  
TIME_WAIT   -   
tcp0  0 10.121.243.241:5317374.125.232.150:https
TIME_WAIT   -   
tcp0  0 127.0.0.1:50793 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 127.0.0.1:57336 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 10.121.243.241:39556209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:6057674.125.232.149:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:39551209.85.227.189:https
TIME_WAIT   -   
tcp0  0 10.121.243.241:4108983.233.30.55:ipsec-nat-t 
TIME_WAIT   -   
tcp0  0 10.121.243.241:39550209.85.227.189:https
TIME_WAIT   -   
tcp0  0 10.121.243.241:5275883.51.48.124:44909  
TIME_WAIT   -   
tcp0  0 127.0.0.1:52722 127.0.0.1:48856 
ESTABLISHED 6752/npviewer.bin   
tcp0  0 127.0.0.1:48856 127.0.0.1:52722 
ESTABLISHED 6767/GoogleTalkPlug 
tcp0  0 10.121.243.241:39555209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0  0 10.121.243.241:3536582.56.169.37:19907  
TIME_WAIT   -   
tcp0  0 10.121.243.241:5728380.91.229.10:nntp   
ESTABLISHED 12106/knodec10783.s 
tcp0  0 10.121.243.241:4455274.125.232.150:https
ESTABLISHED 6252/firefox
tcp0  0 127.0.0.1:48856 127.0.0.1:50793 
ESTABLISHED 6767/GoogleTalkPlug 
tcp0  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=arch...@jab.org



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...
 Connected to 127.0.0.1.
 Escape character is '^]'.
 5.5.10-log�K]qC7,t'��a4~Agb949^QXmysql_native_password

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:
 
 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   
 tcp0  0 10.121.243.241:6057774.125.232.149:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:5420774.125.232.114:www-http 
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:4954585.86.166.196:7168  
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:5317374.125.232.150:https
 TIME_WAIT   -   
 tcp0  0 127.0.0.1:50793 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 127.0.0.1:57336 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 10.121.243.241:39556209.85.227.189:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:6057674.125.232.149:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:39551209.85.227.189:https
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:4108983.233.30.55:ipsec-nat-t 
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:39550209.85.227.189:https
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:5275883.51.48.124:44909  
 TIME_WAIT   -   
 tcp0  0 127.0.0.1:52722 127.0.0.1:48856 
 ESTABLISHED 6752/npviewer.bin   
 tcp0  0 127.0.0.1:48856 127.0.0.1:52722 
 ESTABLISHED 6767/GoogleTalkPlug 
 tcp0  0 10.121.243.241:39555209.85.227.189:https
 ESTABLISHED 6252/firefox
 tcp0  0 10.121.243.241:3536582.56.169.37:19907  
 TIME_WAIT   -   
 tcp0  0 10.121.243.241:5728380.91.229.10:nntp   
 ESTABLISHED 12106/knodec10783.s 
 tcp0  0 10.121.243.241:4455274.125.232.150:https
 ESTABLISHED 6252/firefox
 tcp0  0 127.0.0.1:48856 127.0.0.1:50793 
 ESTABLISHED 6767/GoogleTalkPlug 
 tcp0  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'}  = '';

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.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Can not connect to MYSQL server on Windows Vista 64 bit

2009-11-03 Thread David Parham
I have a vb.net app that was running fine on two XP computers using 
Mysql 5.0 server.   I switched to a new Vista 64 bit computer, and now 
it gives me a message that it can not connect to any mysql hosts.In 
Navicat, when I try to setup the connection, it gives message   2003 - 
Can't connect to mysql server on Dell1440 (10060)


I have added port 3306 to the windows firewall, and after it didn't 
work, totally turned off the firewall.   Now if I bring up the app, and 
go into a one record at a time update form, the first record will 
appear, but it won't page to the next one without the failure on the 
connection.


Any ideas as to what I need to do to make it work properly.

Thanks,

David


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime

2008-08-18 Thread Pieter de Zwart
Greetings to all,

I am having a weird issue with MySQL that I can't solve.  We are getting
intermittent client connection errors code 2003 to the database server for
10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
have not been able to correlate these connection problems with any other
queries, jobs, etc, so I was hoping someone here might be able to help me
out.

The problem is as follows. Seemingly at random, the master suddenly stops
accepting connections, and the clients return connection error 2003,
indicating the master did not respond in a timely manner. This goes on for
about 10 minutes, at which point the master starts accepting connections
again, without any human input. This happened at 4am on Sunday morning for
example, so it healed itself before I could get myself out of bed and
comprehend the situation, let alone connect somewhere and try and fix it.
We are seeing this happen about 4 or 5 times a week for the last 2 weeks,
and there seems to be no pattern as to the time or date. Sometimes it
happens twice in one day, and then disappears for 4 days. There was no spike
in activity as far as we can tell, and the CPU and network usage were stable
at about 2% and 4% of capacity respectively. Also, we have slow query log
turned on and set to 1sec, and there are no queries anywhere near the gaps
in connection.

We are running MySQL 5.0.44 on a single master on its on hardware, with a
replication slave on a different machine. We have a write through memcached
setup in front my MySQL, which handles the majority of the requests, so
MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on
average. All of this is running on Amazon EC2 instances, and have dedicated
boxes (we are running the 64bit Large Instance, which is supposed to be a
dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G
free.) We then have two other machines that run the front end web servers
running PHP 5.1.6 and load balancers, which connect to the database when the
cache doesnt have the required information. I did not post this to the PHP
section since it seems like a more general issue with the server as opposed
to the clients.

After the second time it happened, we switched out our AWS hardware in hopes
that it was a hardware fluke, but to no avail. The problem reared its
uglyhead 3 days later.  We doubt it is the internal Amazon network since the
external monitoring of the box continues to work and spit out information,
and no other box is showing similar connection symptoms. Also, all of our
boxes are in the same Amazon Zone, which implies that they are in the same
colo. This makes me think that a combination of our configuration and
queries are causing the trouble.

I checked the archives, but it seems that the people who encountered this
error saw it during setup/configuration, and not randomly after 30 days of
uptime. I doubt anyone has the answer, so I was hoping someone could help me
understand the best way to debug this problem in order to find the reason
for these random outages.

Thanks in advance for any and all help!

Pieter de Zwart


Re: Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime

2008-08-18 Thread Sreekanth CHAVA
HI  Pieter

I  have  a  suggestion.this  might  not be  very helpful

Try  to reconfigure  the connections  between  the  client  and  Mysql
server  where  the  problem  exists.and  then try  to  notice the

uptime and  logs of the  server.

CHAVA

On Mon, Aug 18, 2008 at 12:00 PM, Pieter de Zwart 
[EMAIL PROTECTED] wrote:

 Greetings to all,

 I am having a weird issue with MySQL that I can't solve.  We are getting
 intermittent client connection errors code 2003 to the database server for
 10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
 have not been able to correlate these connection problems with any other
 queries, jobs, etc, so I was hoping someone here might be able to help me
 out.

 The problem is as follows. Seemingly at random, the master suddenly stops
 accepting connections, and the clients return connection error 2003,
 indicating the master did not respond in a timely manner. This goes on for
 about 10 minutes, at which point the master starts accepting connections
 again, without any human input. This happened at 4am on Sunday morning for
 example, so it healed itself before I could get myself out of bed and
 comprehend the situation, let alone connect somewhere and try and fix it.
 We are seeing this happen about 4 or 5 times a week for the last 2 weeks,
 and there seems to be no pattern as to the time or date. Sometimes it
 happens twice in one day, and then disappears for 4 days. There was no
 spike
 in activity as far as we can tell, and the CPU and network usage were
 stable
 at about 2% and 4% of capacity respectively. Also, we have slow query log
 turned on and set to 1sec, and there are no queries anywhere near the gaps
 in connection.

 We are running MySQL 5.0.44 on a single master on its on hardware, with a
 replication slave on a different machine. We have a write through memcached
 setup in front my MySQL, which handles the majority of the requests, so
 MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on
 average. All of this is running on Amazon EC2 instances, and have dedicated
 boxes (we are running the 64bit Large Instance, which is supposed to be a
 dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G
 free.) We then have two other machines that run the front end web servers
 running PHP 5.1.6 and load balancers, which connect to the database when
 the
 cache doesnt have the required information. I did not post this to the PHP
 section since it seems like a more general issue with the server as opposed
 to the clients.

 After the second time it happened, we switched out our AWS hardware in
 hopes
 that it was a hardware fluke, but to no avail. The problem reared its
 uglyhead 3 days later.  We doubt it is the internal Amazon network since
 the
 external monitoring of the box continues to work and spit out information,
 and no other box is showing similar connection symptoms. Also, all of our
 boxes are in the same Amazon Zone, which implies that they are in the same
 colo. This makes me think that a combination of our configuration and
 queries are causing the trouble.

 I checked the archives, but it seems that the people who encountered this
 error saw it during setup/configuration, and not randomly after 30 days of
 uptime. I doubt anyone has the answer, so I was hoping someone could help
 me
 understand the best way to debug this problem in order to find the reason
 for these random outages.

 Thanks in advance for any and all help!

 Pieter de Zwart




-- 
Sreekanth CHAVA


Re: Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime

2008-08-18 Thread Michael Dykman
Regardless of who has implemented the network and the status of
provided monitoring tools, this has all the look and feel of
intermittent network issues.   I would run an independant network scan
(maybe nmap?) from one of the affected clients to the affected host
and I bet you will find that the same fluctuations occur on other
ports.

On Mon, Aug 18, 2008 at 3:22 PM, Sreekanth CHAVA
[EMAIL PROTECTED] wrote:
 HI  Pieter

 I  have  a  suggestion.this  might  not be  very helpful

 Try  to reconfigure  the connections  between  the  client  and  Mysql
 server  where  the  problem  exists.and  then try  to  notice the

 uptime and  logs of the  server.

 CHAVA

 On Mon, Aug 18, 2008 at 12:00 PM, Pieter de Zwart 
 [EMAIL PROTECTED] wrote:

 Greetings to all,

 I am having a weird issue with MySQL that I can't solve.  We are getting
 intermittent client connection errors code 2003 to the database server for
 10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
 have not been able to correlate these connection problems with any other
 queries, jobs, etc, so I was hoping someone here might be able to help me
 out.

 The problem is as follows. Seemingly at random, the master suddenly stops
 accepting connections, and the clients return connection error 2003,
 indicating the master did not respond in a timely manner. This goes on for
 about 10 minutes, at which point the master starts accepting connections
 again, without any human input. This happened at 4am on Sunday morning for
 example, so it healed itself before I could get myself out of bed and
 comprehend the situation, let alone connect somewhere and try and fix it.
 We are seeing this happen about 4 or 5 times a week for the last 2 weeks,
 and there seems to be no pattern as to the time or date. Sometimes it
 happens twice in one day, and then disappears for 4 days. There was no
 spike
 in activity as far as we can tell, and the CPU and network usage were
 stable
 at about 2% and 4% of capacity respectively. Also, we have slow query log
 turned on and set to 1sec, and there are no queries anywhere near the gaps
 in connection.

 We are running MySQL 5.0.44 on a single master on its on hardware, with a
 replication slave on a different machine. We have a write through memcached
 setup in front my MySQL, which handles the majority of the requests, so
 MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on
 average. All of this is running on Amazon EC2 instances, and have dedicated
 boxes (we are running the 64bit Large Instance, which is supposed to be a
 dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G
 free.) We then have two other machines that run the front end web servers
 running PHP 5.1.6 and load balancers, which connect to the database when
 the
 cache doesnt have the required information. I did not post this to the PHP
 section since it seems like a more general issue with the server as opposed
 to the clients.

 After the second time it happened, we switched out our AWS hardware in
 hopes
 that it was a hardware fluke, but to no avail. The problem reared its
 uglyhead 3 days later.  We doubt it is the internal Amazon network since
 the
 external monitoring of the box continues to work and spit out information,
 and no other box is showing similar connection symptoms. Also, all of our
 boxes are in the same Amazon Zone, which implies that they are in the same
 colo. This makes me think that a combination of our configuration and
 queries are causing the trouble.

 I checked the archives, but it seems that the people who encountered this
 error saw it during setup/configuration, and not randomly after 30 days of
 uptime. I doubt anyone has the answer, so I was hoping someone could help
 me
 understand the best way to debug this problem in order to find the reason
 for these random outages.

 Thanks in advance for any and all help!

 Pieter de Zwart




 --
 Sreekanth CHAVA




-- 
 - michael dykman
 - [EMAIL PROTECTED]

 - All models are wrong. Some models are useful.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



failure to connect to mysql-server at localhost

2008-07-22 Thread kenneth rotich














 Hi all,
i am
installing a library automation software called koha which uses
mysql-server. i initially installed version5.0 and later uninstalled
it because the system was giving me some errors. i installed the
lower version(mysql-server-4.1). when reinstalling koha i get the
following:



MYSQL ROOT USER PASSWORD
 
 To create the koha database, please enter your mysql server's root user
 password:
 
 Password:
 
  
  CREATING DATABASE
 
 Creating the MySQL database for Koha...
  
  ERROR CREATING DATABASE
/usr/bin/mysqladmin: connect to server at 'localhost' failed
 
 Couldn't connect to the MySQL server for the reason given above. This is a
 serious problem, the database will not get installed.
 
 Press ENTER to continue:



i continued with
with installation to the end. As a result of the above problem
everything seems to work (adding members, searching and importing
records from the internet using z39.50) But
it doesnt add bibliographic records to the database- whenever i try
to add records i get a server error.





will be grateful if somebody can
sort me out.

i am using ubutu 6.06 operating
system.

Thanks

kenneth



  

MYSQL connection failed: Can not connect to MySQL server

2007-10-30 Thread Jose Romero
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was 
compiled with MySQL support, the MySQL database is external to the mail server. 
Although the system works, I have a lot of daily messages in exim's log with 
the following error: MYSQL connection failed: Can not connect to MySQL server 
on'192 .168.5.1 '(1) What causes some messages are rejected. To try to 
reproduce the problem I have tried doing Telnet connections to the server and 
MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying 
192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not permitted 
Telnet: Unable to connect to remote host Someone could help me with this ?, 
thanks in advance Best regards
_
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

Re: MYSQL connection failed: Can not connect to MySQL server

2007-10-30 Thread Dan Nelson
In the last episode (Oct 31), Jose Romero said:
 Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim
 was compiled with MySQL support, the MySQL database is external to
 the mail server. Although the system works, I have a lot of daily
 messages in exim's log with the following error: MYSQL connection
 failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What
 causes some messages are rejected. To try to reproduce the problem I
 have tried doing Telnet connections to the server and MySQL,
 sometimes I get the following error: Telnet 192.168.5.1 3306 Trying
 192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not
 permitted Telnet: Unable to connect to remote host Someone could help
 me with this ?, thanks in advance Best regards

Do you maybe have an ipfw rule that would be blocking that?  That's the
only thing I can think of that will cause an EPERM error on a socket
connect call.  A limit rule with a too-low connection count could
cause what you're seeing.  Adding an explicit allow rule before your
limit rule, allowing traffic to port 3306 of the other server, should
fix your problem.

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor

Hi,

I have an interesting (a.k.a. frustrating) problem on MySQL 4.1.11.

I try to connect to the database via DBD::mysql. Everything works - except in a 
few cases (once in every 1 occasions, approximately) I get:

DBI connect('database=test:host=192.168.0.200','test',...) failed: Can't 
connect to MySQL server on '192.168.0.200' (99) at con.pl line 14

perror 99 gives me:
OS error code  99:  Cannot assign requested address

This doesn't make sense to me. I wrote a test script that looks like this:


for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}


Periodically I get the above error.

I have tried to be more nice, after upgrading DBD and DBI, etc.:

for (1..5) {
 $dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
 my $sth = $dbh-prepare('SELECT * FROM users');
 $sth = undef;
 $dbh-disconnect;
 $dbh = undef;
}


But the same happens.


Then I straced the program. This is what I got:

restart_syscall(... resuming interrupted call ...) = 0
time(NULL)  = 1170758829
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
fcntl64(3, F_SETFL, O_RDONLY)   = 0
fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sa_family=AF_INET, sin_port=htons(3306), 
sin_addr=inet_addr(192.168.0.200)}, 16) = -1 EADDRNOTAVAIL (Cannot assign 
requested address)
shutdown(3, 2 /* send and receive */)   = -1 ENOTCONN (Transport endpoint is 
not connected)
close(3)= 0
write(1, Doesn\'t work. Reconnecting in 1 ..., 51) = 51
time(NULL)  = 1170758829
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGCHLD, NULL, {SIG_DFL}, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
nanosleep({1, 0}, {1, 0})   = 0
time(NULL)  = 1170758830
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
fcntl64(3, F_SETFL, O_RDONLY)   = 0
fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sa_family=AF_INET, sin_port=htons(3306), 
sin_addr=inet_addr(192.168.0.200)}, 16) = -1 EADDRNOTAVAIL (Cannot assign 
requested address)
shutdown(3, 2 /* send and receive */)   = -1 ENOTCONN (Transport endpoint is 
not connected)



Anybody seen anything like this?


- Fagzal


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Nils Meyer

Hi Faygal,

Fagyal Csongor wrote:

for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}

I think you are simply running out of available outgoing ports with 
that. Here is some more insight on that topic:


http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

Don't be confused with the PHP mentioned, the first paragraphs apply to 
TCP/IP and mysql as whole.


regards
Nils

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor

Nils Meyer wrote:


Hi Faygal,

Fagyal Csongor wrote:


for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}

I think you are simply running out of available outgoing ports with 
that. Here is some more insight on that topic:


http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ 



Don't be confused with the PHP mentioned, the first paragraphs apply 
to TCP/IP and mysql as whole.


regards
Nils


Thanks, Nils.

Actually I got to the same conclusion, too... when this error appears, there are something 
like 15000 TCP connections around, mostly in TIME_WAIT. Too bad these 
connections linger around even after an explicit -disconnect().

I should be using a persistent connection anyway :)

- Csongor


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



How can I connect to mysql server using PHP?

2006-06-27 Thread 战芳

Hello everyone:
 I wanna connect to mysql server using PHP. My operating system is Redhat 
Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started the server 
using a statement like this:
#/usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock
But when I call mysql_pconnect(localhost,root,) in my web page, the 
server return me an error, saying Can't connect to 
socket:/var/lib/mysql/mysql.sock(13). How can I do?


Fang 
   




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: How can I connect to mysql server using PHP?

2006-06-27 Thread Chris White
On Tuesday 27 June 2006 03:35 am, 战芳 wrote:
 Hello everyone:
  I wanna connect to mysql server using PHP. My operating system is
 Redhat Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started
 the server using a statement like this: #/usr/local/mysql/bin/mysqld
 -uroot -S/var/lib/mysql/mysql.sock

The  is what's screwing you up.   takes the 
command /usr/local/mysql/bin/mysqld -uroot and puts it in the background.  -S 
is simply eaten up by the shell, and probably tried as arguments to test.  
You probably want:

/usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock

 But when I call mysql_pconnect(localhost,root,) in my web page, the
 server return me an error, saying Can't connect to
 socket:/var/lib/mysql/mysql.sock(13). How can I do?

 Fang

-- 
Chris White
PHP Programmer/DB Freeloader
Interfuel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: I can't connect to mysql server with PHP

2006-05-24 Thread gerald_clark
战芳 wrote:

Hi! gerald_clark,
But when I call mysql_pconnect(localhost:3306,root,root_password),it 
return the same error. How can I get the permission to open 
/var/mysql/lib/mysql.sock?
  Fang

  

what do you get when you do
ls -l /var/mysql/lib/mysql.sock?
Permissions should be srwxrwxrwx


  

fool.ben wrote:



Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat 
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna 
connect to the server using the following statement:
$db_connection=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket 
'/var/mysql/lib/mysql.sock(13)' 
 

  

The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.sock.



I was suggested that the server may not running, or the sockect is wrong. 
But when I run the following statement, there was no error occured:
localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock
 

  

Here you are root, so you have permissions.



Can anyone help me?
 

  

Fix your permissions or move your socket to a directory that is world
searchable.



Fang
 

  

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]







  



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Re: I can't connect to mysql server with PHP

2006-05-23 Thread 战芳

Hi! gerald_clark,
But when I call mysql_pconnect(localhost:3306,root,root_password),it 
return the same error. How can I get the permission to open 
/var/mysql/lib/mysql.sock?
   Fang



fool.ben wrote:

Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat 
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect 
to the server using the following statement:
$db_connection=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket 
'/var/mysql/lib/mysql.sock(13)' 
  

The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.sock.

I was suggested that the server may not running, or the sockect is wrong. But 
when I run the following statement, there was no error occured:
localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock
  

Here you are root, so you have permissions.

Can anyone help me?
  

Fix your permissions or move your socket to a directory that is world
searchable.

 
 Fang
  



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



I can't connect to mysql server with PHP

2006-05-22 Thread fool.ben
Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat 
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect 
to the server using the following statement:
$db_connection=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket 
'/var/mysql/lib/mysql.sock(13)' 
I was suggested that the server may not running, or the sockect is wrong. But 
when I run the following statement, there was no error occured:
localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock
Can anyone help me?
 
 Fang

Re: I can't connect to mysql server with PHP

2006-05-22 Thread gerald_clark
fool.ben wrote:

Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat 
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect 
to the server using the following statement:
$db_connection=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket 
'/var/mysql/lib/mysql.sock(13)' 
  

The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.sock.

I was suggested that the server may not running, or the sockect is wrong. But 
when I run the following statement, there was no error occured:
localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock
  

Here you are root, so you have permissions.

Can anyone help me?
  

Fix your permissions or move your socket to a directory that is world
searchable.

 
 Fang
  



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

2005-12-04 Thread Mike Smith
Hi,

I've been dealing with this problem for a week now
without resolution.
I'm running an application called mythtv which uses
mysql as its database.
I've installed mythtv and mysql dozens of times
without any problem.

I'd been running two Mandrake 10.1 systems for the
last nine months. One,
gandalf, was the mythtv backend server which also runs
mysql.  The other is
frodo, which runs the mythtfrontend ( client ) and
connects to the backend.
It must also connect to the mysql DB.
MySQL-4.0.20-3mdk.i586.rpm comes with
the Mandrake 10.1 distribution.  I don't know which
version of mysql that
equates to.

I first installed Mandrivia 2006 on the client system,
which comes with 
Mysql 4.1.2 ( MySQL-4.1.12-3mdk.i586.rpm ).  I did an
install, not an
upgrade.  I could still connect to gandalf with:

mysql -umythtv -pmythtv -hgandalf mythconverg

I then did a mysqldump on mythconverg and install
Mandrivia 2006 on 
server gandalf.  I restored the mythconverg;  Now,  I
get:

[EMAIL PROTECTED] mysql -u mythtv -pmythtv -h gandalf
mythconverg
ERROR 2003 (HY000): Can't connect to MySQL server on
'gandalf' (111)

I then tried granting privledges to mythconverg using
on the server
gandalf:

# mysql -u root mythconverg
mysql grant all on mythconverg.* to mythtv@%
identified by mythtv;
mysql flush privileges;

Still can't connect.

I booted off the old installation and did a mysql dump
of mysql database
and did inserts of the appropriate tables, like the
user table.  Still
can't connect.

I've droped the mythconverg database, recreated a
skeleton of it, granted
the open privledges and still can not connect to it.

Another fact:  on the server gandalf,  I can connect
to the database
as localhost, but not if I specify the host:

gandalf# mysql -u mythtv -pmythtv mythconverg 
Success!!

gandalf# mysql -u mythtv -pmythtv -h gandalf
mythconvergFailure!!

gandalf# mysql -u mythtv -pmythtv -h 10.0.1.40
mythconverg Failure!!

gandalf# mysql -u mythtv -pmythtv -h 127.0.0.1
mythconverg Success!!

gandalf# mysql -u mythtv -pmythtv -h localhost
mythconverg  Success!!

I've already check my /etc/my.cnf file for a binding
line.  Its not 
there.  I also found an item online that indicated
adding:

skip-innodb
set-variable=thread_stack=256k

to /etc/my.cnf was needed for mysql under Mandrake. 
Still no help.


Also,  I can resolve the name/ip of both hosts from
both hosts.  I
can ping each host ( by name ) both ways.  I can ssy (
by name ) between
both hosts.

Thanks,

Mike




__ 
Start your day with Yahoo! - Make it your home page! 
http://www.yahoo.com/r/hs

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

2005-12-04 Thread Simon Garner

On 5/12/2005 11:56 a.m., Mike Smith wrote:

Hi,



Hi,


I've already check my /etc/my.cnf file for a binding
line.  Its not 
there.  I also found an item online that indicated

adding:



Look for the option skip-networking. This disables TCP/IP so the 
server only accepts local connections via the Unix socket. This sounds 
like your situation.


Note that a could not connect error means just that. If the problem 
was related to user privileges you would get an access denied error.


HTH,
-Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
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 w2kpro repsectively)

The client machine can ping the server machine by name or IP address.
One each machine, a local client successfully connects to the local mysql 
server as localhost.
In mysql server on the w2k box, a client row in mysql.user has been created 
with:
   user=the exact value used in the ODBC Admin dialog
   password=the exact value used in the ODBC Admin dialog
   Host=name of the machine being used as a client 
'skip-networking' is not set on either machine.

But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for 
connecting to the mysql server on the w2k machine, clicking 'Test Data Source' 
yields this error:

   Host 'XPBOX' is not allowed to connect to this MySQL server'.

(Oddly, the mysql server capitalizes the name of the winxp box. Why does it do 
that?)

Issuing the command
   telnet w2kbox 3306
on the xpbox also produced this same error message.

This ought to be simple. What's the secret?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 w2kpro repsectively)
 
 The client machine can ping the server machine by name or IP address.
 One each machine, a local client successfully connects to the local 
 mysql server as localhost.
 In mysql server on the w2k box, a client row in mysql.user has been 
 created with:
user=the exact value used in the ODBC Admin dialog
password=the exact value used in the ODBC Admin dialog
Host=name of the machine being used as a client 
 'skip-networking' is not set on either machine.
 
 But when ODBCAdmin (3.51) is used to create a DSN on the winxp 
 machine for connecting to the mysql server on the w2k machine, 
 clicking 'Test Data Source' yields this error:
 
Host 'XPBOX' is not allowed to connect to this MySQL server'.
 
 (Oddly, the mysql server capitalizes the name of the winxp box. Why 
 does it do that?)
 
 Issuing the command
telnet w2kbox 3306
 on the xpbox also produced this same error message.
 
 This ought to be simple. What's the secret?
 

From your description, the mostly likely problem is that the password 
field of the user table is NOT a hashed password value. The authentication 
attempt would fail because the database is trying to compare a hashed 
password (coming from your ODBC driver) to a non-hashed value.  Use the 
PASSWORD() function to hash a plain-text password for the user so that it 
will match the authentication attempt from the driver

update mysql.user set password = PASSWORD(`password`) WHERE user = 
'odbclogin';

http://dev.mysql.com/doc/mysql/en/encryption-functions.html

A second reason could be because the MySQL ODBC driver is acting as a 
PRE-4.1 client (it is using the shorter password hashes that existed 
before v4.1). 

update mysql.user set password = OLD_PASSWORD('plaintext_of_password') 
WHERE user = 'odbclogin';

http://dev.mysql.com/doc/mysql/en/old-client.html


Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine






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 machine (xp and w2kpro repsectively)


The client machine can ping the server machine by name or IP address.
One each machine, a local client successfully connects to the local 
mysql server as localhost.
In mysql server on the w2k box, a client row in mysql.user has been 
created with:

  user=the exact value used in the ODBC Admin dialog
  password=the exact value used in the ODBC Admin dialog
  Host=name of the machine being used as a client 
'skip-networking' is not set on either machine.


But when ODBCAdmin (3.51) is used to create a DSN on the winxp 
machine for connecting to the mysql server on the w2k machine, 
clicking 'Test Data Source' yields this error:


  Host 'XPBOX' is not allowed to connect to this MySQL server'.

(Oddly, the mysql server capitalizes the name of the winxp box. Why 
does it do that?)


Issuing the command
  telnet w2kbox 3306
on the xpbox also produced this same error message.

This ought to be simple. What's the secret?


From your description, the mostly likely problem is that the password 
field of the user table is NOT a hashed password value. The authentication 
attempt would fail because the database is trying to compare a hashed 
password (coming from your ODBC driver) to a non-hashed value.  Use the 
PASSWORD() function to hash a plain-text password for the user so that it 
will match the authentication attempt from the driver


update mysql.user set password = PASSWORD(`password`) WHERE user = 
'odbclogin';


http://dev.mysql.com/doc/mysql/en/encryption-functions.html

A second reason could be because the MySQL ODBC driver is acting as a 
PRE-4.1 client (it is using the shorter password hashes that existed 
before v4.1). 

update mysql.user set password = OLD_PASSWORD('plaintext_of_password') 
WHERE user = 'odbclogin';


http://dev.mysql.com/doc/mysql/en/old-client.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


Note that if you set the password by directly editing (UPDATE) the 
mysql.user table like this, you will have to run


  FLUSH PRIVILEGES;

afterward to make the change take effect.

Alternatively, you can set the password with

  SET PASSWORD FOR 'odbclogin'@'xpbox' = PASSWORD('odbc_pass');

or

  SET PASSWORD FOR 'odbclogin'@'xpbox' = OLD_PASSWORD('odbc_pass');

or even

  GRANT USAGE ON *.* TO 'odbclogin'xpbox'%' IDENTIFIED BY 'odbc_pass';

FLUSH PRIVILEGES is not necessary sfter any of these.  See the manual for 
the details http://dev.mysql.com/doc/mysql/en/passwords.html.


Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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, to an 'authentication protocol' message. Apparently 
Connector/ODBC 3.51 uses the old protocol.

Gerald Williams 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 the access
table(s). so, if you've put xpbox.domain.xxx in the access table but
the lookup on the inbound IPnumber only returns xpbox (which is
technically an invalid entry anyway) things will fail.

so, do lookups on the IPnumbers of the client machines and see what's
returned. that's what you want in the mysql access tables.

Flushing privileges permitted a connection from the mysql client. To get the 
ODBC
Admin 'Test Data Source' button to work, I had to create a user table entry 
with a
password hashed by Old_Password(). 

Is ipconfig /all what you mean by lookup on the IPnumbers? That gives the name 
of the client box without domain.xxx. In any event, the 'technically incorrect' 
name
did work, and adding the domain.xxx part of the name to the user record did not 
work.

Gerald Williams

Host=name of the machine being used as a client 
 'skip-networking' is not set on either machine.
 
 But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine
 for connecting to the mysql server on the w2k machine, clicking 'Test
 Data Source' yields this error:
 
Host 'XPBOX' is not allowed to connect to this MySQL server'.
 
 (Oddly, the mysql server capitalizes the name of the winxp box. Why
 does it do that?)
 
 Issuing the command
telnet w2kbox 3306
 on the xpbox also produced this same error message.
 
 This ought to be simple. What's the secret?
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]

-- End Original Message --



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Can not connect to Mysql server with Number 2003

2005-08-05 Thread Nguyen, Phong

All,

In a few minutes ago, I can connect to mysql. Log out and can not login with
error Mysql error Number 2003 can't connect to Mysql server..

Any idea, please help!

Thank you..Nguyen

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Can not connect to Mysql server with Number 2003

2005-08-05 Thread Nuno Pereira

Nguyen, Phong wrote:

All,

In a few minutes ago, I can connect to mysql. Log out and can not login with
error Mysql error Number 2003 can't connect to Mysql server..


Check this: http://dev.mysql.com/doc/mysql/en/access-denied.html

It is a good idea, for now, to check the error logs, there should be an 
explanation about how the server crashed



Any idea, please help!

Thank you..Nguyen



--
Nuno Pereira

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Can not connect to Mysql server with Number 2003

2005-08-05 Thread Gleb Paharenko
Hello.



See:

  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html



Nguyen, Phong [EMAIL PROTECTED] wrote:

 

 All,

 

 In a few minutes ago, I can connect to mysql. Log out and can not login with

 error Mysql error Number 2003 can't connect to Mysql server..

 

 Any idea, please help!

 

 Thank you..Nguyen

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Not able to connect to Mysql server from network machine

2005-06-06 Thread Gleb Paharenko
Hello.



Check with netstat if MySQL is listening on 3306 port on the server. Use

traffic analyzers to see if your packets reach the server. Enable the

general query log on the server to see if server receives your requests to

connect.  See:

  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html

  http://dev.mysql.com/doc/mysql/en/query-log.html





Reema Troiana [EMAIL PROTECTED] wrote:

 Hi All,

 

 I'm trying to connect to MySql server from MySql Administrator on a network 
 machine. I specify the Server host as IP of the machine where DB server is 
 running and Port as 3306.

 

 Username as 'root' and the password

 

 I have tried with other usernames and specifying machine name instead of IP. 
 It doesn't work in any case. 

 

 But i always get this error:

 

 Could not connect to the specififed instance. MySQL Error number 2003 and 
 it says:

 

 If you want to check network connection, please ping

 When i click ping i get reply from the machine i'm trying to connect to

 

 I'm able to connect to localhost, i.e., if i have the DB server on the same 
 machine. MySql server is running on XP machine. Is there any option that i 
 have to enable to make network machine to log on to Mysql DB server??

 

 I'll appreciate any help.

 

 Thanks,

 Reema

 

 

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Not able to connect to Mysql server from network machine

2005-06-06 Thread rtroiana
Hi All,

 

I'm trying to connect to MySql server from MySql Administrator on a network
machine. I specify the Server host as IP of the machine where DB server is
running and Port as 3306.

 

Username as 'root' and the password

 

I have tried with other usernames and specifying machine name instead of IP.
It doesn't work in any case. 

 

But i always get this error:

 

Could not connect to the specififed instance. MySQL Error number 2003 and
it says:

 

If you want to check network connection, please ping

When i click ping i get reply from the machine I'm trying to connect to

 

I'm able to connect to localhost, i.e., if i have the DB server on the same
machine. MySql server is running on XP machine. Is there any option that i
have to enable to make network machine to log on to Mysql DB server??

 

I'll appreciate any help.

 

Thanks,

Reema Duggal Troiana
Senior Software Developer
BitArmor Systems, Inc.
357 North Craig Street
Ground Floor
Pittsburgh, PA 15213
[TEL] 412-682-2200 Ext 314
[FAX] 412-682-2201

 



Re: Not able to connect to Mysql server from network machine

2005-06-06 Thread SGreen
rtroiana [EMAIL PROTECTED] wrote on 06/06/2005 08:42:18 AM:

 Hi All,

 
 I'm trying to connect to MySql server from MySql Administrator on a 
network
 machine. I specify the Server host as IP of the machine where DB server 
is
 running and Port as 3306.

 
 Username as 'root' and the password

 
 I have tried with other usernames and specifying machine name instead of 
IP.
 It doesn't work in any case.

 
 But i always get this error:

 
 Could not connect to the specififed instance. MySQL Error number 2003 
and
 it says:

 
 If you want to check network connection, please ping

 When i click ping i get reply from the machine I'm trying to connect 
to

 
 I'm able to connect to localhost, i.e., if i have the DB server on the 
same
 machine. MySql server is running on XP machine. Is there any option that 
i
 have to enable to make network machine to log on to Mysql DB server??

 
 I'll appreciate any help.

 
 Thanks,

 Reema Duggal Troiana
 Senior Software Developer
 BitArmor Systems, Inc.
 357 North Craig Street
 Ground Floor
 Pittsburgh, PA 15213
 [TEL] 412-682-2200 Ext 314
 [FAX] 412-682-2201
 
Not everyone works or lurks on the weekends. Have you tried to RTFM?

http://dev.mysql.com/doc/mysql/en/post-installation.html
http://dev.mysql.com/doc/mysql/en/problems.html
(especially) 
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
(and) http://dev.mysql.com/doc/mysql/en/starting-server.html

Use the TELNET test connection method (described in the readings) to 
verify you have a working network path from your remote server to the 
MySQL server. By the domain in your return address, I believe you work for 
someone who is more likely than not to have several restrictions on your 
network traffic. Anything that prevents traffic through port 3306 (unless 
you told your MySQL daemon to use a different port) between your two 
machines will prevent your connection.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



Re: Not able to connect to Mysql server from network machine

2005-06-06 Thread rtroiana
Thanks Gleb. I just had to manually make changes in my firewall. I allowed
requests to port 3306  mysqld.exe in exceptions tab and it solved the
problem. The only reason I didn't think about firewall setting before since
whenever I try to run new service, I wud get a pop up from Firewall asking
to allow the service or not. 

 

Thanks,

Reema 

 



Not able to connect to Mysql server from network machine

2005-06-05 Thread Reema Troiana
Hi All,

I'm trying to connect to MySql server from MySql Administrator on a network 
machine. I specify the Server host as IP of the machine where DB server is 
running and Port as 3306.

Username as 'root' and the password

I have tried with other usernames and specifying machine name instead of IP. It 
doesn't work in any case. 

But i always get this error:

Could not connect to the specififed instance. MySQL Error number 2003 and it 
says:

If you want to check network connection, please ping
When i click ping i get reply from the machine i'm trying to connect to

I'm able to connect to localhost, i.e., if i have the DB server on the same 
machine. MySql server is running on XP machine. Is there any option that i have 
to enable to make network machine to log on to Mysql DB server??

I'll appreciate any help.

Thanks,
Reema

 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-03 Thread Joshua J. Kugler
Please don't respond directly to me if you have further questions, as 
you would probably be more likely to get better help from the list.

It sounds like a typical database connection?  What is your problem?  
What are the errors you are getting?  All you have said so far is that 
you need help, and here is how you are doing it.  If you can get a 
TCP/IP connection on the mobile device, you should be good to go.

j- k-

On Tuesday 01 March 2005 22:44, you said something like:
 Thank you for your Reply,

 Yes I have a TCP/IP connection on the WinCE device.

 My VB application on the ipaq gets its data from a DB on the device.
 I use ADOCE to connect to this DB, this DB on the device synchronizes
 with a MYSQL DB, and currently I have a desktop application that
 handles the synchronization. This means I physically plug in to a
 desktop PC with a USB cable and then sync the 2 DBs. So what I want
 to do is move the sync app to the CE Device and connect to MYSQL
 directly from the mobile device.

 Hope this gives you a better idea of the problem.

 Regards
 Hough

  Joshua J. Kugler [EMAIL PROTECTED] 03/02/05 9:07 AM 

 On Wednesday 23 February 2005 03:47, Hough Van Wyk said something

 like:
  I am developing a embedded VB application running on a hp ipaq
  running Windows CE 2003. This app has to connect to a MYSQL DB over

 a

  wireless network. I have surfed the internet for hours with no
  luck. Can anyone please help me with this problem.

 What exactly is your problem?  Do you have a TCP/IP connection on the
 WinCE device?  Will the MySQL ODBC drivers run on the device (or does
 your programming environment have its own drivers, such as the
 light-weight drivers for VB)?  What have your tried?  If it's a
 standard ethernet connection, there is no difference than if you were
 plugged into a wall.

 What exactly are you looking for in your search?

 j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-01 Thread Joshua J. Kugler
On Wednesday 23 February 2005 03:47, Hough Van Wyk said something like:
 I am developing a embedded VB application running on a hp ipaq
 running Windows CE 2003. This app has to connect to a MYSQL DB over a
 wireless network. I have surfed the internet for hours with no luck.
 Can anyone please help me with this problem.

What exactly is your problem?  Do you have a TCP/IP connection on the 
WinCE device?  Will the MySQL ODBC drivers run on the device (or does 
your programming environment have its own drivers, such as the 
light-weight drivers for VB)?  What have your tried?  If it's a 
standard ethernet connection, there is no difference than if you were 
plugged into a wall.

What exactly are you looking for in your search?

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-02-23 Thread Hough Van Wyk
Hi All,

I am developing a embedded VB application running on a hp ipaq running
Windows CE 2003. This app has to connect to a MYSQL DB over a wireless
network. I have surfed the internet for hours with no luck. Can anyone
please help me with this problem.

Regards
Hough

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Terence
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h IPADDR -u replication -p
I can connect successfully, but my error logs show
041221  1:12:41  Slave I/O thread: error connecting to master 
'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to 
MySQL server on 'IPADDR # MUST BE SET' (111)'  errno: 2003  
retry-time: 60  retries: 86400

Google hasnt turned up anything useful. Any ideas anyone? What am I 
doing wrong.

Master
# The MySQL server
[mysqld]
server-id=1
log-bin
Slave
# The MySQL server
[mysqld]
server-id=9
master-host=IPADDR
master-port=
master-user=replication
master-password=password
show master status
bin.0001 position: 4486513
thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Gleb Paharenko
Hello.



When you are connecting using mysql, you usually don't specify the destination 
port.

By default it's 3306.

And at the same time master-port=. Send us complete contents of config

files. What is in master error log? Check to what port slave instance is trying

to connect (with tcpdump, netstat for example).





Terence [EMAIL PROTECTED] wrote:

 Hi,

 

 I am trying to setup replication on MySQL.

 

 Version 4.1.0alpha

 

 Using:

 ./bin/mysql -h IPADDR -u replication -p

 I can connect successfully, but my error logs show

 

 041221  1:12:41  Slave I/O thread: error connecting to master 

 'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to 

 MySQL server on 'IPADDR # MUST BE SET' (111)'  errno: 2003  

 retry-time: 60  retries: 86400

 

 Google hasnt turned up anything useful. Any ideas anyone? What am I 

 doing wrong.

 

 Master

 # The MySQL server

 [mysqld]

 server-id=1

 log-bin

 

 Slave

 # The MySQL server

 [mysqld]

 server-id=9

 master-host=IPADDR

 master-port=

 master-user=replication

 master-password=password

 

 show master status

 bin.0001 position: 4486513

 

 thanks!

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Terence
I found that restarting the mysql server does not recreate the 
master.info file in the data directory. Although I had changed some 
settings in the /etc/my.cnf they did not populate the master.info file. 
So after banging my head for so many hours I deleted the master.info 
file and restarted the server. So that's where the # MU came from.

On a seperate note for those experiencing problems on error 1189 Net 
error reading from master - the problem appears to be innodb tables 
which are not supported by LOAD TABLE FROM MASTER. That's going to be an 
extremely tough one to get around.

Thanks Gleb for your help.
Gleb Paharenko wrote:
Hello.
When you are connecting using mysql, you usually don't specify the destination 
port.
By default it's 3306.
And at the same time master-port=. Send us complete contents of config
files. What is in master error log? Check to what port slave instance is trying
to connect (with tcpdump, netstat for example).
Terence [EMAIL PROTECTED] wrote:
 

Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h IPADDR -u replication -p
I can connect successfully, but my error logs show
041221  1:12:41  Slave I/O thread: error connecting to master 
'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to 
MySQL server on 'IPADDR # MUST BE SET' (111)'  errno: 2003  
retry-time: 60  retries: 86400

Google hasnt turned up anything useful. Any ideas anyone? What am I 
doing wrong.

Master
# The MySQL server
[mysqld]
server-id=1
log-bin
Slave
# The MySQL server
[mysqld]
server-id=9
master-host=IPADDR
master-port=
master-user=replication
master-password=password
show master status
   

bin.0001 position: 4486513
 

thanks!
   


 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Can't connect to MySQL server - Operation now in progress

2004-08-19 Thread Alex Greg
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...) 
failed: Can't connect to MySQL server on '10.1.1.80' (115) at 
/usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214

This happens on a number of our servers, in different hosting centres, 
connecting to different database servers, running different versions of 
MySQL, so I don't think this points to any specific 
hardware/software/network issues.

One set of servers are running Red Hat Linux versions 6.2 to RHEL 2.1, 
networked over 10/100 ethernet, connecting to MySQL on a remote host 
(version 3.22.32) via Perl DBD::mysql.

Another set of servers are running Red Hat Enterprise Linux 2.1, 
networked over 10/100 ethernet, connecting to MySQL on a remote host 
(version 3.23.55) via Perl DBD::mysql.

The third set of servers are running Fedora Core 1, networked over 
gigabit copper ethernet, connecting to MySQL on a remote host (version 
4.0.20) via perl DBD::mysql.

Any advice or pointers anyone can give on this would be greatly appreciated.
Regards,
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Q: Can't Connect to MySql Server

2004-02-24 Thread Danny Pudianto
Hello,
 
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen  ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061)
 
Thanks
Dani


-
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.

Re: Q: Can't Connect to MySql Server

2004-02-24 Thread Paul DuBois
At 17:58 -0800 2/24/04, Danny Pudianto wrote:
Hello,

I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen  ERROR 2003 : Can't connect to MySql Server on 
'localhost' (10061)
Did you start the server (mysqld) first?

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Can't connect to MySQL server on 'localhost' (10061)- solution pls

2004-01-29 Thread Arunachalam
Hi all,

I have the  following settings in *my.ini* (obtined from WinMySQLadmin)

#This File was made using the WinMySQLAdmin 1.4 Tool
#12/11/2003 10:50:28 AM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/Program Files/mysql
#bind-address=192.168.2.5
datadir=C:/Program Files/mysql/data
language=C:/Program Files/mysql/share/english
#slow query log#=
#tmpdir#=
port=3306
set-variable=key_buffer=16M

[client]
host=127.0.0.1
port=3306
#socket=MySQL

[WinMySQLadmin]
Server=C:/Program Files/mysql/bin/mysqld.exe
user=nura
password=***
QueryInterval=10

WIth this settings I'm trying to establish connection to MySQL from COBOL. In COBOL I 
have the
option to call C function as external subroutines. So I have coded in COBOL to invoke 
the C API
provided from MySQL.

I have just coded for mysql_init() and mysql_real_connect(). after the execution of
mysql_real_connect(), i met the error message as;
*Can't connect to MySQL server on 'localhost' (10061)*

I have searched in various discussion forums, the points obtained never able to solve 
my problem.

I have tested with mysqladmin as;

C:\mysqladmin -h localhost --port=3306 version
mysqladmin  Ver 8.40 Distrib 4.0.17, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX 

DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  4.0.17-max-debug
Protocol version10
Connection  localhost via TCP/IP
TCP port3306
Uptime: 25 min 39 sec

Threads: 2  Questions: 165  Slow queries: 0  Opens: 7  Flush tables: 1 Open tables: 1  
Queries per
second avg: 0.107  Memory in use: 16597K  Max memory used: 16627K

Is anyone suggest me to come out from this trouble...

thanks in advance...

Regards,
Arun.


Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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

2004-01-29 Thread [EMAIL PROTECTED]
Your password is wrong.  You probably need to read the manual that is in 
the docs directory.  There are some issues about passwords with 4.1.1.  
I don't have time to walk you through  the entire setup, but will be 
glad to help with simple questions.

Since you can connect on the server, the install should be fine.  There 
is no setup program.  You just unzip it to your hard drive. 
Use mysqlCC or some other tool on the server to change users/passwords.  
This is in the mysql.user table.  Make sure that the host column  is set 
to % and not just localhost also.

mysql test -h localhost -u username -ppasswd
	- Access denied using PW (YES)

--I would delte the my.ini file(don't know if 4.1.1 even uses that)I don't use one.
--the reason you can connect from localhost is because a password is not set.
--search for all issues regarding passwords with 4.1.1(docs,readme's,release 
notes/known issues)
hope this helps

brian

[EMAIL PROTECTED] wrote:

OK.  Thanks. Late now, and laptop is off. Client is the mysql.exe
program.
I have to copy the mysql.exe to the laptop (or cd to the server machine
and execute from it. Leave the space out.
Right now, just fooling around from the server machine:

mysql test -h localhost 
	- works fine. 
mysql test -h localhost -u username
	- works fine
mysql test -h localhost -u username -ppasswd
	- Access denied using PW (YES)

I use the pw that is in the my.ini

Using any of the above fails to allow connection using the laptop--but
I'll try again tomorrow.
I suspect I did something wrong in the install, though everything seems
to work from the host machine.
I unzipped the the 4.1.1 catalog in winzip, read the readme that said
run setup.  There was no setup so I simply unzipped to the \temp
directory. I ran mysqladmin, mysql, the mysqlcc (control center) and all
worked. It did not install like a 'regular' program (put itself in the
add software list in control panel), so I simply moved all the files to
a mysql directory and everything continued to work. Had to be too
simple.
Well, I'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 'localhost' (10061)

 

I've executed the mysql -h ip -u user -p pw
   

No space after -p.  I know it's weird, but it's the only way it will
work. So, use this: mysql -h ip -u user -ppw
 

With the result that I get asked for a PW and then told I can't 
connect.
   

You shouldn't get asked for PW if you use the above syntax correctly.

 

But, I don't have the 4.1.1 client.  Where is it?
   

If you downloaded mysql4.1.1 to your laptop, then you have it.
Otherwise: http://www.mysql.com/downloads/mysql-4.1.html
 

There is no '...client' in the bin directory.
   

By client, I mean the mysql file in the bin dir.
If you set your system path, you won't need to actually be in the bin
dir.
Otherwise you need to cd to that dir.  So the entire proc is:

1.Open command prompt.

2.cd C:\mysql\bin

3.mysql -h ip -u user -ppw

 

--
This mail composed and sent using Mozilla Thunderbird.
(http://www.mozilla.org/projects/thunderbird/)
-It's a brave, GNU world!(sorry Bill)--
http://www.linux.org
OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd.
(1f U sp3ll l1k3 th1s, gu3ss wh1ch U R)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


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

2004-01-28 Thread N. Chris Frost
With several others, I too have this problem.

MySQL 4.1.1 installed without a problem. The sqlAdmin is running. I can
run the control center and/or mysql to do sql things.

This, though, is all from the server (a PC running Win ME).  I want to
connect from my laptop.

What do I have to do? Executing telnet to the PC won't work (probably
need the a telnet server). 

When I move to the shared directory on the PC and try to execute mysql,
I get the error.

Thanks for an assistance.

N. Chris Frost
 



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 installed without a problem. The sqlAdmin is running. I can
run the control center and/or mysql to do sql things.
This, though, is all from the server (a PC running Win ME).  I want to
connect from my laptop.
What do I have to do? Executing telnet to the PC won't work (probably
need the a telnet server). 

When I move to the shared directory on the PC and try to execute mysql,
I get the error.
Thanks for an assistance.

N. Chris Frost
 


--
Brian Harris
Application Developer
OptData Inc./ATRS
[EMAIL PROTECTED]
(501)907.5912
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


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

2004-01-28 Thread [EMAIL PROTECTED]
I've executed the mysql -h ip -u user -p pw
No space after -p.  I know it's weird, but it's the only way it will work.
So, use this: mysql -h ip -u user -ppw
With the result that I get asked for a PW and then told I can't connect.
You shouldn't get asked for PW if you use the above syntax correctly.

But, I don't have the 4.1.1 client.  Where is it?
If you downloaded mysql4.1.1 to your laptop, then you have it. Otherwise:
http://www.mysql.com/downloads/mysql-4.1.html
There is no '...client' in the bin directory.
By client, I mean the mysql file in the bin dir.
If you set your system path, you won't need to actually be in the bin dir.
Otherwise you need to cd to that dir.  So the entire proc is:

1.Open command prompt.

2.cd C:\mysql\bin

3.mysql -h ip -u user -ppw

--

This mail composed and sent using Mozilla Thunderbird.
(http://www.mozilla.org/projects/thunderbird/)
-It's a brave, GNU world!(sorry Bill)-
 http://www.linux.org
OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd.
(1f U sp3ll l1k3 th1s, gu3ss wh1ch U R)
:

Thanks for the reply. I've executed the mysql -h ip -u user -p pw

With the result that I get asked for a PW and then told I can't connect.

But, I don't have the 4.1.1 client.  Where is it? There is no
'...client' in the bin directory.
Thanks,

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 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 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 installed without a problem. The sqlAdmin is running. I 
can run the control center and/or mysql to do sql things.

This, though, is all from the server (a PC running Win ME).  I want to
   

 

connect from my laptop.

What do I have to do? Executing telnet to the PC won't work (probably 
need the a telnet server).

When I move to the shared directory on the PC and try to execute 
mysql, I get the error.

Thanks for an assistance.

N. Chris Frost



   

--

 

--
This mail composed and sent using Mozilla Thunderbird.
(http://www.mozilla.org/projects/thunderbird/)
-It's a brave, GNU world!(sorry Bill)--
http://www.linux.org
OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd.
(1f U sp3ll l1k3 th1s, gu3ss wh1ch U R)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


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 installed without a problem. The sqlAdmin is running. I can
run the control center and/or mysql to do sql things.
This, though, is all from the server (a PC running Win ME).  I want to
connect from my laptop.
What do I have to do? Executing telnet to the PC won't work (probably
need the a telnet server). 

When I move to the shared directory on the PC and try to execute mysql,
I get the error.
Thanks for an assistance.

N. Chris Frost
 


--

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server

2004-01-18 Thread Mike Mapsnac
Weird.  I cannot find the my.cnf (configuration file).. How that's possible?

Thanks


From: Victor Medina [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Mysql Installation on Linux:  ERROR 2002: Can't connect 
tolocal MySQL server th
Date: Sun, 18 Jan 2004 10:24:53 -0400

Probably your server is not using any sockets, check out your my.cnf.

man mysql
to see how to connect to a ip based mysql host. C/ya!
On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote:

 I just install MYSQL on Linux (Red Hat 9)
 using this manual:http://www.mysql.com/doc/en/Installing_binary.html
 Have no idea what's wrong. I looked on the mysql.log file and the file 
is
 empty.

 ERROR MESSAGE:
 [EMAIL PROTECTED] bin]# ./mysql
 ERROR 2002: Can't connect to local MySQL server through socket
 '/tmp/mysql.sock' (2)
 [EMAIL PROTECTED] bin]# ./mysql status
 ERROR 2002: Can't connect to local MySQL server through socket
 '/tmp/mysql.sock'

 _
 Scope out the new MSN Plus Internet Software  optimizes dial-up to the 
max!
http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1

--

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325  |
 ||geek by nature - linux by choice  |
 |...|
...
Programming today is a race between software engineers striving
to build bigger and better idiot-proof programs, and the Universe
trying to produce bigger and better idiots.
So far, the Universe is winning.
Rich Cook
_
Check out the new MSN 9 Dial-up — fast  reliable Internet access with prime 
features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


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

2004-01-12 Thread Rich Green
Thanks for responding randy. so I checked my my.ini file and the address is set to 
127.0.0.1. I checked the database error file and it was empty. I posted the my.ini 
file down below. Any other suggestions ? When I try to startmysql through the MSDOS 
prompt it says 
 
C:\Program Files\EasyPHP1-7\mysql\binmysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
 
My my.ini file
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
skip-innodb
bind-address=127.0.0.1
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1
# Uncomment the following if you want to log updates
#log-bin
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = C:/Program Files/EasyPHP1-7/mysql/
datadir = C:/Program Files/EasyPHP1-7/mysql/data/

# Uncomment the following if you are NOT using BDB tables
#skip-bdb
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:100M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[mysqlhotcopy]
interactive-timeout

 


Randy Clamons [EMAIL PROTECTED] wrote:
Check your my.ini (in c:\WINNT or c:\windows) for the bind-address. To 
force TCP connection
the address should be set to 127.0.0.1. When connecting from PHP, connect 
to 127.0.0.1 instead
of localhost. Specifying localhost as the address attempts to connect with 
named pipe.

Also, check your [database].err file (located in the mysql/data folder) for 
any errors while starting
the server.

Randy

At 11:32 AM 01/12/2004 -0800, you wrote:
So I recently removed firepages PHP 4.0, and then installed the EasyPHP 
package 1.7(MYSQL, APACHE, PHP) . When it starts up everything runs except 
MYSQL the program is installed in the C:Program files- EASY PHP1.7- 
MYSQL. I recieve the following error,
Can't connect to MySQL server on 'localhost' (10061)

Do I need to change the port setting? or do I need to install in the C:/ 
folder?

any advice is muchly appreciated.

rich


-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes

Thanks for using Astro-Auction.com.

Randy Clamons
Systems Programming



-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes

Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
I'm new to the list, hope this is the correct mailing list.

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
I can also connect through phpmyadmin (remotely or locally).
http://xxx.168.xxx.xxx/phpmyadmin/
but I can't connect if I put in the IP address (locally or remotely)
 mysql -h xxx.168.xxx.xxx -p
password:
ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) --- 
locally
ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (61) --  
remotely

I've looked all through the documentation from MySQL and the archives 
on the web.  From looking at the docs, it seems that my problem either 
lies in how the user accounts are set up for how the server is set up.  
My guess is the user accounts.  I've set up the user to be able to 
connect from anywhere.  Summary(user: xxx, host: %, password: Yes, 
privileges: ALL PRIVILEGES , grant: Yes).  I used phpmyadmin to set up 
the accounts.

Thanks in advance,

Aaron-

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


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 line 'skip-networking' from /etc/mysql/my.cnf,
type /etc/init.d/mysql restart and
try connecting to the IP address again.

-- 
Johannes Franken
 
MySQL Professional
mailto:[EMAIL PROTECTED]
http://www.jfranken.de/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 using the -u parameter. The user you are logging in with will be
the user of your current linux session. root?

 I can also connect through phpmyadmin (remotely or locally).
 http://xxx.168.xxx.xxx/phpmyadmin/

This is a different type of connection. A web server is running on
xxx.168.xxx.xxx, phpmyadmin is installed on it. You are connecting to the
web server with your browser.

 but I can't connect if I put in the IP address (locally or remotely)
   mysql -h xxx.168.xxx.xxx -p
 password:
 ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) ---
 locally
 ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (61) --
 remotely

You don't use the -u parameter. This means the current user name is used.
Did you try this logged in to linux as a user named xxx? (Where
'xxx' is the name you have defined in phpmyadmin)

 I've looked all through the documentation from MySQL and the archives
 on the web.  From looking at the docs, it seems that my problem either
 lies in how the user accounts are set up for how the server is set up.
 My guess is the user accounts.  I've set up the user to be able to
 connect from anywhere.  Summary(user: xxx, host: %, password: Yes,
 privileges: ALL PRIVILEGES , grant: Yes).  I used phpmyadmin to set up
 the accounts.

With this setup, the user xxx should be able to log in from any host,
but you should use -u xxx when you start the mysql client:

mysql -h xxx.168.xxx.xxx -u xxx -p

Note that there are two ways to connect to the mysql server: using sockets
(or named  pipes on windows) or using TCP/IP. If you provide -h
hostname-or-ip-address a TCP/IP connection is used, if you provide -h
localhost or no -h parameter, a unix socket is used.

You are not running the server with --skip-networking, are you? If you
are, TCP/IP support is disabled. Have you configured the server to use a
non-standard port (different from 3306)? In that case, you must provide port
number when starting the client:

mysql -h xxx.168.xxx.xxx --port=3307 -u xxx -p

URL: http://www.mysql.com/doc/en/Can_not_connect_to_server.html 

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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.

Thanks again.

Aaron-

On Jan 10, 2004, at 3:20 PM, Johannes Franken wrote:

* 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 line 'skip-networking' from /etc/mysql/my.cnf,
type /etc/init.d/mysql restart and
try connecting to the IP address again.
On Jan 10, 2004, at 3:30 PM, Roger Baklund wrote:
Note that there are two ways to connect to the mysql server: using 
sockets
(or named  pipes on windows) or using TCP/IP. If you provide -h
hostname-or-ip-address a TCP/IP connection is used, if you provide -h
localhost or no -h parameter, a unix socket is used.

You are not running the server with --skip-networking, are you? If 
you
are, TCP/IP support is disabled. Have you configured the server to use 
a
non-standard port (different from 3306)? In that case, you must 
provide port
number when starting the client:

mysql -h xxx.168.xxx.xxx --port=3307 -u xxx -p


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


problem trying to connect to MySQL server

2003-12-29 Thread Jon Miller
I'm having a problem with one of our MySQL servers.  
Setup
VPN with Firewall at main office (iptables),
remote office currently has 2 MySQL servers and their port numbers are
3306 (server1) and 3309 (server2)
Programmer accesses server1 okay from his location, but cannot access
server2.  He will be moving data from server1 to the new server2.
Error msg:  error no. Can't conect to mysql server at '192.168.0.15'
(10061).


Thanks
-- 
Jon Miller [EMAIL PROTECTED]
MMT Networks Pty Ltd



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: problem trying to connect to MySQL server

2003-12-29 Thread Director General: NEFACOMP
Maybe port 3309 is not open on the firewall or there is no rule set for it
or it is blocked.
I am not a network expert though!!!


Thanks
Emery
- Original Message -
From: Jon Miller [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, December 29, 2003 13:44
Subject: problem trying to connect to MySQL server


 I'm having a problem with one of our MySQL servers.
 Setup
 VPN with Firewall at main office (iptables),
 remote office currently has 2 MySQL servers and their port numbers are
 3306 (server1) and 3309 (server2)
 Programmer accesses server1 okay from his location, but cannot access
 server2.  He will be moving data from server1 to the new server2.
 Error msg:  error no. Can't conect to mysql server at '192.168.0.15'
 (10061).


 Thanks
 --
 Jon Miller [EMAIL PROTECTED]
 MMT Networks Pty Ltd



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 SQLyog (from Windows) I get the same error
 (near enough) from both:
 
 SQLyog:
 
---
SQLyog
---
Error No. 2003
Can't connect to MySQL server on '[server]' (10061)
---
 
 MySQL Control Center:
 
[server] ERROR 2003: Can't connect to MySQL server on '[server]'
 (10061)
 
 Searching through the mysql.com documentation led me to
 http://www.mysql.com/doc/en/Can_not_connect_to_server.html, which talks
 about unix and tcp/ip sockets. Running mysqladmin version gives me the
 following output:
 
mysqladmin  Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult
 AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
 software,
and you are welcome to modify and redistribute it under the GPL
 license

Server version  4.0.13-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 2 hours 6 min 24 sec

Threads: 3  Questions: 450  Slow queries: 0  Opens: 16  
Flush tables: 1  Open tables: 5  Queries per second avg: 0.059
 
 Since the documentation (I forget where) showed the version output
 showing the tcp port the server was running on (and mine doesn't), I am
 led to believe the server isn't running on a tcp/ip socket. From what I
 can tell though, my.cnf does have the necessary lines for doing this -
 port=3306 (as per default) is in there, uncommented-out.
 
 Can anyone suggest what I might need to change in my configuration to
 enable tcp/ip connections? All the search results I've seen so far
 appear only to relate to people running MySQL (server) under windows...
 

Did you run MySQL server with --skip-networking option?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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

2003-10-24 Thread Ben Darlow
Hi,

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 SQLyog (from Windows) I get the same error
(near enough) from both:

SQLyog:

---
SQLyog
---
Error No. 2003
Can't connect to MySQL server on '[server]' (10061)
---

MySQL Control Center:

[server] ERROR 2003: Can't connect to MySQL server on '[server]'
(10061)

Searching through the mysql.com documentation led me to
http://www.mysql.com/doc/en/Can_not_connect_to_server.html, which talks
about unix and tcp/ip sockets. Running mysqladmin version gives me the
following output:

mysqladmin  Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult
AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL
license

Server version  4.0.13-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 2 hours 6 min 24 sec

Threads: 3  Questions: 450  Slow queries: 0  Opens: 16  
Flush tables: 1  Open tables: 5  Queries per second avg: 0.059

Since the documentation (I forget where) showed the version output
showing the tcp port the server was running on (and mine doesn't), I am
led to believe the server isn't running on a tcp/ip socket. From what I
can tell though, my.cnf does have the necessary lines for doing this -
port=3306 (as per default) is in there, uncommented-out.

Can anyone suggest what I might need to change in my configuration to
enable tcp/ip connections? All the search results I've seen so far
appear only to relate to people running MySQL (server) under windows...

Cheers,
Ben Darlow

---Disclaimer---

Unless obviously public, this email is confidential to the intended recipient(s). If 
you received it in error please tell the sender and then delete it. We check emails 
from dyslexic.com and iansyst.co.uk, but you should virus check incoming emails. 
Emails do not always represent our official policy or a contract. Errors and omissions 
are excepted.

iANSYST Ltd, Fen House, Fen Road, CAMBRIDGE, CB4 1UN. T +44(0)1223 420101; Fax +44(0) 
1223 42 66 44; [EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Re: cant connect to mysql server through socket

2003-07-30 Thread Petre Agenbag
Did you build mysql yourself, or did you install it along with Suse?

If it's installed with suse, start the mysql service via the suse method
(not sure what that is, on RedHat, one would simply say service mysqld
start).
If you built it by installing the binary, then your mysql should be
located in /usr/local/mysql
to start, cd to that folder and say
bin/mysqld_safe (for 4.x)
or
bin/safe_mysqld  (for 3.x)

Also, if you installed the binary, make sure the folder that contains
the mysql files ( /usr/local/mysql is a symlink to the actual location)
is owned by mysql user (chown -R mysql.mysql /path/to/files


From the sounds of things however, it looks like you are trying to use
the version that came with suse.

For that, you normally need to run the mysql_install_db script first,
and then start the mysql daemon. Then you need to run mysqladmin to set
a root password and configure the grants
usually, 
mysqladmin -u root password 'your_root_password_for_mysql'
will set the root password. You will need to restart the mysql daemon
after that.


On Wed, 2003-07-30 at 13:07, D. K. wrote:
 Petre; 
 Running ps -aux i cannot see mysql among listed processes. I checked mysql folders 
 under several 
 directories , they are owned by root. Also mysql start/mysql stop etc. commands dont 
 work producing the 
 same warning Cant connect.. What can i do more? 
 Thanks 
 Devrim 
  
 Petre Agenbag [EMAIL PROTECTED] schrieb am 28.07.03 08:35:48: 
   
  1) make sure mysql is running [and as user mysql] do a ps -aux to see. 
  2) make sure that the mysql folder and files are owned by mysql (ls -l) 
   

  On Sun, 2003-07-27 at 10:38, D. K. wrote: 
   Hi; 
   I have installed suse 8.2 a short while ago and at my first attempt to connect 
   mysql (via shell and a 
 perl dbi script) i get following error:  

   can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'.  

   i know this looks like a common error and I am terribly sorry if this kind of 
   subject has been posted 
 before but I'll appreciate any urgent help. 
   Thanks 
   Devrim 

   __ 
   ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei  
   WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121

   
  
 __
 ComputerBild (15-03) empfiehlt: Der beste Spam-Schutz ist bei
 WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021124
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Re: Re: cant connect to mysql server through socket

2003-07-30 Thread Petre Agenbag
Don't stare too long at the Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) , it will blind you after a
couple of minutes ;p
Seriously, the fact that the sock file is not there simply tells me that
mysql is not running, ie, even if you could copy a  mysql.sock file to
that location, your problems would still be there. the sock file is
created by mysql when it starts up.
You should first run the mysql_install_db script, then start mysql, then
set the password. mysqladmin won't run either if mysql daemon is not
running.

what I suggest you do is to check that mysql is set to start in
runlevels 3 to 5 in your init scripts, then reboot the machine and see
if suse will have better luck in starting mysql.

You can't do anything before mysql is not running.

Also, check to see in your my.cnf file that all the values listed there
makes sense for your system.


On Wed, 2003-07-30 at 15:04, D. K. wrote:
   
 Petre; 
 My installation is coming with suse.I ran mysql_install_db and after that i tried 
 setting root passwd as you 
 see below,and i got foollowing errors. I had checked mentioned socket under 
 /var/lib/mysql  -mysql.sock- 
 before and it doesnt exist. Blame me for not reporting it before. 
 Thank you for kind help. 
 Devrim 
  

 linux:/usr/bin # mysqladmin -u root password 'devrim' 
 mysqladmin: connect to server at 'localhost' failed 
 error: 'Can't connect to local MySQL server through socket 
 '/var/lib/mysql/mysql.sock' (2)' 
 Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' 
 exists! 
  
   
  
 __
 Wo gibt es den besten Spam-Schutz? Laut ComputerBild 15-03 bei
 WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021122
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: cant connect to mysql server through socket

2003-07-28 Thread Petre Agenbag
1) make sure mysql is running [and as user mysql] do a ps -aux to see.
2) make sure that the mysql folder and files are owned by mysql (ls -l)

 
On Sun, 2003-07-27 at 10:38, D. K. wrote:
 Hi;
 I have installed suse 8.2 a short while ago and at my first attempt to connect mysql 
 (via shell and a perl dbi script) i get following error: 
 
 can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. 
 
 i know this looks like a common error and I am terribly sorry if this kind of 
 subject has been posted before but I'll appreciate any urgent help.
 Thanks
 Devrim
 
 __
 ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei 
 WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



cant connect to mysql server through socket

2003-07-27 Thread D. K.
Hi;
I have installed suse 8.2 a short while ago and at my first attempt to connect mysql 
(via shell and a perl dbi script) i get following error: 

can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. 

i know this looks like a common error and I am terribly sorry if this kind of subject 
has been posted before but I'll appreciate any urgent help.
Thanks
Devrim

__
ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei 
WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: cant connect to mysql server through socket

2003-07-27 Thread Sanya Shaik

What version of mysql are you using ?
check the location of mysql.sock it probably is in 
/tmp/mysql/mysql.sock
check the sock location in my.cnf 
  


--- D. K. [EMAIL PROTECTED] wrote:
 Hi;
 I have installed suse 8.2 a short while ago and at
 my first attempt to connect mysql (via shell and a
 perl dbi script) i get following error: 
 
 can't connect to mysql server through socjet
 '/var/lib/mysql/mysql.sock'. 
 
 i know this looks like a common error and I am
 terribly sorry if this kind of subject has been
 posted before but I'll appreciate any urgent help.
 Thanks
 Devrim
 

__
 ComputerBild 15-03 bestaetigt: Den besten
 Spam-Schutz gibt es bei 
 WEB.DE FreeMail - Deutschlands beste E-Mail -
 http://s.web.de/?mc=021121
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:   

http://lists.mysql.com/[EMAIL PROTECTED]
 


__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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

2003-07-16 Thread Rodger Nixon
Hi All:

 

I am trying to run mysql in a Windows XP environment.  I downloaded the
binary and installation went smoothly.  What I am expecting is that if I
have winmysqladmin in my startup it should launch and I should be able to
connect using the mysql control centre as my client.  So far no joy.
Unfortunately the error message conveys no useful information as to where my
problem lies.   I am presuming something in the configuration of the server
or clients is incorrect but I have no idea of what it is.

 

My.ini is:

 

#This File was made using the WinMySQLAdmin 1.4 Tool

#7/11/2003 9:45:28 AM

 

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

 

[mysqld]

basedir=C:/mysql

#bind-address=24.239.132.16

datadir=C:/mysql/data

#language=C:/mysql/share/your language directory

#slow query log#=

#tmpdir#=

#port=3306

#set-variable=key_buffer=16M

[WinMySQLadmin]

Server=C:/mysql/bin/mysqld.exe

user=root

password=

 

In the cc I have hostname as localhost.

 

I do note that my environment details as displayed in the admin program have
details that I do not appear to be able to modify (e.g. an IP address.) If I
try and match these I find the client wants to go out to the internet to
access the server.   What should these details be.

 

Help!



ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread Francisco Castellon
Hello list:
 
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
localhost and also another root user but this one is only allowed to
log in from host.mydomain.com (host being the computer that the mySQL
server is installed in). I understand the difference since localhost is
when you are working on the computer itself (or remotely through ssh)
that has the mySQl server installed and that HOST.MYDOMAIN.COM is the
name of the localhost machine on the LAN. However, if you are accessing
the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same
thing as accessing from localhost? since in order to access the mySQL
server from HOST.MYDOMAIN.COM I would have to be at the machine itself
wouldn't the server just treat that connection as localhost? I have read
on the mysql.com site about how the mySQL server sorts the entries in
the user table at the time the server is started by priority of specific
entries to less specific ones, however if I have a password set for both
[EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be
used? Not that it matters since the set of privileges are the same. I am
just really wondering if I need the extra entry of
[EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would
I ever connect to the mySQL server using the [EMAIL PROTECTED]
account?
 
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
 
Shell mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
 
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.OLYMPUS.LOCAL' (111)  
 
I also tried using the IP of the server:
Shell mysql -u root -h 192.168.1.8 -p
Enter Password: ***
 
And I still got: ERROR 2003: Can't connect to MySQL server on
'192.168.1.8' (111)
 
What does that mean? I tried searching on the list archives but found
nothing on it. And I did check my /etc/hosts file and this is what is in
it:
 
127.0.0.1   localhost
192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS
 
Any help would be appreciated it, thanx!
 
 
 
 


ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread castf
Hello list:

I just finished installing mySQL on a Linux Debian system and I have a question about 
how the 2 root users that are set up by default. When I look at my user table there is 
a root user allowed to log in from localhost and also another root user but this one 
is only allowed to log in from host.mydomain.com (host being the computer that the 
mySQL server is installed in). I understand the difference since localhost is when you 
are working on the computer itself (or remotely through ssh) that has the mySQl server 
installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. 
However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isnt that 
technically the same thing as accessing from localhost? since in order to access the 
mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldnt 
the server just treat that connection as localhost? I have read on the mysql.com site 
about how the mySQL server sorts the entries in the user table at the time the server 
is started by priority of specific entries to less specific ones, however if I have a 
password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection 
would be used? Not that it matters since the set of privileges are the same. I am just 
really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have 
[EMAIL PROTECTED] And how would I ever connect to the mySQL server using the [EMAIL 
PROTECTED] account?

Also I was trying to access the mySQL server using the root@ HOST.MYDOMAIN.COM account 
by using the command below:

Shell mysql u root h ZEUS.OLYMPUS.LOCAL p
Enter Password: ***

And this is what I get: ERROR 2003: Can't connect to MySQL server on 
'ZEUS.OLYMPUS.LOCAL' (111)  

I also tried using the IP of the server:

Shell mysql u root h 192.168.1.8 p
Enter Password: ***

And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111)

What does that mean? I tried searching on the list archives but found nothing on it. 
And I did check my /etc/hosts file and this is what is in it:

127.0.0.1   localhost

192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS

Any help would be appreciated it, thanx!




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread Francisco Castellon
Hello list:
 
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
localhost and also another root user but this one is only allowed to
log in from host.mydomain.com (host being the computer that the mySQL
server is installed in). I understand the difference since localhost is
when you are working on the computer itself (or remotely through ssh)
that has the mySQl server installed and that HOST.MYDOMAIN.COM is the
name of the localhost machine on the LAN. However, if you are accessing
the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same
thing as accessing from localhost? since in order to access the mySQL
server from HOST.MYDOMAIN.COM I would have to be at the machine itself
wouldn't the server just treat that connection as localhost? I have read
on the mysql.com site about how the mySQL server sorts the entries in
the user table at the time the server is started by priority of specific
entries to less specific ones, however if I have a password set for both
[EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be
used? Not that it matters since the set of privileges are the same. I am
just really wondering if I need the extra entry of
[EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would
I ever connect to the mySQL server using the [EMAIL PROTECTED]
account?
 
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
 
Shell mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
 
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.OLYMPUS.LOCAL' (111)  
 
I also tried using the IP of the server:
Shell mysql -u root -h 192.168.1.8 -p
Enter Password: ***
 
And I still got: ERROR 2003: Can't connect to MySQL server on
'192.168.1.8' (111)
 
What does that mean? I tried searching on the list archives but found
nothing on it. And I did check my /etc/hosts file and this is what is in
it:
 
127.0.0.1   localhost
192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS
 
Any help would be appreciated it, thanx!
 
 


Re: ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread [EMAIL PROTECTED]
Francisco Castellon schrieb:
Hello list:
 
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
localhost and also another root user but this one is only allowed to
log in from host.mydomain.com (host being the computer that the mySQL
server is installed in). I understand the difference since localhost is
when you are working on the computer itself (or remotely through ssh)
that has the mySQl server installed and that HOST.MYDOMAIN.COM is the
name of the localhost machine on the LAN. However, if you are accessing
the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same
thing as accessing from localhost? since in order to access the mySQL
server from HOST.MYDOMAIN.COM I would have to be at the machine itself
wouldn't the server just treat that connection as localhost? I have read
on the mysql.com site about how the mySQL server sorts the entries in
the user table at the time the server is started by priority of specific
entries to less specific ones, however if I have a password set for both
[EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be
used? Not that it matters since the set of privileges are the same. I am
just really wondering if I need the extra entry of
[EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would
I ever connect to the mySQL server using the [EMAIL PROTECTED]
account?
 
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
 
Shell mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
 
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.OLYMPUS.LOCAL' (111)  
 
I also tried using the IP of the server:
Shell mysql -u root -h 192.168.1.8 -p
Enter Password: ***
 
And I still got: ERROR 2003: Can't connect to MySQL server on
'192.168.1.8' (111)
 
What does that mean? I tried searching on the list archives but found
nothing on it. And I did check my /etc/hosts file and this is what is in
it:
 
127.0.0.1   localhost
192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS
 
Any help would be appreciated it, thanx!




check it with
tcpdump -ilo port 3306
tcpdump -ieth0 port 3306
...
ping 192.168.1.8
telnet 192.168.1.8 3306
nmap -p3306 zeus.olympus.local
...
hint
$ sed s/ //g endlos.txt endloslang.txt
Hellolist:

JustfinishedinstallingmySQLonaLinuxDebiansystemandIhavea
questionabouthowthe2rootusersthataresetupbydefault.WhenI
lookatmyusertablethereisarootuserallowedtologinfrom
localhostandalsoanotherrootuserbutthisoneisonlyallowedto
loginfromhost.mydomain.com(hostbeingthecomputerthatthemySQL
serverisinstalledin).Iunderstandthedifferencesincelocalhostis
whenyouareworkingonthecomputeritself(orremotelythroughssh)
thathasthemySQlserverinstalledandthatHOST.MYDOMAIN.COMisthe
nameofthelocalhostmachineontheLAN.However,ifyouareaccessing
themySQLserverfromHOST.MYDOMAIN.COMisn'tthattechnicallythesame
thingasaccessingfromlocalhost?sinceinordertoaccessthemySQL
serverfromHOST.MYDOMAIN.COMIwouldhavetobeatthemachineitself
wouldn'ttheserverjusttreatthatconnectionaslocalhost?Ihaveread
onthemysql.comsiteabouthowthemySQLserversortstheentriesin
theusertableatthetimetheserverisstartedbypriorityofspecific
entriestolessspecificones,howeverifIhaveapasswordsetforboth
[EMAIL PROTECTED]@HOST.MYDOMAIN.COMthenwhichconnectionwouldbe
used?Notthatitmatterssincethesetofprivilegesarethesame.Iam
justreallywonderingifIneedtheextraentryof
[EMAIL PROTECTED]@localhost.Andhowwould
[EMAIL PROTECTED]
account?
AlsoIwastryingtoaccessthemySQLserverusingtheroot@
HOST.MYDOMAIN.COMaccountbyusingthecommandbelow:
Shellmysql-uroot-hZEUS.OLYMPUS.LOCAL-p
EnterPassword:***
AndthisiswhatIget:ERROR2003:Can'tconnecttoMySQLserveron
'ZEUS.OLYMPUS.LOCAL'(111)
IalsotriedusingtheIPoftheserver:
Shellmysql-uroot-h192.168.1.8-p
EnterPassword:***
AndIstillgot:ERROR2003:Can'tconnecttoMySQLserveron
'192.168.1.8'(111)
Whatdoesthatmean?Itriedsearchingonthelistarchivesbutfound
nothingonit.AndIdidcheckmy/etc/hostsfileandthisiswhatisin
it:
127.0.0.1localhost
192.168.1.8ZEUS.OLYMPUS.LOCALZEUS
Anyhelpwouldbeappreciatedit,thanx!
/hint
--
shrek-m
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread Francisco Castellon
Hi:

Thanx for the response. But yes the ZEUS.OLYMPUS.LOCAL host is in the
mysql.user database for the user root. There are 2 entries for the root
user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and
they both have the same global privileges set to ALL. I think that I
have to add the IP address as an allowed host though, but I thought that
the mySQL server could resolve the IP to the host name? Thanx!

-Original Message-
From: O'K Web Design [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 05, 2003 8:06 AM
To: Francisco Castellon
Subject: Re: ERROR 2003: Can't connect to MySQL server on 

Hi

I am not an expert but I would make all root privileges global and
make
sure you are allowing log in's by root into any host.  It just sounds
like
ZEUS.OLYMPUS.LOCAL is not on your allowed list.  As far as my
understanding goes, if you are resolving an address, then it would try
to
connect using the 'not' local method.

Mike


- Original Message -
From: Francisco Castellon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: June 5, 2003 2:40 AM
Subject: ERROR 2003: Can't connect to MySQL server on 


 Hello list:

 Just finished installing mySQL on a Linux Debian system and I have a
 question about how the 2 root users that are set up by default. When I
 look at my user table there is a root user allowed to log in from
 localhost and also another root user but this one is only allowed to
 log in from host.mydomain.com (host being the computer that the
mySQL
 server is installed in). I understand the difference since localhost
is
 when you are working on the computer itself (or remotely through ssh)
 that has the mySQl server installed and that HOST.MYDOMAIN.COM is the
 name of the localhost machine on the LAN. However, if you are
accessing
 the mySQL server from HOST.MYDOMAIN.COM isn't that technically the
same
 thing as accessing from localhost? since in order to access the mySQL
 server from HOST.MYDOMAIN.COM I would have to be at the machine itself
 wouldn't the server just treat that connection as localhost? I have
read
 on the mysql.com site about how the mySQL server sorts the entries in
 the user table at the time the server is started by priority of
specific
 entries to less specific ones, however if I have a password set for
both
 [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would
be
 used? Not that it matters since the set of privileges are the same. I
am
 just really wondering if I need the extra entry of
 [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how
would
 I ever connect to the mySQL server using the [EMAIL PROTECTED]
 account?

 Also I was trying to access the mySQL server using the root@
 HOST.MYDOMAIN.COM account by using the command below:

 Shell mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
 Enter Password: ***

 And this is what I get: ERROR 2003: Can't connect to MySQL server on
 'ZEUS.OLYMPUS.LOCAL' (111)

 I also tried using the IP of the server:
 Shell mysql -u root -h 192.168.1.8 -p
 Enter Password: ***

 And I still got: ERROR 2003: Can't connect to MySQL server on
 '192.168.1.8' (111)

 What does that mean? I tried searching on the list archives but found
 nothing on it. And I did check my /etc/hosts file and this is what is
in
 it:

 127.0.0.1   localhost
 192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS

 Any help would be appreciated it, thanx!







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: ERROR 2003: Can't connect to MySQL server on ....

2003-06-06 Thread Nils Valentin
Hi Francisco,

please login to your mysql server and do this:

SHOW GRANTS FOR username;

Thats probably the fastes way to troubleshoot this issue.


If you really have 2 entries for the same user than t depends on 2 things 
which one takes precedence 1) which entry is mor specific or 2) which order 
they come in the mysqls privilege system.

There are two reports on devshed which I believe are an excellent source. 
There is really nothing to add. Print them off read them carefully on your 
way home and tomorrrow you will be 2 steps further.

http://www.devshed.com/Server_Side/MySQL/Access/page1.html
http://www.devshed.com/Server_Side/MySQL/Grant_Tables/page1.html
http://www.devshed.com/Server_Side/MySQL/Administration/page1.html

They also offer printer friendly formats.
I hope you dont think ... hmm just another document ;-). They are really worth 
the time.

Please let me know the output of SHOW GRANTS FOR username;
I am am confident to be able to help you quickly knowing the ouptut.

Best regards

Nils Valentin
Tokyo/Japan



2003 6 6  09:41Francisco Castellon :
 Hi:

 Thanx for the response. But yes the ZEUS.OLYMPUS.LOCAL host is in the
 mysql.user database for the user root. There are 2 entries for the root
 user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and
 they both have the same global privileges set to ALL. I think that I
 have to add the IP address as an allowed host though, but I thought that
 the mySQL server could resolve the IP to the host name? Thanx!

 -Original Message-
 From: O'K Web Design [mailto:[EMAIL PROTECTED]
 Sent: Thursday, June 05, 2003 8:06 AM
 To: Francisco Castellon
 Subject: Re: ERROR 2003: Can't connect to MySQL server on 

 Hi

 I am not an expert but I would make all root privileges global and
 make
 sure you are allowing log in's by root into any host.  It just sounds
 like
 ZEUS.OLYMPUS.LOCAL is not on your allowed list.  As far as my
 understanding goes, if you are resolving an address, then it would try
 to
 connect using the 'not' local method.

 Mike


 - Original Message -
 From: Francisco Castellon [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: June 5, 2003 2:40 AM
 Subject: ERROR 2003: Can't connect to MySQL server on 

  Hello list:
 
  Just finished installing mySQL on a Linux Debian system and I have a
  question about how the 2 root users that are set up by default. When I
  look at my user table there is a root user allowed to log in from
  localhost and also another root user but this one is only allowed to
  log in from host.mydomain.com (host being the computer that the

 mySQL

  server is installed in). I understand the difference since localhost

 is

  when you are working on the computer itself (or remotely through ssh)
  that has the mySQl server installed and that HOST.MYDOMAIN.COM is the
  name of the localhost machine on the LAN. However, if you are

 accessing

  the mySQL server from HOST.MYDOMAIN.COM isn't that technically the

 same

  thing as accessing from localhost? since in order to access the mySQL
  server from HOST.MYDOMAIN.COM I would have to be at the machine itself
  wouldn't the server just treat that connection as localhost? I have

 read

  on the mysql.com site about how the mySQL server sorts the entries in
  the user table at the time the server is started by priority of

 specific

  entries to less specific ones, however if I have a password set for

 both

  [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would

 be

  used? Not that it matters since the set of privileges are the same. I

 am

  just really wondering if I need the extra entry of
  [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how

 would

  I ever connect to the mySQL server using the [EMAIL PROTECTED]
  account?
 
  Also I was trying to access the mySQL server using the root@
  HOST.MYDOMAIN.COM account by using the command below:
 
  Shell mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
  Enter Password: ***
 
  And this is what I get: ERROR 2003: Can't connect to MySQL server on
  'ZEUS.OLYMPUS.LOCAL' (111)
 
  I also tried using the IP of the server:
  Shell mysql -u root -h 192.168.1.8 -p
  Enter Password: ***
 
  And I still got: ERROR 2003: Can't connect to MySQL server on
  '192.168.1.8' (111)
 
  What does that mean? I tried searching on the list archives but found
  nothing on it. And I did check my /etc/hosts file and this is what is

 in

  it:
 
  127.0.0.1   localhost
  192.168.1.8 ZEUS.OLYMPUS.LOCAL  ZEUS
 
  Any help would be appreciated it, thanx!

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



cannot connect to mysql server

2003-04-05 Thread Peter Gumbrell
I have installed mysql on Mac OS X. when I attempt to access it either 
through a php page or through Terminal, I receive this message;

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I have just switched to a Mac and am unfamiliar with many aspects of 
unix. I read something about creating a symbolic link but am unsure how 
to do this and if this will solve the problem.

Any help would be greatly appreciated.

Peter

[EMAIL PROTECTED]






Re: cannot connect to mysql server

2003-04-05 Thread Jeff Shapiro
At 12:00 -0500 4/5/03, Peter Gumbrell wrote:
I have installed mysql on Mac OS X. when I attempt to access it 
either through a php page or through Terminal, I receive this 
message;

Can't connect to local MySQL server through socket '/tmp/mysql.sock'
mysqld isn't running.

You can check to see if it is running with (run this in a terminal window):

cd /usr/local/mysql

./bin/mysqlamdin ping

to start mysqld use:

 shell bin/safe_mysqld --user=mysql 
 or
 shell bin/mysqld_safe --user=mysql 
 if you are running MySQL 4.x
--user=msyql should be the user that you set up to own the msql directories.

I have just switched to a Mac and am unfamiliar with many aspects of 
unix. I read something about creating a symbolic link but am unsure 
how to do this and if this will solve the problem.

Any help would be greatly appreciated.

Peter

[EMAIL PROTECTED]
--

Jeff Shapiro, Colorado Springs, CO, USA

At work I *have* to use a Windows machine, at home I *get* to use a Mac.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: cannot connect to mysql server

2003-04-05 Thread Todd O'Bryan
Try the following

cd /usr/local/mysql
./bin/mysqld_safe
and see if that starts up the server.

If it doesn't, check to make sure you don't have a proxy set in your 
internet configurations.

Todd

On Saturday, April 5, 2003, at 12:00  PM, Peter Gumbrell wrote:

I have installed mysql on Mac OS X. when I attempt to access it either 
through a php page or through Terminal, I receive this message;

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I have just switched to a Mac and am unfamiliar with many aspects of 
unix. I read something about creating a symbolic link but am unsure 
how to do this and if this will solve the problem.

Any help would be greatly appreciated.

Peter

[EMAIL PROTECTED]






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Cant connect to Mysql server on 'localhost' (10061)

2003-04-01 Thread Bernhard Döbler
Hi,

have you setup a my.ini File?
mine looks like:

[mysqld]
basedir=f:/mysql
datadir=f:/mysql/data
language=f:/mysql/share/german

Bernhard

- Original Message - 
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 4:11 AM
Subject: Cant connect to Mysql server on 'localhost' (10061)


 Does anyone else get this message after installing and attempting to run
 mysql (version 4.0.12)??
 
 I downloaded and installed mysql-4.0.12-win.zip file.
 
 then from the command prompt, I typed mysqld to start the service. Then I
 typed mysql and I got the error message:
 
 Cant connect to Mysql server on 'localhost' (10061)
 
 Am I doing something wrong ?? I checked and confirmed that mysql is running
 as a service on my PC, but I noted when using the
 winmysqladmin tool that no mysql server was being specified - probably the
 cuase of the problem, but how do I fix it.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Cant connect to Mysql server on 'localhost' (10061)

2003-03-31 Thread Terrance Win
check this first in command prompt mysqladmin ping.
You should receive Mysql is alive. Otherwise you have to start your 
service.






From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Cant connect to Mysql server on 'localhost' (10061)
Date: Mon, 31 Mar 2003 12:11:32 +1000
Does anyone else get this message after installing and attempting to run
mysql (version 4.0.12)??
I downloaded and installed mysql-4.0.12-win.zip file.

then from the command prompt, I typed mysqld to start the service. Then I
typed mysql and I got the error message:
Cant connect to Mysql server on 'localhost' (10061)

Am I doing something wrong ?? I checked and confirmed that mysql is running
as a service on my PC, but I noted when using the
winmysqladmin tool that no mysql server was being specified - probably the
cuase of the problem, but how do I fix it.
THanks to anyone that can help.

Michael Hall
Snr Web Developer
Insurance Council of Australia
Email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Cant connect to Mysql server on 'localhost' (10061)

2003-03-30 Thread MHall
Does anyone else get this message after installing and attempting to run
mysql (version 4.0.12)??

I downloaded and installed mysql-4.0.12-win.zip file.

then from the command prompt, I typed mysqld to start the service. Then I
typed mysql and I got the error message:

Cant connect to Mysql server on 'localhost' (10061)

Am I doing something wrong ?? I checked and confirmed that mysql is running
as a service on my PC, but I noted when using the
winmysqladmin tool that no mysql server was being specified - probably the
cuase of the problem, but how do I fix it.

THanks to anyone that can help.

Michael Hall
Snr Web Developer
Insurance Council of Australia
Email: [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Cannot connect to mysql server

2003-03-29 Thread Reuben D. Budiardja

Hello,
I have an interesting problem. I installed mysql client and server from Redhat 
7.3 RPM. Then I set up a username and password for a user monty (to use 
example from the manual).

Then I grant priveleges for the user with:

mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
- IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
- IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

and restarted mysql server. Let's assume the server name is sql.domain.edu

I then tried to connect to the server as user monty from localhost:
$ mysql -u monty -p

and then tried it from another machine console:
$ mysql -u monty -h sql.domain.edu -p

and all is well.

But when i tried to connect using the console from localhost (ie. 
sql.domain.edu) by specifiying hostname:
$ mysql -u monty -h sql.domain.edu -p

I got the cannot connect user [EMAIL PROTECTED] error message. Why does 
this happen?

I fixed this by doing
mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
- IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

but I thought I already specified the wildcard on my previous grant previlege 
so that monty can access from *any* machine. Just curious as t why this 
happens, can  anyone help?

Thanks a lot.
Reuben D. Budiardja


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



connect to mysql server

2003-03-25 Thread Sidar Lopez Cruz
how do i create a user that can connect to any database from any host on my lan

:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.


Re: connect to mysql server

2003-03-25 Thread Stefan Hinz
Sidar,

 how do i create a user that can connect to any database from any host on my lan

mysql GRANT ALL ON *.* TO 'youruser'@'192.168.%' IDENTIFIED BY 'secret';

Assuming your network has IP addresses starting with 192.168.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



FW: Connect to mysql server fail!

2003-03-17 Thread Chien-Lung Wu

hi,experts:

I installed mysql (3.23.56, server  client) at my NT4.0 machine.
As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin
to start mysqld-nt server). That mean that
the mysql server is running.

However, when I create 'root' with mysqladmin command as follows:

--g:\mysql\bin\mysqladmin -u root password 'therootpassword'

and then try to see the status og mysql using following command:

--g:\mysql\bin\mysqladmin -u root -p status
Enter Password: 

I got the error message:
mysqladmin: coonect to server at 'localhost' failed
error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password:
Yes'

Are there any mis-configuration in my installing process. Can anyone show me
how to fix this problem? Thanks.


Chien-Lung

-
Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
posting. To request this thread, e-mail [EMAIL PROTECTED]

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



FW: Connect to mysql server fail!

2003-03-17 Thread Chien-Lung Wu
hi,experts:

I installed mysql (3.23.49, server  client) at my NT4.0 machine.
As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin
to start mysqld-nt server). That mean that
the mysql server is running.

However, when I create 'root' with mysqladmin command as follows:

--g:\mysql\bin\mysqladmin -u root password 'therootpassword'

and then try to see the status og mysql using following command:

--g:\mysql\bin\mysqladmin -u root -p status
Enter Password: 

I got the error message:
mysqladmin: coonect to server at 'localhost' failed
error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password:
Yes'

Are there any mis-configuration in my installing process. Can anyone show me
how to fix this problem? Thanks.


Chien-Lung


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: FW: Connect to mysql server fail!

2003-03-17 Thread gerald_clark
You did not create 'root'. You set the root password to 'therootpassword'
Did you enter the same password you set?
Enter Password :  therootpassword
Chien-Lung Wu wrote:

hi,experts:

I installed mysql (3.23.49, server  client) at my NT4.0 machine.
As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin
to start mysqld-nt server). That mean that
the mysql server is running.
However, when I create 'root' with mysqladmin command as follows:

	--g:\mysql\bin\mysqladmin -u root password 'therootpassword'

and then try to see the status og mysql using following command:

--g:\mysql\bin\mysqladmin -u root -p status
Enter Password: 
I got the error message:
mysqladmin: coonect to server at 'localhost' failed
error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password:
Yes'
Are there any mis-configuration in my installing process. Can anyone show me
how to fix this problem? Thanks.
Chien-Lung

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


  1   2   >