On Dec 22, 2006, at 9:10 AM, toby privett wrote:
Prithvi Krishna Mandava
No, sudo runs a command as the user ‘root’ on the operating system
The user named ‘root’ for MySQL is all-powerful, but only within the
database, not the entire system.
I suspect that you’re logged in as a user named ‘ODBC’ or perhaps
there is an environment variable that mysql picks up as the user
(try: env | grep -e ODBC ). Doing the initial creation of the
database (i.e., depot_development) is often done as the “mysql -u
root” user, but then you typically also create a user to be used for
that database (doesn’t have to be exclusive) and the tables within
that database are created by the non-root user.
Rob B. http://agileconsultingllc.com