Re: bind-address by name under 5.0.18

>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

Re: bind-address by name under 5.0.18

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

Re: bind-address by name under 5.0.18

> 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

Re: bind-address by name under 5.0.18

> 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

Re: bind-address by name under 5.0.18

id I make sense? Yes, but none of the information was new. > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > James Long <[EMAIL PROTECTED]> wrote on 02/27/2006 03:59:14 PM: > > > > It doesn't allow to bind to a hostname. According t

Re: bind-address by name under 5.0.18

iguration parameter. > > 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 > > control of anyone who doesn't have their own dir

bind-address by name under 5.0.18

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. When the time comes to change IP numbers, I want to just

Re: Foreign Key Error 1005:150

Michael, Thank you for your reply. Here is a bit more info. I changed the default table type to innodn in the my.ini file before creating the database, so all tables are innodb. I tried the create statements with and without explicit index clauses with all permutations - same result each tim

Foreign Key Error 1005:150

I am unable to define a foreign key with the following three tables. I am unable to find the error having searched the documentation and tried several variations. Note that I created the first two tables with and without the index clause in the table ddl with no difference in outcome. The t

RE: bugzilla not working now after MySQL re-installed

e. In some distributions it can be found in /var/lib/mysql/mysql.sock. Yiannis. -Original Message- From: Nguyen, Long P (Mission Systems) [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 17:07 To: Hassan Schroeder; [EMAIL PROTECTED] Subject: RE: bugzilla not working now after MySQL re-insta

RE: bugzilla not working now after MySQL re-installed

rpm and the compile install is there? -Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 12:20 PM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > yes.. below: &g

RE: bugzilla not working now after MySQL re-installed

From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > I tried this and get a 0 affect below.. > > mysql> GRANT SELE

RE: bugzilla not working now after MySQL re-installed

ysql> -Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > I tried this and get a 0 affect below.. &g

RE: bugzilla not working now after MySQL re-installed

age- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > MySQL is running.. OK, that's /half/ the question :-) > H

RE: bugzilla not working now after MySQL re-installed

Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:38 AM To: Nguyen, Long P (Mission Systems); [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > Your thoughts on this would

bugzilla not working now after MySQL re-installed

Your thoughts on this would be appreciated. MySQL was re-installed and now Bugzilla is not working now I am getting this error when I bring up - http://localhost/bugzilla/ * Software error: Bugzilla is currently broken. Please try again later. If the problem p

RE: Access denied for user: 'root@localhost' (Using password: NO)

shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 8:57 AM To: Nguy

Access denied for user: 'root@localhost' (Using password: NO)

Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'. Could someone please tell me what

PHP/MySQL/MyODBC drivers

I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Thanks Terry L. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

mysql-test-run broken on Tru64 4.0F PK3

: illegal option -- e -p: illegal option -- s -p: illegal option -- t -p: illegal option -- / -p: illegal option -- v -p: illegal option -- a -p: illegal option -- r -p: illegal option -- / -p: illegal option -- t -p: illegal option -- m /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: ill

libtool 1.3.5 broken on Tru64 4.0F

en install mysql as normal. Then run mysql. You'll get this error: long@robin[6:39pm]/homeb/long/src/mysql-3.23.49 > mysql 5924:/usr/local/mysql/bin/mysql: /sbin/loader: Fatal Error: cannot map libmysqlclient.so >Fix: Switch to using libtool 1.4.2 for building mysql from source. Unkn

mysql_config broken

e 0; then usage; fi >Submitter-Id: >Originator:Jeff Long >Organization: The University of Kansas > >MySQL support: none >Synopsis: mysql_config broken >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release:

How to get a list of indexes on a table

*This message was transferred with a trial version of CommuniGate(tm) Pro* is there an easy way besides doing a mysqldump to show all the indexes on a table and their details?(name, table, column(s), type, etc). I can't seem to find a way to do it. If one doesn't exist, does somebody have a progr