------------------------------------------------------------------------------- Commands in 'discovery' order... mysql --user {username} --host {network_name} --password Password: ***** show databases; What database (table sets) you have access to. use {database} Work in this database set show tables; What tables are in this database describe {table}; What columns and types are in this table show create table {table} The command to use to re-recreate the table (does not show REFERENCES comments) -------- Create Table create table {table} ({name} {type},... ); to modify you need to use alter table .... Add data to tables.... load data insert ------------------------------------------------------------------------------- Administer Creating a Database (administrator) Adding users Granting Access -------------------------------------------------------------------------------