in reply to Perl Script connecting to Mysql works from command prompt, not from Apache
Second - *IF* it is not a code problem, and because you are asking about what other tables might be involved, it just could be a mysql privilege issue.
These are the typical relevant tables in database mysql
mysql> show tables; +-----------------+ | Tables in mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.00 sec)
Specifically, look at your db table, which contains the priviledges based on a combination of user/host/database.
Also, if you post some code I'm sure it would help everyone be more helpful..:)
EEjack
|
---|