[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-developer
Subject:    Re: Mysql::help
From:       Tonu Samuel <tonu () mysql ! com>
Date:       1999-10-15 7:55:05
[Download RAW message or body]

AChawla@NIIT.com wrote:

> I want to create/manage user accounts on the Mysql server database. How do I
> go about it? Pl. suggest reading material on mysql server admin. I actually

Check out the manual on http://www.mysql.com

> 1. How do I create a user

GRANT command

> 2. How do I delete a user

REVOKE command

> 3. How do I assign rights for a user on database objects

GRANT command

> 4. How do I get the info about database objects, as in, their state, rights
> assigned to them, etc. etc.

SHOW command

> 5. How do I know, how many databases are their in the mysql server

mysql -b -S -e "show databases" | wc | cut -b -6


BTW, this is not a list for general development things. This is only for
mysql internal development. Please go to mysql@lists.mysql.com


-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@mysql.com        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail developer-thread331@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail developer-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]