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.
No privileges
If you do not have the privilege to create a...