Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
password only for a specific database

Posted by shrii2006 (shrii2006), 12 May 2008

I want to know whether it is possible to  give a password to a particular database in Mysql.

Im working with linux and using the database as a root.. there are others who know the root password. So i want to secure my database by giving it a password that no one else logging in as  root can know..

Posted by admin (Graham Ellis), 12 May 2008
You should have a database admin account (it doesn't need to be called root, by the way) that's not common knowledge - i.e. is only used by tha admin. Other accounts should be granted access as required to other databases, and should not be granted access to the database you want secured.

Problem solved for you ... but in a different way to you proposed.

This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho