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

["Jonothon Ortiz" <jon@xxxxxxxxx>]

>>   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.

Webmin/PHPMyAdmin are a bit lax on the security. The best thing you can do
is to do everything from the shell. Get used to writing SQL scripts to help
automate your db work. I use the Access2SQL 2000 script for creating
individual tables and a matching form for quick data entry - this is
probably the one thing that is a bit of a pain in MySQL.

A good book is the MySQL red book (big red) from New Riders; they provide
the docs in an easy to follow book format. It's not a tutorial or a how-to,
regardless of what people may say. A good SQL tutorial would be Ben Forta's
SQL in 10 minutes book (http://www.forta.com) - I highly recomend this book
and the "Database Design for Mere Mortals" book (you can find this one at
forta's as well)

HTH