Thanks for stopping me from burrowing into the wrong tunnel.
here is the result:
Opened vufind database
Andrew Nagy wrote:
>> AHAH! tables_priv looks promising.
> Jeffrey - This shouldn't be necessary. This allows you to set privileges at the table level. All you should need to do is allow your user access to the mysql server - to get it working. You may want to work with other tables in the mysql database to control security at a more granualar level - but that's not necessary at this point.
> Let's rule out all other possibilites first. Can you create a php file on your server in a directory that is accessible by apache with the following as the contents of the file:
> $link = mysql_connect('localhost', 'vufind', VUFIND_PASSWORD) or die('Could not connect: ' . mysql_error());
> echo 'Connected successfully<br>';
> mysql_select_db('vufind') or die('Could not select database');
> echo 'Opened vufind database<br>';
> echo 'Closed Connection';
> You should see a "Could not connect" message. If so, that tells us that it is a 100% mysql configuration problem.
> Then I would suggest looking into some of the mysql administration documentation.
> You could also try connecting to the database with the root user account instead of the vufind user.