NYCPHP Meetup

[P. Fawcett]

i hate shotgun from maintenance standpoint - but when under fire...

in fact i have to drop this server till tues as i have been given
priority to another needed by tues. so you may not hear any more
confusion till then.

tx. for doc pointers.  can spend lifetime reading & like to start in the
right direction at least for production purposes

was disappointed to miss recent nyc php users group discussing
apache/php/mysql - was exactly what i needed!

Hans Zaunere wrote:
> 
> --- "P. Fawcett" <fawcett at bard.edu> wrote:
> > tx.
> >
> > to confirm - so i can have both a mod & standalone cgi (thou i don't
> > know why i'd want both but the programmers don't seem to know their
> > environment so i'm just thinking of covering all bases till i get a
> > handle on it.)
> 
> The shotgun method - works well, until you need to upgrade/patch  :)
> 
> > i found that php 4.2.2 if mysql not specified in config, then it's
> > auto built in
> 
> It's always better to use MySQL's client libs.  ie, when configuring
> php:
> 
> /configure --with-mysql=/usr/local/mysql
> 
> > so i've got php working but mysql won't do anything from within the
> > server including basic #myqladmin version or variable info, returns
> > w/error:
> >
> > "MySQL said:
> > Host '204.nnn.nnn.nn' is not allowed to connect to this MySQL server"
> >
> > & docs point to 'make sure mysqld running- it is, & /tmp/msql-4socket
> > exists -it does, so something else w/access prblm so i have to find
> > mysql talk & maybe they'll know something
> 
> Maybe.
> 
> Obviously, your permission tables aren't setup properly.  There are a
> couple of issues:
> 
> 1) if you connect to localhost or the FQDN or alias of a system, MySQL
> will see the connection as comming from different hosts.
> 
> 2) if you INSERT/UPDATE/DELETE the mysql.* tables directly, you need to
> FLUSH PRIVILEGES for the changes to take effect.
> 
> 3) Use GRANT/REVOKE.  Read:
> http://www.mysql.com/doc/en/Privilege_system.html
> http://www.mysql.com/doc/en/User_Account_Management.html
> 
> H
> 
> =====
> Hans Zaunere
> New York PHP
> http://nyphp.org
> hans at nyphp.org
> 
> __________________________________________________
> Do you Yahoo!?
> Faith Hill - Exclusive Performances, Videos & More
> http://faith.yahoo.com
> 
> --- Unsubscribe at http://nyphp.org/list ---