[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] Binding MySQL DBs to users



> Yes,  you just need to chown the database files to the specific user.
<snip>
> You'll ofcourse need the MySQL daemon to access the file, and as you
> shouldn't run that as root, you'll need the database files to be readable
by
> the group. Chgrp the files to the mysql user.
<snip>
> You could certainly do that too. I have earlier used a simple webpage,
that
> shows the size of the database of each user. It could probably be
integrated
> into the Cobalt GUI without too much trouble.
<snip>
> It's actually _very_ easy. Just do a "ls -l" on the database files, and
> you'll see how much space each table uses. So you can use something like
> this to view the size of each database:
> du -hs /home/MySQL/*

Thaaaaaaaaaaaaank you thank you thank you thank you thank you!!!
It even gives me the file sizes in kilobytes and megs, not bytes - so I
don't have to bust a vein translating bytes into meaningful measurements!

*happy happy joy joy*
Thanks again!

CarrieB