protect my database - your advsie plz

[Jassim Rahma]

Hi, I have a project with MySQL server database. unfortunately, MySQL doesn't provide a feature to password protect my database (unlike Microsoft SQL Server). So what's your advise? Shall I install my application on a separate MySQL instance so I will only have the password?

Technology News @ www.JassimRahma.com

[GuyThiebaut]

mysql password protect database[^] ;)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

[Jassim Rahma]

but this will protect the server! What I want is to give my database a password so their administrator who'll access the same server won't be able to access my entire database even if he has a root for the same server because my database is password protected. This option is available in Microsoft SQL Server and it's working great

Technology News @ www.JassimRahma.com

[Richard Deeming]

Jassim Rahma wrote:

This option is available in Microsoft SQL Server and it's working great

Are you sure about that? Any administrator of the domain / local machine can easily give themselves unrestricted access[^] to a SQL instance, even if they're not set up as a user in SQL.

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Lost User]

Jassim Rahma wrote:

So what's your advise?

Webservices, and hosting the server yourself. Easy argumentation; you'll only be the database-admin if the server is yours.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]