RE: [cobalt-users] mySQL on RaQ2

["Neil J. Kemp" <neil@xxxxxxxxxx>]

I hope you're confusing tables and databases here as only YOU (Server Admin)
should have the root MySQL access to create databases. When you create
databases and MySQL users you give them rights to specific databases in
which they can create TABLES inside the databases.

The permissions are set by you. Here's an example:

$ mysqladmin -u root -p create mysteria

(Creates database call mysteria)

$ mysql -u root -p

(Logs into mysql)

GRANT ALL PRIVILEGES ON mysteria.* TO clive@localhost IDENTIFIED BY 'smith'
WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON mysteria.* TO clive@"%" IDENTIFIED BY 'smith' WITH
GRANT OPTION;

FLUSH PRIVILEGES;

(Will enable a user called 'clive' with a pass of 'smith' to use the
database 'mysteria' However you will want to be read on
http://www.mysql.org/ to get the exact permissions commands. Localhost
should be more than enough unless some strange need.)

mysqladmin -u clive -p password smith

(Will setup user clive with password smith - please note this is NOT the
same as the Linux password)

Hope that helps

--Neil