List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 4 1999 11:09am
Subject:Re: privileges
View as plain text  
On Mi, 1999-08-04 12:24:56 +0200, Damien Richard wrote:
> after creating a database, why i don't see this database in the
> table mysql.db ???

The tables user, host, db, table_priv, and column_priv of the mysql
database only manage the access priviledges.

To see what databases and tables exists, use the SQL statements
     SHOW DATABASES;
and  SHOW TABLES FROM db_name;

Or use the equivalent shell command lines
     mysqlshow
and  mysqlshow db_name

For details on the SHOW statement, see MySQL manual chapter
"7.20 SHOW syntax (Get information about tables, columns...)".

For details on the command mysqlshow, see MySQL manual chapter
"12.1 Overview of the different MySQL programs" and simply run
     mysqlshow --help

For details on MySQL's priviledge system, please have a look
at chapter "6 The MySQL access privilege system".


In short:  the MySQL manual is _definitely_ worth a read! :)


For a nice introduction you might like the articles at
   Developer Shed
   <URL: http://www.devshed.com/Server_Side/MySQL/ >
especially the
   Beginning MySQL Tutorial
   <URL: http://www.devshed.com/Server_Side/MySQL/ >.

How I did find these links?  Just look at the obvious place:
   MySQL Documentation
   <URL: http://www.mysql.org/doc.html >

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
C executable hanging on LinuxMedhat Mourid4 Aug
  • privilegesDamien Richard4 Aug
    • Re: privilegesMartin Ramsch4 Aug
    • privilegessinisa4 Aug
    • Re: privilegesPaul DuBois4 Aug
    • Re: privilegesRalph Graulich4 Aug
  • C executable hanging on Linuxsinisa4 Aug
    • C executable hanging on LinuxMichael Widenius4 Aug