- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Marc Delisle
- 615字
- 2021-08-20 15:55:25
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 database, the panel displays a No privileges message under the Create new database label. This means that you must work with the databases already created for you, or ask the MySQL server's administrator to give you the necessary CREATE privilege.
Note
If you are the MySQL server's administrator, refer to Chapter 19.
First database creation is authorized
If phpMyAdmin detects that we have the right to create a database, the dialog appears as shown in the following screenshot:
In the input field, a suggested database name appears if the $cfg['SuggestDBName'] parameter is set to TRUE, which is the default setting. The suggested database name is built according to the privileges we possess.
If we are restricted to the use of a prefix, the prefix might be suggested in the input field. (A popular choice for this prefix is the username, which might or might not be followed by an underscore character.) Note that, in this case, the prefix is followed by an ellipsis mark, added by phpMyAdmin. We should remove this ellipsis mark and complete the input field with an appropriate name.
The Collation choice can be left unchanged for now. With this dialog, we could pick a default character set and collation for this database. This setting can be changed later (refer to Chapter 9 for more information on this).
We will assume here that we have the right to create a database named marc_book. We enter marc_book in the input field and click on Create. Once the database has been created, we will see the following screen:
Notice the following:
- The title of the main panel has changed to reflect the fact that we are now located in this database
- The navigation panel has been updated; we see marc_book
- By default, the SQL query sent to the server by phpMyAdmin to create the database is displayed in color
As the generated queries could be large and take much of the on-screen room, the $cfg['MaxCharactersInDisplayedSQL'] acts as a limit. Its default value of 1000 should be a good balance between seeing too few and seeing too many of the queries, especially when doing large imports.
It is important to examine the phpMyAdmin feedback to ascertain the validity of the operations we make through the interface. This way, we can detect errors like typos in the names, or creation of a table in the wrong database. phpMyAdmin retrieves error messages from the MySQL server and displays them on the interface.
- Java程序設計（慕課版）
- Boost程序庫完全開發指南：深入C++”準”標準庫（第5版）
- Web前端開發技術：HTML、CSS、JavaScript（第3版）
- 國際大學生程序設計競賽中山大學內部選拔真題解（二）
- C語言程序設計案例教程（第2版）
- Java高并發核心編程（卷2）：多線程、鎖、JMM、JUC、高并發設計模式
- Power Up Your PowToon Studio Project
- ASP.NET動態網頁設計教程（第三版）
- Flash CS6中文版應用教程（第三版）
- UI設計全書（全彩）
- Spring技術內幕：深入解析Spring架構與設計原理（第2版）
- Arduino Wearable Projects
- C++ System Programming Cookbook
- AMP：Building Accelerated Mobile Pages
- Instant Automapper