how do I create an admin specially for one mysql database. Not an admin for the whole server, but one who can only edit and view his own dtabase.

You need to create a 'user', see:
http://www.mysql.com/documentation/index.html

username=AAA databasename=BBB passwrod=CCC

create database BBB;

use mysql;

INSERT INTO user SET User = 'AAA', Host ='localhost', Password = PASSWORD ('CCC');

INSERT INTO db set User = 'AAA',Db='BBB', Host='localhost', Select_priv = 'Y', Insert_priv = 'Y', Update_priv = 'Y', Delete_priv = 'Y', Create_priv = 'Y', Drop_priv = 'Y', Grant_priv ='Y', References_priv = 'Y', Index_priv = 'Y', Alter_priv = 'Y';


That's the codes I use to add MySQL database and user. I think it might helps you, so I posted it.

I do the following steps. Please tell me if I'm leaving some security hole this way.

-------------------

GRANT USAGE ON *.* TO some-user-name@localhost IDENTIFIED BY 'some-password';

This builds a dummy account, with no priviledges.

-------------------

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON some-user-name.* TO some-user-name@localhost IDENTIFIED BY 'some-password';

This allows the user to only use the database that he is assigned. It also blocks any access other than localhost.

-------------------

SHOW GRANTS FOR some-user-name@localhost;

This shows the priviledges assigned to a certain user.