> " intermittent connection problems (error 2013)"
>
> Look at SHOW PROCESSLIST; when you're having a connection problem. If you
> see lots of "unathenticated user" in the list, then it means you're having
> DNS problems.
>
> Typically the best way to handle this is to set skip-name-resolve,
kip-name-resolve, and using ip
addresses instead of hostnames in your mysql users for authentication.
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Tuesday, December 07, 2010 1:02 AM
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address u
database or just listen on any device?
>
>
> -Original Message-
> *From*: Claudio Nanni
>
> >
> *To*: Machiel Richards
>
> >
> *Cc*: mysql mailing list
>
> >
> *Subject*: Re: Bind-address use?
> *Date*: Tue, 7 Dec 2010 09:22:3
what will the effect be if we disable this option in the config file by
means of hashing out the option?
will it break the database or just listen on any device?
-Original Message-
From: Claudio Nanni
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address use?
Date: Tue
Hi,
You may have multiple interfaces and each multiple ips (private or public).
With bind-address you force mysql to listen to a specific ip address instead
of any. In case you have both public and private ips, binding to the
private, for example, prevents from connections from the internet.
Just
Hi All
I am unable to find an answer on what the bind-address in
mysql-5.1 actually does.
From the config file it says that it provides the same function
as the previous skip-networking function.
However, let's say I configure the bind-adress value to the IP
o
In the last episode (Nov 26), Amit Dor-Shifer said:
> Hi,
> I tried setting 'bind-address' as an option from ~/.my.cnf:
>
> (amit0:~) # cat ~/.my.cnf
> [mysqld]
> bind-address 127.0.0.1
> (amit0:~) # mysqld
> 061126 16:08:54 [ERROR] mysqld: unknown option &#x
Hi,
I tried setting 'bind-address' as an option from ~/.my.cnf:
(amit0:~) # cat ~/.my.cnf
[mysqld]
bind-address 127.0.0.1
(amit0:~) # mysqld
061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1'
1. Is 'bind-address' then not an 'o
2006/10/4, Dominik Klein <[EMAIL PROTECTED]>:
> You can only specify one IP address to bind to.
If you omit this option, mysqld will bind to all addresses on the
machine. If this is not what you want, you could block mysql-access with
a packet filter for the IP addresses you do not want to bind
You can only specify one IP address to bind to.
If you omit this option, mysqld will bind to all addresses on the
machine. If this is not what you want, you could block mysql-access with
a packet filter for the IP addresses you do not want to bind to.
--
MySQL General Mailing List
For list a
KLEIN Stéphane wrote:
Hi,
Can I set many IP address with bind-address ? If not, how can do same
thing ?
In documentation, I read this :
'''
-bind-address=IP
The IP address to bind to.
'''
They don't say if I can use comma to separate two or many IP.
Hi,
Can I set many IP address with bind-address ? If not, how can do same thing ?
In documentation, I read this :
'''
-bind-address=IP
The IP address to bind to.
'''
They don't say if I can use comma to separate two or many IP.
Thanks for your help,
Step
I have a legacy app that only supports MySQL 3.23. I'd like to run it
along with 5.0.24a on a Windows 2000 server, with each instance using the
standard port 3306. So I need to have each instance bound to just one IP
address.
In MySQL 3.23 can you specify a bind-address in the my.ini
;
Cc:
Sent: Wednesday, August 23, 2006 3:07 PM
Subject: Re: Re: How to query bind address?
Is it running on Windows, James? You may have to allow connections
through to MySQL in Windows Firewall.
Otherwise it seems like maybe it's been started with --skip-networking ?
Dan
On 8/23/06, Ja
Is it running on Windows, James? You may have to allow connections
through to MySQL in Windows Firewall.
Otherwise it seems like maybe it's been started with --skip-networking ?
Dan
On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
- Original Message -
From: "Dan Buettner" <[EMAIL P
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
I believe MySQL listens on all IPs ... what if any error message are
you getting?
From SQLyog I get:
Error No. 2003
Can't connect to MySQL server on '192.168.9.2' (10061)
Can you access other services (SSH, telnet,
I believe MySQL listens on all IPs ... what if any error message are
you getting?
Can you access other services (SSH, telnet, FTP) over the same routes?
Can you telnet to MySQL over those routes? If so you may have an
authentication problem, not a connection problem. Here's a sample of
what a
Is there a way to query a MySQL (5.0.xx) server to find out which IP
address(es) it's listening on? It should be listening on all, but I'm
unable to connect from remote machines, so need to troubleshoot a bit.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Andrew wrote:
> Hi Everyone,
>
> I have been searching around for a while, but have had no luck as yet
> for this question.
>
> I am running debian with mysql 4.x on a x86 box. (2.6 series kernel).
>
> Anyhow, up until now, I have had a single bind-address option pas
Hi Everyone,
I have been searching around for a while, but have had no luck as yet
for this question.
I am running debian with mysql 4.x on a x86 box. (2.6 series kernel).
Anyhow, up until now, I have had a single bind-address option passed,
however I need to add another address (so it
>6752 exit(1);
>6753}
>6754my_bind_addr = (ulong)
> ((in_addr*)ent->h_addr_list[0])->s_addr;
>6755 }
>6756 break;
>
>
> > And with other DBs, I can set 'sql.example.com' to resolve to N
> > IPs (N=4 in this example):
> >
> > 10.0.0.10
> > 1
--pid-file=/var/db/mysql/www.example.com.pid --bind-address=localhost > /dev/null &"'
Hmm, I don't see why it shouldn't work when run inside su... odd.
As far as I know, there are no requirements for superuser in order to
bind to certain IPs.
I'm also hopeful to ge
gt; 5.0.13) and it does indeed work.
>
> I did:
>
> * echo "10.0.0.1 foo" >> /etc/hosts
> * ifconfig lo0 alias 10.0.0.1
> * add to /etc/my.cnf:
>[mysqld]
>bind-address=foo
> * restart mysqld
> * mysql -h 10.0.0.1 <-- confirm connection or e
echo "10.0.0.1 foo" >> /etc/hosts
* ifconfig lo0 alias 10.0.0.1
* add to /etc/my.cnf:
[mysqld]
bind-address=foo
* restart mysqld
* mysql -h 10.0.0.1 <-- confirm connection or error from mysqld
* mysql -h 127.0.0.1 <-- confirm failure to connect at all
I didn't know th
n DNS)
> >> it will be "interesting". :)
> >
> > Thanks for your reply. Just for my edification, how come only one IP?
>
> Add another 10 lines and you should be able to make it bind to all IPs
> returned. Currently bind-address supports only one IP to bind to.
&g
Hi James,
I would like to be able to bind to a host name, rather than
an IP number. IP numbers come and go, and are beyond the
control of anyone who doesn't have their own direct allocation.
But since I own my domain, a host name is more permanent.
Adding this functionality is fairly trivia
> Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just
> normally not available for reference until you bind your socket library to
> at least one socket. Again, it's a cart and horse thing. You see, the
> etc/hosts file counts as a "local" DNS server and the DNS protocol
> re
>
> > > >
> > > > On 2/22/06, James Long <[EMAIL PROTECTED]> wrote:
> > > > > I would like to be able to bind to a host name, rather than
> > > > > an IP number. IP numbers come and go, and are beyond the
> > > > > contr
06, James Long <[EMAIL PROTECTED]> wrote:
> > > > I would like to be able to bind to a host name, rather than
> > > > an IP number. IP numbers come and go, and are beyond the
> > > > control of anyone who doesn't have their own direct allocation.
&g
numbers come and go, and are beyond the
> > > control of anyone who doesn't have their own direct allocation.
> > > But since I own my domain, a host name is more permanent.
> > >
> > > When the time comes to change IP numbers, I want to just edit
> > &
ect allocation.
> > But since I own my domain, a host name is more permanent.
> >
> > When the time comes to change IP numbers, I want to just edit
> > /etc/hosts to show my new IP:
> >
> > 10.0.0.10 shortname myrealname.example.com
> >
> > and use
osts to show my new IP:
>
> 10.0.0.10 shortname myrealname.example.com
>
> and use "--bind-address=shortname" in my start-up script to
> automatically pick up the new IP number.
>
> This eliminates the headache of having to find and fix umpteen
> literal IP numbers
nt to just edit
/etc/hosts to show my new IP:
10.0.0.10 shortname myrealname.example.com
and use "--bind-address=shortname" in my start-up script to
automatically pick up the new IP number.
This eliminates the headache of having to find and fix umpteen
literal IP numbers hidin
ld like to bind mysqld to more than one IP address (localhost and my
> private unrouted interface). Is there a way to get --bind-address to bind
> to more than one IP? I have been unsucessfull when trying comma/space
> delimited arguments to bind-address, etc.
>
> Thanks,
> -
Hi everyone,
I would like to bind mysqld to more than one IP address (localhost and my
private unrouted interface). Is there a way to get --bind-address to bind
to more than one IP? I have been unsucessfull when trying comma/space
delimited arguments to bind-address, etc.
Thanks,
-Cere
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
OKay, here's the problem - a self-built MySQL. Unfortunately, due to
some glibc bugs it's not really possible to build a stable MySQL
under linux using stock glibc...
And the pro
be a resolver problem? The error
messages says "lost connection _during_ query", this means that the
connection is already established, so obviously the resolver already did
it's job to find out the ip-address of the mysql-server. And anyway: I
used bind-address before and it worked. I j
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I'm experiencing a strange thing: When bind is running without
> "bind-address" everything works fine. But when I'm doing a "bind-address
> = ..." the clients get "Lost connection to MySQL server dur
Hello,
I'm experiencing a strange thing: When bind is running without
"bind-address" everything works fine. But when I'm doing a "bind-address
= ..." the clients get "Lost connection to MySQL server during query". I
don't understand this, because
"Scot" <[EMAIL PROTECTED]> wrote:
>
> New subscriber to the list, searched the archives for any thread on this
> with no joy so
> sorry if it's a re-post.
>
> Can I have 2 bind-addresses in my.cnf ?
No.
> Changing ports is not an option.
>
> Dual honed Sun Box running MySQL 4.x
--
For
Hi;
New subscriber to the list, searched the archives for any thread on this
with no joy so
sorry if it's a re-post.
Can I have 2 bind-addresses in my.cnf ?
Changing ports is not an option.
Dual honed Sun Box running MySQL 4.x
Thnks
Scot Needy
[EMAIL PROTECTED]
757-664-2217
Yahoo.id
Hi,
I have mysql 3.23.56 on RedHat 8.0
I can access mysql through my machine using PHP alright with the following
server: ns1.mydomain.ca
user: me
Password: foo
I can access Mysql using Putty with the same variables
However I am using a program that uses ADO and MyOBDC driver and it is unable to
Mike Kinzie <[EMAIL PROTECTED]> wrote:
>
> I have mysql 3.23.56 on RedHat 8.0
> I can access mysql through my machine using PHP alright with the following
> server: ns1.mydomain.ca
> user: me
> Password: foo
> I can access Mysql using Putty with the same variables
>
> However I am using a progra
;
}
+ else
+ ent=gethostbyname(optarg);
+
if (!ent)
{
sql_perror("Can't start server: cannot resolve hostname!");
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Problem on mysqld with
Hi all ,
I am trying to do the following :
[root@xxx bin]# ./safe_mysqld --bind-address=192.168.1.222
Starting mysqld daemon with databases from /usr/local/mysql/var
but when I telnet xxx 3306, the mysqld have the following response:
./safe_mysqld: line 1: 12325 Segmentation fault nice
At 14:25 03/09/02 -0400, Tam, Michael wrote:
Hi,
>I just tried 4.0.3beta and it doesn't seem to address the bind-address
>problem at all.
>When I include the option in the ini file and run "mysql-max-nt --help",
>it stops showing the variables when it reaches
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up w
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up w
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up w
t: Tuesday, August 27, 2002 3:57 AM
To: [EMAIL PROTECTED]
Subject: Re: MySql 4.0.2a Bind-Address problem
Michael,
Tuesday, August 27, 2002, 12:40:31 PM, you wrote:
MT>I tried to use config. variable 'bind-address' for MySQL 4.0.2a
MT> (mysqld-max-nt) to assign a particular ip f
Michael,
Tuesday, August 27, 2002, 12:40:31 PM, you wrote:
MT>I tried to use config. variable 'bind-address' for MySQL 4.0.2a
MT> (mysqld-max-nt) to assign a particular ip for the server. However, I got
MT> the following error:
MT> E:\mysql4.0.2a\bin>mysqld-max-nt
Hi all,
I tried to use config. variable 'bind-address' for MySQL 4.0.2a
(mysqld-max-nt) to assign a particular ip for the server. However, I got
the following error:
E:\mysql4.0.2a\bin>mysqld-max-nt --help
Unknown suffix '.' used for variable 'bind-address
>Description:
Unable to use dotted-quad IP address in bind-address in 4.0.2.
>How-To-Repeat:
$ cat /etc/my.cnf
[mysqld]
bind-address= 192.168.1.2
$ /etc/rc.d/
Chris,
Tuesday, July 16, 2002, 2:13:57 AM, you wrote:
CK> Can MySQL bind to two or more IP addresses?
Nope.
CK> i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
CK> ?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Lo all,
Can MySQL bind to two or more IP addresses?
i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
?
Thanks,
--
me
-
Before posting, please check:
http://www.mysql.com/manual.php (the
It helps if you restart the mysql service after you make a change!
Sorry for the spam.
Kevin Ailes
Administrator
OTTO Engineering
> -Original Message-
> From: Ailes, Kevin
> Sent: Wednesday, January 02, 2002 11:02 AM
> To: '[EMAIL PROTECTED]'
> Subject:
"Ailes, Kevin" a écrit :
>
> I have two NIC's with two different IP addresses on the machine that has the
> mysql server running on it.
>
> When I set up the bind-address argument(using winmysqladmin ver.1.1) under
> the my.ini tab to bind to specifically one
I have two NIC's with two different IP addresses on the machine that has the
mysql server running on it.
When I set up the bind-address argument(using winmysqladmin ver.1.1) under
the my.ini tab to bind to specifically one of the NIC's, it appears to have
registered that it is a vali
58 matches
Mail list logo
