About Security In MySQL

[itlike]

I had MySQL server (3.23.51) running in RH 7.3
My Database store very sensitive data.

Here are my questions :
1) Can I control by database even MySQL admin right
also can't access to the particular database ?
I only allow 1 particular have a full right on that
table. Because this database contain sensitive data even
administrator also not allowed to access.

2) if server OS admin copy the the database from 1 server
to another server. Can he/she to open this database
after copied to another server where he/she have the
full right ? Can we control even copy to another server,
he/she cannot open this database ?

 

[piti]

hi

1) it is possible to set up, that the mysql admin account canot access your sensitive data
BUT - admin account has grant rights, so he can change it ;-)

2) if you have access to the datadir (it doesn't need to be admin) and you move the databases to another mysql server, the rights on the new server are applied to this database

you'll have to trust your admin