Granting access to MySQL via OS X

[Mark S Lowe]

So I have a beautiful installation of mySQL. I now need to open the 
pipe to my 3306 port to the outside world directly. When I have people 
ping my IP, they get a restricted bounce error message. I assume there 
is a configuration file that needs to be backed off, but I can't seem 
to find anything anywhere.

Suggestion?

Thanks in advance,

Mark

PS: Router access working fine. No firewall for 3306.


-
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

MySQL Question

[Mark S Lowe]

I have to do an insert and need to nest a select inside. I have tons of 
documentation on a very simple version of this, however my requirements 
are one step beyond that. Here is what I'd like to do in MySQL:

insert into

table1

(column1, column2)

values
(select column1a from table2 where [something],
valueFromMemory)

If you'll notice, I want one column from a select and one column 
outside the select. Is this possible in MySQL? All the documentation 
I've read about MySQL says it can't be done.

Thank you in advance!

Mark


-
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

Count(*) using a join?

[Mark S Lowe]

I need to do a join with a count...but for some reason I can¹t figure out
how to do it using MySQL. I¹m hoping that this pseudo code can help you give
me an answer: 

 select 
 
 f.count(*),
 s.name
 
 from 
 
 first f, second s
 
 where
 
 f.id = s.id


How do I get a sql result like:

CountName
---
12343Test

I¹ve attempting adding the group by function as documented, but MySQL has
some demands I don¹t understand.


Thank you in advance!

Mark

Need last 100 records...

[Mark S Lowe]

Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
out with MySQL. 

Please advise! Thank you!

Mark