Hello, I'm a newbie in mysql, so i have a problem when managing my database.
This is one of table in my database:
==================================

+---------------+----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+----------------------+------+-----+---------------------+----------------+
| id | smallint(5) unsigned | | PRI | NULL | auto_increment |
| name | varchar(40) | | | | |
| login | varchar(20) | | | | |
| tester | tinyint(3) unsigned | | | 0 | |
| dev | tinyint(3) unsigned | | | 0 | |
| man | tinyint(3) unsigned | | | 0 | |
| security | smallint(5) unsigned | | | 0 | |
| password | varchar(32) | | | | |
| tz | time | | | 00:00:00 | |
| email | varchar(40) | | | | |
| spam | text | YES | | NULL | |
| creation_date | datetime | | | 0000-00-00 00:00:00 | |
| updated_date | datetime | YES | | NULL | |
| updated_by | varchar(40) | YES | | NULL | |
| note | text | YES | | NULL | |
| options | int(11) | YES | | NULL | |
| active | tinyint(4) | | | 1 | |
| hqflag | tinyint(1) unsigned | | | 0 | |
| usermask | int(11) | | | 1 | |
+---------------+----------------------+------+-----+---------------------+----------------+

=====================================
- How can i create an account with full control into the database or that tables?
- How can i create an account with restrict permission in my database?
- How many kinds of accounts can i create?
Please help me solve the problem.
Thanks so much.

If you are new to MySQL, it may be worth grabbing MySQL Administrator, that allows you to create accounts and set permissions really easily.

ok, thanks for your answer, however is MySQL Administrator software?
How about my problem, can you show me the way to solve it?
Thansk so much.

MySQL Administrator is a really nice GUI way to manage MySQL. You can get it from http://www.mysql.com/products/administrator/. Once you have installed the program, launch it and it is easy to manage user accounts. To change permissions on an account, you simply select the account, select the database, select the permissions you would like that account to have and click a button. It is hard to explain a GUI app through text but it is so easy to use, once you have it, it won't pose any program.

Thanks for your guide, however in my problem. I want to insert a username into my table above. Please help me.
I will get MySQL Administratror, however please help me solve the problem.
Thanks

Do you want to insert a username field into the table or insert a row with the username in the 'name' field?

If you just want to add a username field, Administrator can do that too. On the menu, at the bottom it says 'Catalogs', choose that, then the database that your table is in. A list of tables in that database will appear, double click on the table you wish to edit and scroll to the bottom of the new window, just type the details in there and apply it.

ok, thanks for all. I have solved the problem.
- Get phpMyadmin
- Do with my idea.

Thanks again