From: Andrew Nagy <andrew.nagy@vi...> - 2008-01-30 18:23:04
That is totally wacky! So you are still seing the cannot connect error thr=
> -----Original Message-----
> From: vufind-general-bounces@... [mailto:vufind-
> general-bounces@...] On Behalf Of Jeffrey Barnett
> Sent: Wednesday, January 30, 2008 12:56 PM
> To: vufind-general@...
> Subject: [VuFind-General] [Fwd: Re: mysql admin aid]
> Thanks for stopping me from burrowing into the wrong tunnel.
> here is the result:
> Connected successfully
> Opened vufind database
> Closed Connection
> 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:
> > <?php
> > $link =3D 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>'; mysql_close($link); 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
> > You could also try connecting to the database with the root user
> account instead of the vufind user.
> > Andrew