At 2:18 PM -0700 9/11/01, Kevin Tomasek wrote:
>I am very much a part mysql db administrator, this is an appology for my
>ignorance.
>
>we are using mysql for 2 databases that are functioning normally. people
>add and access information without problem.
>
>i wish to add a third. i don't recall the exact process that i went through
>before to add the second. in the process i have become more comfortable
>with mysql and database access so i have become somewhat dangerous.
>
>what i see is.. i enter mysql database as admin user from the command line.
>
>mysql> use mysql;
>mysql> show tables:
>
>stuff..
>columns_priv
>db
>func
>host
>tables_priv
>user
>end of stuff..
>
>mysql> select * from db;
>
>stuff..
>% | test | ..............
>% | dba |..............
>end of stuff..
>
>one of the two db's that we are using, dbb, is not shown!!
The db table doesn't necessarily list all the databases that are hosted
by your server. It only lists those for which you have explicitly granted
privileges to users. And if users have global privileges (as defined in
the user table), they don't need to have privileges listed in the db table.
So I would guess that you can use the database when connected to the server
as a user that has global privileges (such as root), and not when connected
as an ordinary user without such privileges. Is that the case?
>
>mysql> use dbb;
>mysql> show tables;
>
>stuff..
>
>all of the tables exist!!
>
>end of stuff..
>
>why doesn't dbb show up in the db list??? this data base is in use and
>functioning, what did i do to create this in such a manner that it doesn't
>show up??
>
>the end goal is to add another db with out clobbering what already exists
>and if it only partially exists now it would seem that i have a pretty good
>chance of messing something up along the way.
>
>thanks. kevint
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
