Databases Reference
In-Depth Information
Creating and Browsing
Tables
Having seen the overall layout of phpMyAdmin, we are ready to create a database,
create our first table, insert some data into it, and browse it. These first steps are
intentionally simple, but they will give you the foundation on which more complex
operations will be achieved later. At the end of the chapter, we will have at our
disposal the two basic tables on which the remaining exercises are based.
Creating a database
Before creating a table, we must ensure that we have a database for which the
MySQL server's administrator has given us the
CREATE
privilege. The following
possibilities exist:
• The administrator has already created a database for us, and we see its
name in the navigation panel; we don't have the right to create an additional
database.
• We have the right to create databases from phpMyAdmin.
• We are on a shared host, and the host provider has installed a general web
interface (for example, cPanel) to create MySQL databases and accounts; in
this case, we should visit this web interface now and ensure we have created
at least one database and one MySQL account.
The
Databases
panel in
Server
view is the place to go to find the database creation
dialog. Note that a configuration parameter,
$cfg['ShowCreateDb']
, controls the
display of the
Create
new
database
dialog. By default, it is set to
true
, which shows
the dialog.
Search WWH ::
Custom Search