Re: [cobalt-users] (no subject)

[Rik Thomas <rikt@xxxxxxxxxxxxxxxx>]

On Fri, 27 Apr 2001, The Thieving Gypsy wrote:

> Hi list,
>
> We have MySql running on a RaQ4 server.  Are there any server permissions
> that could lead to us being unable to change the user priviledges on the
> mysql user and db tables.  The only way of accessing the table of the
> databases on the server is through the root user and password.  Creating new
> users and identifying passwords makes difference to this situation.  Are
> there server permissions which are overriding these mySQL users?
>
> Cheers,
>              Dave Rowlands

Not sure I fully understand your question.  However, the initial install
of mysql on has a root user.  You have to add users manually to provide
additional and safe access to mysql.  You basically have two levels of
access, Serverwide (able to work basically with any database and table)
and database wide (able to do just about everything to only one database),
ofcourse it is much more complicated than that.  But check out
http://www.devshed.com and go to the mysql section there is a great
article on mysql security.

To add a user called dave to a database called gerbils  you would do
something
like this.

/usr/local/mysql/bin/mysql -u root -p mysql
mysql> GRANT ALL PRIVILEGES ON gerbils.* TO steve@localhost IDENTIFIED BY
`password' WITH GRANT OPTION;
mysql> exit

now test what you did:
/usr/local/mysql/bin/mysql -u steve -p mysql


now if you just wanted to give steve non administrative access to the
database.

mysql> GRANT SELECT,INSERT,DELETE,UPDATE on gerbils.* TO steve@localhost
IDENTIFIED BY `password';


HTH

-- 
Rik Thomas
rikt@xxxxxxxxxxxxxxxx
Is your Website Smart?
Automated Website backups.