RE: remote connection

TED] Sent: Friday, November 07, 2003 10:57 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: remote connection For some reason, MySQL treats "localhost" as a special case (at least that seems to be the behavior." If you run grant on to user@'%' identified by

RE: remote connection

t;<><><><><><><><><><><><><><> -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 1:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: re

remote connection

I'm trying to set up a remote connection to a mysql database using Perl DBI. I have done this without problem on another database. I suspect the rights are set up differently on this one. I have root access. When I try to connect, I get the following error (hostname, username, password have been

Re: speeding up a search

when I indexed the columns, it went down to less than a half second. KL John Almberg wrote: I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_i

speeding up a search

I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_id as lid from stamps as s left join links as l on (( s.item_id=l.item_id)) WHERE (s.sold is null); This worked great w

Can't open MySQL Database from perl or php . . .

I'm trying to set up my own web server . . . the typical Linux/apache/perl/php/mysql combination. I've got all these components working *except* that I am unable to connect to a MySQL database from perl or php. PHP & Perl are working fine with Apache and I can run MySQL commands from the shell

Can't start mysql

I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains: mysqld: Can't find file: './mysql/host.frm' From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't

RE: FW: SQL question

--Original Message- > From: Mark Matthews [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 1:33 PM > To: John Almberg > Cc: Mysql > Subject: Re: FW: SQL question > > > John Almberg wrote: > > >Nope. I've tried every combination I can think of o

RE: FW: SQL question

Yes, that works! Thanks very much to all who suggested similar solutions! -- John > -Original Message- > From: Mark Matthews [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 1:33 PM > To: John Almberg > Cc: Mysql > Subject: Re: FW: SQL question > &g

RE: FW: SQL question

Yes, that works! Thank you very much! -- John > -Original Message- > From: Mark Matthews [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 1:33 PM > To: John Almberg > Cc: Mysql > Subject: Re: FW: SQL question > > > John Almberg wrote: &

FW: SQL question

CTED]] > Sent: Friday, September 27, 2002 9:52 AM > To: John Almberg > Cc: Mysql > Subject: Re: SQL question > > > ORDER BY 0 + fieldname > > if this is not quit right try > > ORDER BY 0 + fieldname , fieldname > > John Almberg wrote: &

RE: SQL question

fieldname; > > > Hope it helps. > > > Mihail > > - Original Message - > From: "John Almberg" <[EMAIL PROTECTED]> > To: "Mysql" <[EMAIL PROTECTED]> > Sent: Thursday, September 26, 2002 8:04 PM > Subject: SQL question >

SQL question

I'm trying to sort a table on a character-type field that contains mostly numbers. This field always contains either a number or a number followed by a character. Like '57' or '57a'. I'd like to sort the table *numerically* on this field, not *alphabetically* on this field. That is, I'd like the