mysql permission problem

Submitted by jeffrice on Tue, 05/17/2005 - 19:41

I am having trouble getting this working on my Gentoo box. If I set up /etc/gps.conf using the root database access, I get the expected results -- but the user greylist does not work.

I have done the GRANT ALL step, and if I use "mysqladmin ping -u greylist -p", I get a response from the server. However, piping the test files to gps gives "dunno" from if the user is greylist. (I get defer if I let gps access the db as root.) I have only a rudimentary knowledge of mysql -- can anyone help me out here?

Jeff

Forums: 
gps forum

Submitted by jeffrice on Tue, 05/17/2005 - 23:03.

Ah, never mind -- I got it! Needed to do:

use mysql;

insert into db values ('localhost','greylist','greylist', etc etc etc);