What have i done? adding new db
Kevin: A database is, in some sense, a container for your tables. It sounds like you want to compose a new container. Thus, To list your databases (containers): mysql show databases; ... it seems that the list should contain your dbb and mysql, probably also test. To create a new database (container): mysql create database new_dbb; Next, you would be able to use new_dbb; and begin creating tables in it, using the 'create table' SQL statement. Cheers, Kent. - 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
What have i done? adding new db
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!! 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 - 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
Re: What have i done? adding new db
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