Hi,

I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't access a database as a local user, but I can as a remote user. That is, on the local machine I get this:

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'tpdb@localhost' (Using password: YES)'

whereas if I access the machine from another Linux box:

it works. If I do it as the MySQL root user on the local machine that works OK. I assume something's wrong with my local tpdb user.

The permissions are set as follows (after a lot of faffing about - I'm not suggesting these are optimal settings, or the ones I should have):

localhost root "" <all Ys> lowenbrau.my.domain root "" <all Ys> lowenbrau.my.domain tpdb "" <all Ys> % tpdb "" <all Ys> localhost tpdb "" <all Ys>

I've reloaded (and actually restarted) the server, but it won't play. There's nothing in the db table except a couple of "test" database entries.

I'm reading up on security issues, but I have someone waiting on this, so if anyone could give me a pointer as to what I've done wrong, I'd much appreciate it.