[thelist] MySQL User Problem

[Randal Rust]

I think that my understanding of what goes on in MySQL -- how users
and permissions are managed -- is wrong.

In the mysql.user table, I have defined a user...

Host: localhost
Username: dba
Password: foo

...and granted all permissions to that user.

Next, I have added this to the mysql.db table...

Host: localhost
Db: test_db
User: dba

However, when I try to connect (via ADODB and PHP), I continue to get
this error:

Access denied for user 'dba'@'localhost' (using password: YES)

I am trying to set this up through PHPMyAdmin, but I don't know if
that has anything to do with it. Usually, I have a control panel that
I am using that walks me through this. However, on this particular
site, the client is running their own server, sans a control panel.

Where am I going wrong?

-- 
Randal Rust
R.Squared Communications
www.r2communications.com