Hi Folks
I am having trouble connecting to a MySQL table using the DBI->connect()
call from a Perl CGI script. The error message I get is:
Can't connect to database: Access denied for user: 'web504@localhost'
(Using password: YES)
The web504 account and password are defined in the user table for any host
but with no privileges. The web504 account is also defined in the db table
for any host but with select and delete privileges for the required
database. If I check access rights with mysqlaccess everything is OK. I can
also manually access the database from the web server by running mysql as
web504. If I change the DBI call to use the root account and password the
CGI script runs succesfully.
Any help greatly appreciated
Cheers
Norman Buskell
---------------------------------------------------------------------
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
