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. Various possibilities exist:
The administrator has already created a database for us, and we see its name
in the left 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.
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 this dialog.
No Privileges?
In this case, the Home page looks like the following screenshot:
??? ??? ???
First Steps
[ 66 ]
This means that we must work with the databases already created for us, or ask the
MySQL server's administrator to give us the necessary CREATE privilege.
If you are the MySQL server's administrator, refer to Chapter 19, the
MySQL Server Administration section.
First Database Creation Is Authorized
If phpMyAdmin detects that we have the right to create a database, the home page
looks as shown in the following screenshot:
In the input field, a suggested database name appears if the
$cfg['SuggestDBName'] parameter is set to TRUE??”this is the default setting.
Pages:
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88