At 9:44 -0500 4/21/05, Scott Purcell wrote:
Hello,
I have created some databases and tables, a while back, as a new
user. I believe when the system was installed it asked me fora root
username and password. And I set one.
I have some databases, and I would like to find out two things:
1) Who owns what database and its tables: Is there a command to find this out?
In terms of filesystem ownership, the database directories should be set
to be owned by the same login account that you use for running the server.
In terms of ownership by MySQL accounts, there is no such concept.
A given MySQL account can be granted permission to access a database, but
no account "owns" it.
2) If they are owned by root, can I create a new user and update the
database and its tables to that user?
You can grant access to the database for that user (with the GRANT
statement).
The user will not "own" the databases.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
