How to properly set up a MySQL user?

[dustbuster]

I have PHPMyAdmin and have had mixed success setting up users for tables. Sometimes they connect without any problems and other times I can't get the user to connect properly.

Say I have the following info:
User: test_user
Database: test_database
Host: localhost

Can someone tell me how to properly set up a MySQL user?

Thanks

[mattotto77]

The mysql manual provides detailed information on this, it gives a thorough guide of how the privilege system works and also some guides.

Have a look and give it a go if you get any probs post another note saying what you did and what the probs are.

[dustbuster]

Alright. Thanks, I'll do that.