Difference between revisions of "Creating New Databases and Tables with MySQL Administrator"
(New page: Unless a database already exists, very little can be done with MySQL until a database with at least one table has been created. Databases and tables can either be created using SQL command...) |
|||
| Line 2: | Line 2: | ||
This chapter assumes you have an understanding of [[Database Basics|databases, tables and columns]] and have the MySQL Administrator installed, running and connected to a database server (see [[The MySQL Administrator Tool]] for details). | This chapter assumes you have an understanding of [[Database Basics|databases, tables and columns]] and have the MySQL Administrator installed, running and connected to a database server (see [[The MySQL Administrator Tool]] for details). | ||
| + | |||
| + | == Creating a New Database == | ||
| + | |||
| + | Once MySQL Administrator is running and connected to a database server, the first task is to create a new database. Begin by clicking on the ''Catalog'' option on the left hand side of the MySQL Administrator main window. The Catalog screen will then appear as follows: | ||
| + | |||
| + | [[image:mysql_admin_catalog.jpg]] | ||
Revision as of 19:12, 27 September 2007
Unless a database already exists, very little can be done with MySQL until a database with at least one table has been created. Databases and tables can either be created using SQL commands (typically using the mysql tool) or using a grpahical administration tool such as MySQL Administrator. In this chapter we will cover the creation of databases and tables using MySQL Administrator. If you prefer to use SQL commands to perform these tasks refer to Creating Databases and Tables Using SQL Commands.
This chapter assumes you have an understanding of databases, tables and columns and have the MySQL Administrator installed, running and connected to a database server (see The MySQL Administrator Tool for details).
Creating a New Database
Once MySQL Administrator is running and connected to a database server, the first task is to create a new database. Begin by clicking on the Catalog option on the left hand side of the MySQL Administrator main window. The Catalog screen will then appear as follows:
