two db one cannote delete the other

[rob2]

example in a server there are two sitos;
eachone has its db;
in a sites a bad customer can insert bad code for delete table and itself database; is possible to limit its action only at its db?
this because in his site with a drop command can delete every
db in the server;

I know one solution is not assign at it the privilege drop;
but if I want assign all privileges but the site's owner can only use inner
is db and not external;

[earl-grey]

You can have two users: one (admin) for yourself, another (limited to one database) for script.

[rob2]

how is possible make
another (limited to one database) ?
for example with phpmyadmin and mysql .

if I have db1 and db2 (inner server)
is possible to limit user db1 to make action on db2?
example: to block also this action:
db1's user, that insert sql injection in is db1 for delete db2.

So, the concept of limitation, that you intend, remain valid also for this case?

[earl-grey]

GRANT ALL PRIVILEGES
   ON test.*
   TO 'anotheruser'@'localhost'
IDENTIFIED
   BY 'goodsecret'