> " 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 k
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 '--bind-address 127.0.0.1'
Try "bind-addr
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 passed,
> however I need to add
>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
Hi James,
Sort of. If I run the command manually, it does.
But my script uses su to run the server as an unprivileged user.
What happens if you:
su -m mysql -c 'sh -c "/usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql
--pid-file=/va
> Hi,
>
> > Thank you very much! I'm willing to help test if you can provide me a diff
> > of your changes.
>
> Well, that was easy. I checked the code, and it turns out that the
> functionality is already there. I just tested it on my laptop (running
> 5.0.13) and it does indeed work.
>
>
Hi,
Thank you very much! I'm willing to help test if you can provide me a diff
of your changes.
Well, that was easy. I checked the code, and it turns out that the
functionality is already there. I just tested it on my laptop (running
5.0.13) and it does indeed work.
I did:
* echo "10.0
> 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 f
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
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
requires a s
You seem to be unaware of /etc/hosts.
> Yes, there is a very good, not so technical reason to only allow binding
> by IP Address. Have you ever heard of "putting the cart before the horse"
> ?
>
> If binding by hostname were allowed, that would mean that every time your
> MySQL server started
Yes, there is a very good, not so technical reason to only allow binding
by IP Address. Have you ever heard of "putting the cart before the horse"
?
If binding by hostname were allowed, that would mean that every time your
MySQL server started up, it would need to somehow resolve that name int
> It doesn't allow to bind to a hostname. According to
>
> http://dev.mysql.com/doc/refman/5.0/en/server-options.html
>
> you have to specify an IP address, not a hostname.
>
> -Sheeri
Thanks for your reply. Yes, I am aware of that, as stated in
my question.
Wouldn't it be an improvement if
It doesn't allow to bind to a hostname. According to
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
you have to specify an IP address, not a hostname.
-Sheeri
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 num
Hello.
Systems call bind() calls only one time for IP socket and one time
for socket file (from sql/mysqld.cc). So you can specify only one IP
address. Use firewall to suppress undesirable connections.
Cere Davis <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I would like to bind mysql
"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,
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
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 email is spon
"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 of the NIC's, it appears to have
> r
25 matches
Mail list logo