[cobalt-users] Re:How to create a MySQL database for a user using Webmin

[Charlie Summers <charlie@xxxxxxxxxx>]

At 3:48 PM -0400 7/8/02, Micha Kagie is rumored to have typed:

> Is there somebody who knows the neccessary steps in Webmin to create a MySQL
> database for a user?
<snip>
> Or what I have to fill in phpMyAdmin, because there seems to be 2 logins:
> ['controluser'], ['controlpass'], ['user'] and ['password']?

   Here's an idea...go to www.mysql.com and read CAREFULLY about database
access controls. MySQL has some excellent security, but you should take the
time to LEARN how to use them instead of looking to silly web-based GUIs to
do it for you. I can promise you, if you do, you'll leave holes for someone
to exploit. There is a large section of the documentaion (section 4, narrowly
4.1 but read all of Section 4 if you really want to be able to sleep well at
night) dealing with the access system...read it. Twice.

   I mean, this is NOT difficult to learn (using the console in a shell to
create databases and tables is actually MUCH easier than screwing around with
phpMyAdmin, IMHO), is extrordinarily powerful (accounts can be limited to or
granted as much power as you want, fine-tuned to an almost unbelievable
level) and is information every systems administrator should know. Maybe your
users can limit themselves to some GUI, but the systems administrator should
UNDERSTAND how MySQL's access system operates.

         Charlie (who frequently tills at windmills by maintaining that
                   people who operate servers should actually take the time
                   to understand them)