Phpmyadmin graphic configuration function usage tutorial

In the previous phpmyadmin tutorial, I introduced a lot of phpmyadmin configuration knowledge. in phpmyadmin3.4, the graphical phpmyadmin configuration function is displayed, this article mainly introduces phpmyadmin in The phpmyadmin tutorial in the form of a graphical interface, including phpmyadmin server configuration, phpmyadmin function configuration, SQL query configuration, framework configuration, and phpmyadmin import and export configuration. configuration knowledge, the graphical phpmyadmin configuration function is displayed in phpmyadmin3.4, the phpmyadmin configuration file is operated on a Gui from the following aspects: phpmyadmin server configuration, phpmyadmin function configuration, SQL query configuration, framework configuration, and phpmyadmin import and export configuration. Next I will introduce in detail how to configure phpmyadmin through the graphical interface.

　　Preparations

To use the phpmyadmin graphical configuration function, you need to create a readable and writable config folder, which is mainly used to store the server information of phpmyadmin configuration. this is described in the phpmyadmin3.4 installation and configuration tutorial.

　　Phpmyadmin graphic configuration interface

　　Log on to the phpmyadmin console., Click the Settings menu,

Start phpmyadmin configuration

In The phpmyadmin settings menu, the default phpmyadmin server configuration function is provided. you can also import the saved phpmyadmin configuration file or The phpmyadmin configuration information in the browser, you can also restore phpmyadmin to the default configuration. When you need more phpmyadmin configuration management, clickInstallation Script.

　　Use phpmyadmin to configure the server,

Phpmyadmin server overview configuration

Phpmyadmin create server configuration

In the above two phpmyadmin configuration interfaces, you can click the Create server button to create your own phpmyadmin server information, the created phpmyadmin server information can be displayed, downloaded, saved, loaded, and deleted. Note that the installation environment of phpmyadmin selects the appropriate line break. Click the question mark icon to view the description of the Servers configuration option in the phpmyadmin configuration file.

　　Phpmyadmin function configuration page

Phpmyadmin function configuration page

On the phpmyadmin function configuration page, you can configure various headers, including import/export, security, phpmyadmin, and phpmyadmin system running environment, for example, you can set the phpmyadmin Upload folder directory, compression settings, and logon mode security settings.

　　Phpmyadmin SQL query configuration page

Phpmyadmin configures SQL queries

You can use the phpmyadmin graphical configuration interface to configure SQL statements, including SQL query settings, SQL query box settings, and SQL checker. The SQL query settings mainly configure various restrictions for SQL queries. the SQL query box settings mainly configure various functions of the SQL query box, such as editing and creating PHP code; the SQL checker mainly configures whether to store all SQL statements anonymously. it requires PHP SOAP extension support.

　　Phpmyadmin navigation framework interface configuration

Phpmyadmin left-side framework configuration

Framework on the right of phpmyadmin configuration

The phpmyadmin navigation framework configuration function configures the left-side navigation interface after logging on to phpmyadmin and the right-side homepage framework interface.

　　Phpmyadmin import and export configuration

Phpmyadmin configures various supported import file formats

Phpmyadmin configures supported export file formats

In the above configuration interface, we mainly configure various import and export file formats supported by phpmyadmin, which mainly targets the phpmyadmin function for importing and exporting databases. Note that when you configure the phpmyadmin import and export file format, it is recommended that the import and export configurations be the same; otherwise, errors may occur. for example, the csv format separators for import and export are inconsistent, this will cause an import/export error.

　　Special reminder: When using the phpmyadmin graphical configuration function, pay attention to click the save button below each configuration item.

Now, The phpmyadmin graphic configuration function has been introduced. you can see that phpmyadmin3.4 graphic configuration interface is more intuitive and easier to understand the phpmyadmin configuration file config. default. various configuration options of php will be of great help to friends who use phpmyadmin for the first time.