NYCPHP Meetup

[Hans Zaunere]

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