ERROR 1044: Access denied

[Brian Davisd]

I'm in a quandry because I haven't used MySQL much since first installing it.

My original problem is trying to access MySQL using JDBC from a non-localhost computer. Toward this I need to GRANT access to a database and this is my immediate problem.

There are 3 possible users on the Linux box where MySQL is installed: briand, myusql and root. If I try to run mysql as either mysql or root, e.g.,
$ mysql -u mysql -p
I get ERROR 1045: Access denied for user...(Using password: YES). This occurs even if I run mysql logged into Linux as root.

If I run it as briand, I can get in but if I try to access the main MySQL database, ie, 'use mysql', I get "ERROR 1044: Access denied for user 'briand@localhost' to database 'mysql'." I can access other databases however.

Can anyone tell me how to find out which user has access to the mysql database so I can grant privledges? Thanks!