Re: Cacti can't find the database, wtf?

At Wed, 9 Oct 2013 20:32:41 +0100,
James Bensley wrote:
> 
> > mysql> select * from mysql.user where User='cactiuser';
> 
> Why are you running that MySQL statement as another user, why don't
> you connect to MySQL as that user?

Hmm. Good question.

> Can you connect to MySQL as that username and password combo, and
> execute "use cacti" and "show tables" ?
> 
> Does that user have the correct privileges, what is the output of
> "show grants..." ?
> 
> Are you connecting via unix socket or TCP socket? Is Cacti doing the same?

Ah! Thanks. I had totally forgotten about grants, and looking at them
showed an access rule for % which apparently matches all kinds of
hosts, but not a local socket which was what I am using. Changing the
grant to be valid for user @'localhost' did it...

Thanks for putting me on the right track. Now I feel stupid...

/andreas

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk